web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Email parsing

Power Automate

Unanswered

Email parsing

(0) Share

Report

Report

Posted on by Abdulbari

Hi!

I just happened to know about the amazing capabilities of MS power automate including parsing emails.

I’m looking for parsing the email below and then export the content to an excel sheet. I tried to follow a few examples in the community but failed to apply the same on my own case.

below is the form of the email - which I received frequently- I want to parse.

The following records have been updated in your Reports card:

Audited Financial Report VI (due 6/30/2024) Status: Report Received (1/13/2020)

Grant GG-1712-14986 - xxxxxxx

The fields in red are ones that I’m trying to capture systematic in an excel sheet.

Thanks in advance!

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

fchopo 8,003 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Abdulbari

Here are a few resources you could use:
Using a flow to extract email body details
Parsing Text from Email with Microsoft Flow
In order to extract some information, you should use the compose action and substring function.

Hope it helps!
Ferran

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Abdulbari,

There are expressions on how to extract these properties from the Email Body one by one:

ReportName:

split(outputs('Compose'),'(due')[0]

Duration:

split(split(outputs('Compose'),'(due ')[1],') Status')[0]

Status:

split(split(outputs('Compose'),'Status: ')[1],'(')[0]

ReceivedDate:

split(split(outputs('Compose'),'(')[2],')')[0]

Grant GG:

split(outputs('Compose'),'Grant GG-')[1]

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No

Join the conversation