What is the easiest way to extract an email address from an unstructured message body?

(0) Share

Report

Posted on by jeff-no-code

Hi...first time using Power Automate.

I have watched so many videos and read tons of articles, and now I am lost.

Problem: We get lots of email replies and bounce-back messages from failed email delivery.

Getting the TO and FROM out of an email is straightforward.

Where I have a problem is how to extract any email address from an unstructured body.

Examples attached

Screenshot 2022-12-03 153538.png

Screenshot 2022-12-03 153255.png

Screenshot 2022-12-03 153737.png

There are so many variations of these emails. It would be easiest to pull all of the addresses out of the body and then have a filter rule that eliminates the addresses I do not want to append to an excel file.

Any help would greatly be appreciated.

TIA.

Screenshot 2022-1...

I have the same question (0)

All responses (5)

Answers (0)

VictorIvanidze 12,894 on at

Like (0)

Report

Re: What is the easiest way to extract an email address from an unstructured message body?

See https://www.tachytelic.net/2021/04/power-automate-regex/

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: What is the easiest way to extract an email address from an unstructured message body?

Hi Victor....

Thanks for your reply. It's an interesting solution. The only problem is that we receive 5-10K of these emails per day.

The article wrote:

The downside to this method is that the “Run Script” action is currently in preview, and it is limited to 200 executions per day. So depending on how frequently your flow runs, it might not be useful.

There is this video from Microsoft but I can not seem to get it to pull the email from the body.

https://www.youtube.com/shorts/dlHlAny2N1U

Was this reply helpful? Yes No
VictorIvanidze 12,894 on at

Like (0)

Report

Re: What is the easiest way to extract an email address from an unstructured message body?

Hi @Anonymous,

you said 5-10K emails per day to a single mailbox? I recommend you to create a prototype that retrieves only "From :" address (don't parse the body at all) and places it to Excel and test if it will work with such volume of emails.

Was this reply helpful? Yes No
VictorIvanidze 12,894 on at

Like (0)

Report

Re: What is the easiest way to extract an email address from an unstructured message body?

Hi @Anonymous,
any news?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: What is the easiest way to extract an email address from an unstructured message body?

Hi Victor....

We are parse all of these right now. At least the ones that need to be.

I think I am fine with the to and from. It seems to pick it up from the bounce file.

Let's call this solved until I hit the wall again 🤓

Was this reply helpful? Yes No