Parse email body

[adehaan11]

Hey,

I have a flow that is triggered when a new structured email arrives in a shared mailbox. 

Every email that comes in will have the same format, as follows:

"

Person A: emailaddress1@example.com

Person B: emailaddress2@example.com

Dear xxx,

Blah text

Blah text

Blah text

Kind regards,

yyy

"

I would like to parse out this email body into three seperate variables that can be used later in the flow.

More specifically, 1 variable for Person A's email, 1 for Person B's email, and a third to collect the remainder of the text (From Dear xxx to kind regards yyy). 

What is the best way to go about this? 

I tried this approach https://365basics.com/microsoft-flow-parse-email-and-extract-information/

but I was having trouble seperating each line for the array.

I also took a look at https://powerusers.microsoft.com/t5/Building-Flows/Using-a-flow-to-extract-email-body-details/m-p/31...

but not too sure how to use the "html to text" activity and after parsing that value. 

Thanks for your help!

[v-bacao-msft · Accepted solution]

Hi @adehaan11 ,

Please try to refer the following threads to extract the data from the email body:

https://powerusers.microsoft.com/t5/Building-Flows/Extracting-text-from-email/td-p/334919

https://powerusers.microsoft.com/t5/Building-Flows/Extract-text-from-body-of-an-email-and-create-new...

Best Regards,

[adehaan11]

Thank you @v-bacao-msft .

Easy to follow and did the trick 😃

[dedus_alelus]

It depends on where you want to send the information. For example, if you want it to auto-complete fields and tags in a ticket, you can have a quick look into this add-on on Zendesk Marketplace: 

https://www.zendesk.com/marketplace/apps/support/810637/ticket-parser-by-knots/

I hope it solves your problem and cuts off the manual work.