How to Extract a Specific Line Containing an Email Address from an Email Body

(1) Share

Report

Posted on by EI-06081227-0

Hello,

I'm working on a flow in Power Automate to extract a specific line from the body of an email.

The goal is to retrieve an email address that appears after a specific keyword in the email body. For example, my output text from a substring action (outputs('Substring')?['body']) looks like this:

I want to extract only the email address "Dein.Doe@Aimsts.com" from this text. However, the format is not consistent and can sometimes be:

"E : Dein.Doe@Aimsts.com,"
"Mail: Dein.Doe@Aimsts.com "

Is there a way to reliably extract only the email address regardless of these variations?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Will the email domain always be the same as in your example?

There are going to be loads of ways of how to do this, but if its the same then you could

Here are the steps and total code

1. Split by :

Split(HTMLText, ':')

You end up with ' Dein.Doe@Aimsts.comand the rest of the stuff'

2. Split(Split(HTMLText, ':'), '@Aimsts.com)')

3. You want the first part of step 2

Leaves you with 'Dein.Doe' in position [0] of the array created by the split

So you want to concat the

4. concat(trim(split(split(HTMLText, ':'), '@Aimsts.com)')[0]), '@Aimsts.com')

But the above splits it at the :, then splits it again by the Domain, gets the array index 0 and trims any spaces, then puts the EmailDomain back. since it was part of the larger [1] index of the split

If you have to use other email address's then we can do it another way, you can also use regular expressions

Was this reply helpful? Yes No
EI-06081227-0 8 on at

Like (1)

Report
Copy link

Link copied!

HI @FLMike, thank for your answer

yes the domain will always be the same but is it also can be retrieved if the the format only like this ?

200

Dein.Doe@Aimsts.com

www.Aimsts-pharma.com?

And is it possible to retrieved the email with different domain?

Was this reply helpful? Yes No
Chriddle 8,674 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Since the "specific keyword" is not specific, it might be a good idea to check just for email addresses

(OK, contains an "@" is not a thorough check, but you can easily extend this by looking for other characteristics if necessary):

split( replace( outputs('Compose'), decodeUriComponent('%0A'), ' ' ), ' ' )

Was this reply helpful? Yes No