remove blank spaces when new email arrives as per steps mentioned

[Veblitz]

Email template which arrives with below format //Incoming email format

When we recieve incoming Email with below predefined email format then in my flow i have put indexes as per  it works ,please see my flow  but i need some help to remove unnecessary blank spaces from email . im not sure how to remove blank spaces in the new email .

Indexes fixed: //so its working but at the same time if its blank spaces exceeds below indexes values its failed

variable 3 expression :last(split(outputs('Compose_2')[6],': '))

variable 4 expression: last(split(outputs('Compose_2')[8],': '))

variable 5 expression: last(split(outputs('Compose_2')[12],': '))

Input data structure

Contract_List:

Customer-single line of text

Location- single line off text

Typeofcontract-Single line of text

From-single line of text

To-single line of contract

document library

Complete Flow details:

Detailed flow steps:

compose 2 expression-

split(outputs('Html_to_text')?['body'],outputs('Compose'))

Detailed step by step condition flow steps

Yes branch flow steps

variable 3 expression :last(split(outputs('Compose_2')[6],': '))

variable 4 expression: last(split(outputs('Compose_2')[8],': '))

variable 5 expression: last(split(outputs('Compose_2')[12],': '))

create new folder2 expression : concat(variables('Location'),'/',variables('Customer'))

create new folder 3 expression:

concat(variables('Location'),'/',variables('Customer'),'/',formatDateTime(utcNow(),'yyyy'))

create new folder 4 expression:

concat(variables('Location'),'/',variables('Customer'),'/',formatDateTime(utcNow(),'yyyy'),'/',formatDateTime(utcNow(),'MMMM'))

set variable 2 expression:

concat(variables('Location'),'/',variables('Customer'),'/',formatDateTime(utcNow(),'yyyy'),'/',formatDateTime(utcNow(),'MMMM'))

create new folder 5 expression:

concat(variables('VarPath'),'/',variables('VarType'))

No branch:

[developingteal]

Removing blank space on it's own does not work, I learned that the hard way. Here's what you need to do - replace all spaces (' ') with some other character which doesn't show up (ie '|'). Then you can remove all '|'.

If that does not work, I have a long way to do it - split on the '|', then filter the array to filter '|', then rebuild the string with what remains. 

Let me know if you need more help or specifics!

Be sure to kudos and like accordingly!

[Veblitz]

Can you please help with my above flow how to use the logic in removing unnecessary spaces from email

[developingteal]

I can't really figure out where you want the blanks to be removed to be completely honest - can you tell me where?

I also realized my methodology only applies to the invisible spaces - which should be extra - is that what you are looking for?

[Veblitz]

As of now my flow is extracting values from email based on line number which is indexes so is there a way to remove blank spaces invisible 

[Veblitz]

As per the below incoming email we are extracting values for below details and create item in list and adding attachment based on the email metadata so our issue is if the below email got some invisible blank spaces then flow is not working,reason is that our flow is creating list item etc based on indexes so if there are any spaces invisible then it causing error 

[developingteal · Accepted solution]

ok yeah, just apply the methodology I gave above to the body of the email, then parse and do whatever you want with it

[Veblitz]

i dont know how to apply in my flow above steps,please help

[developingteal]

run it after your html to text

[Veblitz]

split on the '|', then filter the array to filter '|', then rebuild the string with what remains- How to form this as expression ,apologies as im not much proficient on this stuff.

Kindly shed some light