Extract specific part of email

[TdubbelV]

Hi,

I have configured a flow that should send a text message to a user with the body of the email in the text message.

I have this working but what i would like to do now is have it extract a specific part from the body of the email and send that via a text message, because the emails that are coming in are being forwarded it sends the from: fields also within the text message.
Is it possible to let it extract only a specific part of the body of the email? Every email starts with the same sentence so maybe that is something i can use? 

See attached for the flow i have right now. This is working right now but if i could trim it down without the text that is coming from the email being forwarded that would be great.

Thank you in advance.

Kind regards,

Tom

[AlexEncodian]

@TdubbelV 

This is very simple if all of your emails start with the same sentence. Two ways of doing this:

1) Native expressions:
- add a compose action after the HTML to Text step
- use the split expression and split your email body using the repeated first sentence as your split character

- the split expression removes the split character from the result therefore you also need to concatenate the split character back in within your expression

Solved: Split String - Power Platform Community (microsoft.com)

2) Encodian's Utility - Extract Text between Values action allows you to set-up text parsing with a few clicks. Insert the action (screenshot below) underneath the HTML to text step. Insert the repeating sentence as your Start Value, leave end value blank (it will go to the end of the email body), and choose to include the Start Value in the result.

[grantjenkins]

Are you able to show what your email looks like to better help here? If any sensitive information then you could remove that - more looking at the overall structure and exactly what part you want to exclude/include.

[TdubbelV]

Hi @grantjenkins ,

Sure thing the email looks like this:

________________________________________
Van: Administrator <admin@.onmicrosoft.com>
Verzonden: woensdag 1 november 2023 05:58:40 (UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
Aan: 
Onderwerp: Nieuwe Voicemail van: +31

Je hebt een nieuwe voicemail ontvangen van: +31

Van::+31
Ontvangen:Wednesday, November 1, 2023 5:58:32 AM
Duur:00:00:06

It would be great if I could trim the email down and let it start with the sentence marked in red. Every email contains this sentence.

Let me know what would be the best to do. I see a lot about the compose option @AlexEncodian mentions but I have little to know knowledge about the code that needs to be given there so if you could give me some tips & tricks that would be great.

[grantjenkins · Accepted solution]

Try the following and let us know how it goes. Note that this will strip out any HTML formatting such as the bold style, etc.

See full flow below. I'll go into each of the actions.

When a new email arrives (V3) is likely what you already have for your trigger. I'm assuming you also have a condition on here that looks for a specific Subject or similar.

Html to text converts the HTML body of the email to plain text.

Compose extracts all the text starting with the sentence you said was the same in all emails. The expression used is below. You can then use the output of the Compose to send your messages, etc.

slice(outputs('Html_to_text')?['body'], indexOf(outputs('Html_to_text')?['body'], 'Je hebt een nieuwe voicemail ontvangen van'))

After running the flow, this is the output from the Compose.

[TdubbelV]

Amazing! Works like a charm @grantjenkins.

Thank you very much for your help and explanation.