Extract Data From a Table in Email

(1) Share

Report

Posted on by Excel-lent

Hello!

I am trying to create an automatic flow that will extract data from a table that is pasted in the body of an email, which is received daily. The data needs to then be saved to an Excel file. The Excel file will house all the table data from these emails, creating a searchable/analyzable database over time. I'm very stuck after "when an email arrives". Thank you!

-Excel-lent

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi

Your next step is the HTML to Text to get the body into text.

now use a Compose and write whatever logic you need to Parse that string output from the previous step

Either grab your Excel template or Create one using one of the paid Actions etc

Its really... not fair or reasonable to just write that little bit and do no research (cause the same thing is answered every day).

If you want help I started you off, do that and when you get to where you can share more details etc including the Content so we can help you parse it, we can.

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Assuming it's an HTML table, you can check if it's valid XML and if so, use XPath to convert it to a PA array (instead of converting HTML to text).

But as FLMike already noted: Without an example, nobody can say.

Was this reply helpful? Yes No

Excel-lent

4 on at

Like (0)

Report

Copy link

Link copied!

Thank you for your replies and guidance. My apologies for being very short on Power Automate and programming skills and understanding.

The tables received in the body of the emails in question are HTML. From what I understand, PA compose using JSON is a way to see and parse the data within the table.

I believe the PA flow will look something like this:

1.) When an email arrives

2.) Identify and convert table to an array

3.) Open destination Excel file

4.) Identify the next available row in the Excel file and deposit data

Below is an example of the email received containing the table:

See the below data regarding new products:

Great work:

NEW Product Table
Department	Contact Name	Contact E-Mail	Item	Control	Date/Time
Upstairs	John Smith	Myemail.com	XR13845	Abc123	10/19/24 19:56
Downstairs	Jane Smith	Myemail.com	D4873KA	Def456	10/19/24 15:53