You’re offline. This is a read only version of the page.
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 2
sharepoint 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
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.
Share
Report
All responses (
Answers (
