Outlook to Excel

(0) Share

Report

Posted on by Jaymz

Trying to create a flow that reads emails and adds certain data into an Excel spreadsheet.

E.g. Colleague sends an email with the subject of "OUTCOME" to the company.

"Dear Colleagues,

Please find the below outcomes:

Heading 1	Heading 2	Heading 3	Heading 4	Heading 5
Var 1	Var 2	Var 3	Var 4	Var 5

Kind regards, etc."

I want to copy the data from the above table (Var 1, Var 2, Var 3, Var 4, Var 5) into a new row on an Excel table that has the same headings.

Any assistance would be greatly appreciated.

Thank you.

I have the same question (0)

All responses (16)

Answers (1)

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Outlook to Excel

Hi @Jaymz

Pls check out my blog that extracts data from html table in the email:

Extract data from html table from email body in Power Automate - Power Platform (technetty.com)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Jaymz on at

Like (0)

Report

Re: Outlook to Excel

Hey Manish,

Would your solution also work if a colleague has more than 1x row in the Outlook email's table? I.e. if there were multiple 'outcomes' in their email?

Was this reply helpful? Yes No
Jaymz on at

Like (0)

Report

Re: Outlook to Excel

Also, I tried the first couple steps to run the 'compose' function. Should it look like my picture??

There's nothing more that it does. I can't see if it's picking up the table in the email or not...

Flow 1.PNG

Was this reply helpful? Yes No
Jaymz on at

Like (0)

Report

Re: Outlook to Excel

Might need some further clarification of what things mean and why I'm supposed to be doing them. Doesn't seem to be working for me...

Flow 2.PNG

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Outlook to Excel

Hi @Jaymz

Pls enter the expression in the expression window. It should not be entered directly in the compose textbox.

Thanks

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Outlook to Excel

Pls create a table with the required columns where data need to be stored finally.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Jaymz on at

Like (0)

Report

Re: Outlook to Excel

@ManishSolanki

There is an excel spreadsheet ready. I can see that another row gets added, but the row is blank. I might need some further clarification on how to input the specific fields from the email to the specific columns in the Excel...

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Outlook to Excel

Hi @Jaymz

Could you pls share the html code of the email body from which you want to extract the data? You could run the flow and get the html code of email body. I will try if I could help you in extracting the data from html table.

Thanks

Was this reply helpful? Yes No
Jaymz on at

Like (0)

Report

Re: Outlook to Excel

I'm not sure where I'm going wrong. But here's a few pics that I hope will assist.

Flow 2.2.PNG

Flow 2.1.PNG

Flow 2.3.PNG

Was this reply helpful? Yes No
Jaymz on at

Like (0)

Report

Re: Outlook to Excel

And...

flow 2.4.PNG

Flow 2.6.PNG

Flow 2.5.PNG

Was this reply helpful? Yes No