You’re offline. This is a read only version of the page.
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?
Hi @Shagoul ,
Please try:
Share
Report
All responses (
Answers (
last(split(first(split(last(split(EmailBody,'Status:')), decodeUriComponent('%0A'))),' '))
Best Regards,
Bof
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
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 |
#1
WarrenBelz
146,594
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
