cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adehaan11
Frequent Visitor

Parse email body

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!

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

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,

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

View solution in original post

2 REPLIES 2
v-bacao-msft
Community Support
Community Support

 

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,

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

View solution in original post

Thank you @v-bacao-msft .

 

Easy to follow and did the trick 😃

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (842)