How to extract only body from received mail

(0) Share

Report

Posted on by r_voyager

130

Hi Community,

So I have a Power automate flow which when a email arrives takes the body of mail and update column in Sharepoint list.

But I'm not able to extract the body. I used html to plain text conversion but its picking up the previous mail body also which I sent

flow part 1

flow part 2sharepoint updated column

In the 3rd screenshot above the " Thanks for your email" is the reply to my earlier email sent to the sender.

I only want this part(" Thanks for your email" ) of body in SP list column concatenated, I mean whatever is there in the SP list column already, the body part should come after that.

Any help will be appreciated.

Thanks,
Rahul

Categories:

General Questions

Using Apps Using Formulas

Connecting to Data

All responses (1)

Answers (0)

Moximox 135 on at

Like (0)

Report

Re: How to extract only body from received mail

Hi
the body contains the history normally so that’s why you see not only the last response. In order to just get last message you can do numerous things.

1. Compare number of characters in last with previous email in thread and retrie only text from body equal to difference.
2. Split email at specific reoccurring text like from: and take first splitted part
3. Always split email into two pieces where you add the second piece as a child record allowing users to continue reading. In this way you can always have same length of the message presented as a preview.