cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Abdulbari
New Member

Email parsing

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!

 

 

 

 

2 REPLIES 2
fchopo
Super User
Super User

Hi @Abdulbari 

 

Here are a few resources you could use:

In order to extract some information, you should use the compose action and substring function.

 

Hope it helps!
Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!
v-litu-msft
Community Support
Community Support

Hi @Abdulbari,

 

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

Annotation 2020-01-17 151103.png

 

Annotation 2020-01-17 151115.png

 

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,878)