Unanswered

Email parsing

(0) Share

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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

fchopo 8,003 Moderator on at

Like (1)

Report
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 on at

Like (0)

Report
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