Answered

Extract latest body of email but exclude signature details

(0) Share

Report

Posted on by jbrines

1,151

I have a flow that add the body details to a SharePoint list comments but it is adding all the email body. I only want the latest information but exclude the the signature rubbish that makes the comments look terrible.

body issue 4.JPG

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @jbrines

Is your signature starts with '[cid:' (I can see from the screenshot) then use split expression to split the body of the email using '[cid:' then use the first() expression to extract the email body.

first(split())

Thanks

Was this reply helpful? Yes No
jbrines 1,151 on at

Like (1)

Report
Copy link

Link copied!

Hi @abm

It isn't just my signature it is other signature from external users.

John.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @jbrines

Is all the signatures starts with that tag '[cid' ?

Thanks

Was this reply helpful? Yes No
jbrines 1,151 on at

Like (0)

Report
Copy link

Link copied!

Hi @abm

I have no way of telling if their signatures starts with that tag '[cid'

I am using the following to get the body at the moment but brings in everything.

I have also tried this but still brings in the signature.

Solved: Body preview of trigger "When a new email is recie... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Try the following

1. Add a compose action step before HTML to text. Here map the email Body Dynamic property.

2. Add another compose after HTML to text. Here map the output.

Run the flow with multiple test values. Check the run history and see are there any common patterns you can see for the signature like a header or something. Then you could use the split() expression. If not it is not possible to extract just the body of the email.

Thanks

Was this reply helpful? Yes No
jbrines 1,151 on at

Like (1)

Report
Copy link

Link copied!

@abm Many thanks for your help, with you mentioning using Compose it made me see that I was using the wrong outputs. Now I have used the correct one it is working fine.

Thanks again

John.

Was this reply helpful? Yes No