Email parsing

Like (0) Share

Report

Posted on 16 Jan 2020 15:06:23 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!

All responses (2)

Answers (0)

v-litu-msft on 17 Jan 2020 at 07:17:34

Like (0)

Report
Re: Email parsing

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.
fchopo 7,972 Moderator on 16 Jan 2020 at 15:25:33

Like (1)

Report
Re: Email parsing

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