Split on delimiter

[Mimi123]

Hi all,

I tried to send an email in a standardized way (they have all the same delimiter). My flow works fine. But when it's not a standardized delimiter ':', it fails. I have to skip some lines, because there is no delimiter, but the code is not working. I will make 2 flows one with ':' and another with '\n'.

I only need the variables with ':', all the rest is not important in this flow. This is what I tried:

1. When a new email arrives V3
2. Html to text (contains the body of the email)
3. Compose email to body text (contains the body of html to text)
4. Compose with the function:split(outputs('Compose_Email_Body_Text'), '')
5. I initialized all my variables (name start with Var and they are all a string with no value)
6. Compose ExtractData:last(split(outputs('Compose_Email_Body_Text'), '\n\n'))
7. Then I extract all my variables withtrim(substring(split(outputs('ExtractData'), ': ')[1],0,indexOf(split(outputs('ExtractData'), ': ')[1], 'Numéro'))). I changed the [] for each code also the word that should be find for each Var. Here is the part where it sucks cause I have to skip some lines to get only those with the delimiter.

Setting up the variables and adding the output in the right column will work only if I am able to split it correctly.

Do you have any suggestions?

[v-jefferni]

Hi @Mimi123 ,

Could you please make examples of the two situations, give us email bodies to test with?

Best regards,

[Mimi123]

Hi @v-jefferni 

Sure here is the email that I send in a standardized way (it includes fake data and the flow works)

Rue : George Lambermont

Numéro : 111

Boîte : 12a

Code postal : 1478

Localité : Bourg-en-Bresse

Adresse d’expédition : Non

Téléphone :

Mobile : 4521397063

Email : test@gmail.com

Rappeler le client : oui

Code(s) EAN : 290524745299047160

Description : Le Lorem Ipsum est simplement du faux texte employé dans la composition et la mise en page avant impression. Le Lorem Ipsum est le faux texte standard de l'imprimerie depuis les années

This is the 2nd flow and include also fake data. As you can see they don't have all the delimiter ':'. The idea is to make 2 flows with the two delimiters and store each item in a variable.

Title

Standard info (not needed in power automate).

ID Agent : AZERT14

Client	Adresse concernée	Contact	Référence	Description
Jean Dupuis	Georges Lambermont 111   1478 Bourg-en-Bresse Adresse d'expédition différente : Non	Téléphone : Mobile : 4521397063 E-mail : test@gmail.com Rappeler le client : Oui	Code(s) EAN : 290524745299047160	Le Lorem Ipsum est simplement du faux texte employé dans la composition et la mise en page avant impression. Le Lorem Ipsum est le faux texte standard de l'imprimerie depuis les années

Footer text 

If you have any questions or remarks don't hesitate to ask 🙂

[Mimi123]

Hi @v-jefferni 

Sure here is the email that I send in a standardized way (it includes fake data and the flow works)

This is the 2nd flow and include also fake data. As you can see they don't have all the delimiter ':'. The idea is to make 2 flows with the two delimiters and store each item in a variable.

If you have any questions or remarks don't hesitate to ask 🙂

[v-jefferni]

Hi @Mimi123 ,

Please post the data of 2nd email body in TEXT, including the table, so that I can make a flow and check the result. Also, please highlight all the data you need in result.

Best regards,

[Mimi123]

@v-jefferni , 

Thanks for your reply.

Sure, you will find the table below. I put the info I need in red. 

Title

Standard info (not needed in power automate).

ID Agent : AZERT14

Client	Adresse concernée	Contact	Référence	Description
Jean Dupuis	Georges Lambermont 111   1478 Bourg-en-Bresse Adresse d'expédition différente : Non	Téléphone : Mobile : 4521397063 E-mail : test@gmail.com Rappeler le client : Oui	Code(s) EAN : 290524745299047160	Le Lorem Ipsum est simplement du faux texte employé dans la composition et la mise en page avant impression. Le Lorem Ipsum est le faux texte standard de l'imprimerie depuis les années

Footer text

[Mimi123]

@v-jefferni 

This is the output of the html to text:

Title 123

Information text

Is written

Like this

ID Agent : AZERT14

Client

Adresse concernée

Contact

Référence

Description

Jean   Dupuis

Georges lambermont   111  

1478   Bourg-en-Bresse

Adresse d'expédition différente :  Non

Téléphone : 

Mobile : 4521397063

E-mail : test@gmail.com

Rappeler le client : Oui

Code(s) EAN : 290524745299047160

Le Lorem Ipsum est simplement du faux texte employé dans la composition et la mise en page avant impression. Le Lorem Ipsum est le faux texte standard de l'imprimerie depuis les années

Footer text

[v-jefferni]

Hi @Mimi123 ,

I use a Compose to replace new lines with "/" in the outputs of HTML to Text, and save desired values in variables:

expression in Compose:

replace(replace(replace(outputs('Html_to_text')?['body'],decodeUriComponent('%0A'),'/'),'//','/'),'//','/')

expression for ID Agent:

split(split(outputs('Compose'),'ID Agent : ')[1],'/Client')[0]

expression for Adresse d'expédition différente:

split(split(outputs('Compose'),'différente : ')[1],'/Téléphone')[0]

expression for Code(s) EAN

split(split(outputs('Compose'),'Code(s) EAN : ')[1],'/')[0]

other values are basically all the same.

Best regards,

[Mimi123 · Accepted solution]

Hi @v-jefferni 

I tried to follow your steps but the run failed. This is my flow: 

For the compose action I used this: 

replace(replace(replace(outputs('Html_to_text')?['body'],decodeUriComponent('%0A'),'/'),'//','/'),'//','/')

For the ExtractAgent I used this: 

split(split(outputs('Compose'),'ID Agent : ')[1],'/Client')[0]

When I run the flow I have this error message: 

Is there something I'm doing wrong? 

[v-jefferni]

Hi @Mimi123 ,

Check the output of Compose, find ID Agent, I copied the delimiter "ID Agent : " and pasted in the expression.

you can copy and paste the whole outputs into notepad, find each delimiter and copy to respective expression:

Best regards,

[Mimi123]

@v-jefferni 

I had removed one space after 'ID Agent :' and it works. 

Thanks a lot !