How to extract only part of a line from an email (after the word email:)

(1) Share

Report

Posted on by ASmithRouse

I am attempting to extract an email address from the body of the email. I have successfully extracted the entire line that includes the email address; however, it is extracting the word "email:" as well. How do I set the expression so that only the email address (text after email:) is extracted in stead. Any insight and help is appreciated. Thank you

Picture A is the email that we receive
Picture B is first Compose
Picture C is the Second Compose

Picture D is the success output of the compose but includes "email" in the output which is what I am wanting to have not included.

A:

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello,

I prefer using the split(...) expression to extract piece of text, but you can use also slice(...) or substring(...) as explained in this article.

Was this reply helpful? Yes No
Suggested answer

BizAppBee 89 on at

Like (1)

Report
Copy link

Link copied!

Hi @ASmithRouse,

Please try the following expression:

Replace(First(Split(Last(Split(triggerBody()['text'], 'Email:')), 'Inquiry')),' ','')

I did a test on my end where for the purpose of this post I created a manual trigger flow. In the trigger text parameter I used similar content as your email body and then used the above formula in a compose

Hope it helps!

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Thank you!

Leoza

Was this reply helpful? Yes No
ASmithRouse 44 on at

Like (1)

Report
Copy link

Link copied!

@BizAppBee

This is not work unfortunately. This is the error I got.

Was this reply helpful? Yes No
Suggested answer

BizAppBee 89 on at

Like (1)

Report
Copy link

Link copied!

Hi @ASmithRouse, in your case, you would replace 'triggerBody()['text']' with I believe body('Html_to_text') - how you did your first compose. Sorry I should have been more clear:

Replace(First(Split(Last(Split(body('Html_to_text'),'Email:')), 'Inquiry')),' ','')

Was this reply helpful? Yes No