cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiseEnPlace
Regular Visitor

Parsing Email Subject or Body into Excel Sheet

Hi. I am trying to create a flow that will allow me to add data from the subject, or body if it's feasible. 

 

When I get an email, the subject typically will say "Your $511.17 transaction with AMZN Mktp US".

 

The body has the below table in it.

 

MiseEnPlace_0-1656361021331.png

 

Ideally, I'd like all 4 here to be in separate columns. The data is essentially in a table format. 

 

One thought I had was to use the Subject field "Your $511.17 transaction with AMZN Mktp US" - And pulling the bolded and underlined as 2 of the fields I need, plus the date of the email perhaps, though, that wouldn't be as accurate as the date stamp in the table.

 

Is this possible?  

 

I went ahead and Split the Body text and this is the output:

 

  "",
  "Account",
  "",
  "XXXXXX XXXX XXXXXXXX (...XXXX)",
  "",
  "Date",
  "",
  "Jun 25, 2022 at 11:31 PM ET",
  "",
  "Merchant",
  "",
  "AMZN Mktp US",
  "",
  "Amount",
  "",
  "$511.17",
  "",
1 ACCEPTED SOLUTION

Accepted Solutions
MiseEnPlace
Regular Visitor

I was able to get it to work, essentially parsing the data, counting which row it was on, then splitting out the data. Then I ran an 'add row' in excel, and it all worked out. 

 

The 'Get Worksheets' is essentially not needed. 

 

 

MiseEnPlace_0-1656371018027.png

 

View solution in original post

1 REPLY 1
MiseEnPlace
Regular Visitor

I was able to get it to work, essentially parsing the data, counting which row it was on, then splitting out the data. Then I ran an 'add row' in excel, and it all worked out. 

 

The 'Get Worksheets' is essentially not needed. 

 

 

MiseEnPlace_0-1656371018027.png

 

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.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,885)