Problem with extracting text from an email

[Webfire]

Dear all,

with the help of @v-alzhan-msft  I created this flow for extracting a text from the body of an email.  For several days the flow has been going wrong. But not all the times. Sometimes it works, sometimes it doesn't. The error is always the same:

and always appears on the creation of the last variable (Posizione). Here is an example of the content of the "initialize Variable" Box

Segnalato da: cristian nallino Commento: testo unico di legge elettorale
Posizione: No address available

Segnalato da: Cristian Nallino Commento: questa vita non ha una birra 2
Posizione: No address available

Why does the flow fail? You can help me?

Thanks

Cristian

[abm]

Hi @Webfire 

Could you please post your sample data which is failing?

[Webfire]

Hi @abm 

These two sample are extracted from the "initialize Variable" Box. With these the flow fail.

Segnalato da: cristian nallino Commento: testo unico di legge elettorale
Posizione: No address available

Segnalato da: Cristian Nallino Commento: questa vita non ha una birra 2
Posizione: No address available

Thanks

Cristian

[abm]

Hi @Webfire 

Forgot to ask you earlier. Also could you please post the step Posizione expression you are using?

[MattWeston365]

Also please let us know what you're splitting on. The error is because when the split expression runs it is only finding one instance of the split character. So where you're looking for index 2, only index 0 and 1 exist.

[Webfire]

@abmof course

Initialize variable - Name:EmailText - Type: String - Value:The Plain text Content
Split Texts with Keywords - Name:TextSplit - Type: Array - Value:split(replace(replace(replace(variables('EmailText'), 'Segnalato da: ', ''), ' Commento: ','||'), ' Posizione: ', '||'), '||')
Segnalatoda - Name:Segnalatoda - Type: String - Value:variables('TextSplits')[0]
Commento - Name:Commento - Type: String - Value:variables('TextSplits')[1]
Posizione - Name:posizione - Type: String - Value:variables('TextSplits')[2]

@MattWeston365 

This flow create an item in a Sharepoint list. The flow convert the body of the email in text. The output are this:

Segnalato da: cristian nallino Commento: testo unico di legge elettorale
Posizione: No address available

Segnalato da: Cristian Nallino Commento: questa vita non ha una birra 2
Posizione: No address available

From this output the flow extract text from "Segnalato da:" to "Commento:", from "Commento:" to "Posizione:" and from "Posizione:" to the end of the body of the email

Thanks

Cristian

[abm · Accepted solution]

Hi @Webfire 

Yes I found the issue

You had the split expression as below

split(replace(replace(replace(variables('EmailText'), 'Segnalato da: ', ''), ' Commento: ','||'), ' Posizione: ', '||'), '||')

Change this to

split(replace(replace(replace(variables('EmailText'), 'Segnalato da: ', '||'), ' Commento: ','||'), ' Posizione: ', '||'), '||')

The issue you have here is you are replacing 'Segnalato da:' with '' (blank) instead of '||'

I did tried changing to pipe character and working as expected.

Thanks

[v-alzhan-msft]

Hi @Webfire ,

Please take a try with @abm 's solution and let me know if your problem could be solved.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Webfire]

Hi @abm and @MattWeston365 

thanks for your help. I had modified the expression and the data was extracted correctly. I have also modified the expression of the textsplit because the exctracted text was insered in the wrong variable. Here below there is an expample:

Html to text outputs: 

Segnalato da: Cristian Nallino Commento: segnalazione dal ced Posizione: No
address available

Split Texts with keywords Outputs:

[
"",
"Cristian Nallino",
"segnalazione dal ced",
"No\naddress available"
]

I have modified this expressions:

Segnalatoda from : variables('TextSplits')[0] to variables('TextSplits')[1]

Commento : variables('TextSplits')[1] to variables('TextSplits')[2]

Posizione : variables('TextSplits')[2] to variables('TextSplits')[3]

With this changes the flow works correctly.

Thanks

Cristian