Parse an email for content in the body

(0) Share

Report

Posted on by Yacob_hard

Hi there,

I'm trying to build a flow where the following happens;

1. Contact Us email is received

2. Flow picks the email address out of the of the body of the received email

3. Flow delivers an email to the email address provided

I'm struggling to find an adaptable solution to #2.

Here's the format of an email i'd want the flow to read;

First name: *****

Last name: *****

E-mail: ******@live.co.uk

May we contact you about news and offers: yes

Message: How can I do x while y?

The "First name", "Last name", and "E-mail" output are all of variable lengths (determined by the users who input) and so existing solutions i've found on the forums don't seem to help (as far as i can understand);

https://powerusers.microsoft.com/t5/Building-Flows/Read-email-content-from-body-of-the-email-extract-and-create/td-p/87093

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Using-a-flow-to-extract-email-body-details/m-p/149186

Any suggestions would be welcome! 🙂

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Hi @Yacob_hard ,

Please refer to the screenshots below and replicate the steps.
The initialise variable 2 has the value set as an empty line. You can do that by clicking on the value and pressing enter.
In the compose action, use this expression
split(Variables('ww'), variables('test'))
Replace the variable names with the ones you create.
In the set variable value, use the expression:
split(items('Apply_to_each'),':')[1]
This will fetch you the email address.

Important Note: This will work as long as there is no mention of 'E-mail' before the actual E-mail: xyz@acd.com.

Hope this helps.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Yacob_hard 69 on at

Like (1)

Report

Thanks @yashag2255 , that's worked perfectly.

My first time working with variables in flow 🙂

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Awesome! Glad that it worked.

Thanks,

Was this reply helpful? Yes No
Yacob_hard 69 on at

Like (0)

Report

Hi @yashag2255,

Thanks again for providing the solution.

I'm struggling to understand how this works, in particular;

1. Why does variable 2 need to be set as blank with 2 lines?
2. How does the compose action pull out an appropriate value?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hey!

1. The variable has the value (/n/n this is basically a new line)
In the email we have the First Name in first line and Second in Second and Email in third etc. So we split the email body on that new line component and get the desired email value by the other filter.
2. Refer to the formula used in compose: It gives the array as we required and mapped in the pt. 1.

Hope this helps.

Was this reply helpful? Yes No