Extract email address from email body in MS Flow

Like (1) Share

Report

Posted on 4 May 2024 09:30:53 by EM_

Dear friend,

As an administrator, I frequently receive the following email message in my inbox: I need to forward the same email to the user name, whose email address was extracted from the body of the email I got. In the following example, the forwarded email address is [marjori.mabilangan@worksmartbh.com].

Attached a copy of the email body

thank you in advance.

email-body.pdf

All responses (3)

Answers (0)

trice602 14,167 Super User 2025 Season 2 on 05 May 2024 at 16:20:52

Like (0)

Report

Re: Extract email address from email body in MS Flow

Thank you @AlexEncodian ! Good to know and will give it a go!
trice602 14,167 Super User 2025 Season 2 on 04 May 2024 at 23:41:29

Like (0)

Report

Re: Extract email address from email body in MS Flow

Hi @AlexEncodian ,

To clarify - this is absolutely 100% free with no credit card to sign-up, if a user wants to just use it for testing and development, up to 50 times/month?
trice602 14,167 Super User 2025 Season 2 on 04 May 2024 at 14:41:36

Like (0)

Report

Re: Extract email address from email body in MS Flow

Hi @ibeldesouki ,

I got this to work but you will have to run some different emails through this and see if it works for you. If the format is highly consistent, this may help.

Notice here, it is sent by with the space included at the end.

Next substring, starting position text send by output

Next compose.

Next text position from output of compose, searching to " to" with starting space.

Next text position from out of compose.

Last action, get the email.

Starting position expression:

add(body('Find_text_position_-_email_start'),4)

Length expression:

sub(add(body('Find_text_position_-_email_end'),-4),body('Find_text_position_-_email_start'))

Again, as I mentioned above, only you can decide if this pattern this will apply to all emails. I have used a handful of variations of this type of flow for more than a year and if the email format is highly consistent, then this will also be highly consistent.