extract string from Message of outlook into an excel sheet

[Alice_italy]

hello all,

I need to extract a string from an email like the example:

PERSON: XYZ

BOX: 9999

ID:999

the flow have to take the informations of PERSON, BOX and ID, then put into an excel file the records

how I can?

thanks to all who help me

[efialttes]

Hi!

I would add an 'HTML to text' action block, assign as its input email body.

Next, I would use the following WDL expression to extract PERSON value

trim(first(split(last(split(body('HTML_to_text'),'PERSON:')),'BOX:')))

Similar approach for BOX:

trim(first(split(last(split(body('HTML_to_text'),'BOX:')),'ID:')))

Now, the ID is a little more tricky. We need a pattern always present after BOX value. Assuming a new line is always at its end I would try with the following WDL expression...

trim(first(split(last(split(body('HTML_to_text'),'ID:')),'
')))

...in this last WDL expression please remember to hit Enter key from your keyboard in between the last two single quotes

Hope this helps

[Alice_italy]

Hi @efialttes,thanks for your support,

I try following your instruction, like this?

attached you find also an e-mail sample and the excel result

thanks to your support

[efialttes]

Hi!

You added WDL expressions as plain text, which is a wrong approach.

Since you are unfamiliar with WDL expressions, please follow these steps to add them to an action block (both the expression and the action block in the video are not related to this issue):

https://youtu.be/LPZ-WZoWwp4

If video is not enough, this link is also helpful:

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

Thanx!

[Alice_italy]

Thank you for your support, but, unfortunately, the COMPOSE doesn't accept the formulas

[efialttes]

Hi!

As per your last screenshot I have realized you have 3 'HTML to text' action blocks and you also renamed them... this means you need to rebuild the WDL expressions I suggested relacing the standard name and using the new one

So if you rename 'HTML to text' into 'HTML to text Alice' you need to replace body('HTML_to_text') and use body('HTML_to_text_Alice') instead

Remember to replace spaces with _

Hope this helps

[efialttes]

One more comment:

You just need one 'HTML to text' action block, assign as its input email body from dynamic content menu.

Then I would add 3 different 'Compose' action blocks, assign the 3 suggested WDL expressions to each of them

Hope this helps

[Alice_italy]

unfortunately, doesn't work

[efialttes]

@Alice_italy 

I'm truly sorry, without a good screenshot of your current flow design and more information context I cannot suggest anything else. Good luck with your challenge and let's hope somebody else can point you to the right direction!