Unanswered

Pull the data From alert email

(0) Share

Report

Posted on by Shagoul

110

Hi all, When the share point list is modified I am receiving an alert email, is there a way to pull the data from the email and then add to the excel file?

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

v-bofeng-msft on at

Like (0)

Report

Hi @Shagoul ,

Could you please provide a demo?

Best Regards,

Bof

Was this reply helpful? Yes No
Shagoul 110 on at

Like (0)

Report

Hi Bof,

Here is the demo

When I modified something on the SharePoint list I received the below email.

I want to pull the data from the body of the email and add it to the excel file.

Expected output
ID1
OnUsCheck
NotOnUsCheck
Status
Status (Edited)
Approval Status
Approval Status (Edited)
98
100
50
pass
fail
Approved
Pending

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Shagoul ,

You could try:

1\Use a HTML to text action to convert the email body to a plain text.

2\you could use these expressions:

To get 98, you could try this expression:

first(split(last(split(EmailBody,'ID1 ')), decodeUriComponent('%0A')))

To get 100, you could try this expression:

first(split(last(split(EmailBody,'OnUsCheck ')), decodeUriComponent('%0A')))

Best Regards,

Bof

Was this reply helpful? Yes No
Shagoul 110 on at

Like (0)

Report

Thank you can you please help with screenshot flow

Was this reply helpful? Yes No
Shagoul 110 on at

Like (0)

Report

Can you please advise how I get?
status: pass separately and status: “fail” Edited separately.

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @Shagoul ,

Please try:

last(split(first(split(last(split(EmailBody,'Status:')), decodeUriComponent('%0A'))),' '))

Best Regards,

Bof

Was this reply helpful? Yes No