Unanswered

export the body of an email to an excel sheet with power automate

(0) Share

Report

Posted on by uknowx5

I'm trying to export the body of an email I receive to excel but I can't figure out how to do it. could you tell me how to do it?

I've searched the community and haven't found anything like it.

Here I show you the type of email that I need to export to excel

i use this flow

but excel is always empty

Any idea why it fails?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @uknowx5 ,

You need create a table and then add a row into the table.

column names were specified in the action box.

Then, in the action "Add a row into a table" do as follows:

- Fill the "Table" parameter with the "title" of "Create table"

- Specify the values in the "Row" parameter in JSON format using the column name as the keys.

please check this link :

https://powerusers.microsoft.com/t5/Building-Flows/Adding-rows-to-a-table-I-create-in-the-same-Flow/td-p/475335

Best Regards,
Bof

Was this reply helpful? Yes No
uknowx5 4 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-bofeng-msft
Thanks but this is not what I need. I don't want to create row by row with the information. I want to copy and paste the content of an email to an excel.
Even so, trying as you tell me, some parameters do not appear. Such as ID and Comment
In outlook mail, pressing ALT +F11 opens VB and I have a code that exports me to excel perfectly. Does something like this not exist in power automate?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @uknowx5 ,

Does something like this not exist in power automate?

Yes , there is no such an OOB function.

Best Regards,

Bof

Was this reply helpful? Yes No
uknowx5 4 on at

Like (0)

Report
Copy link

Link copied!

I do not claim that the same function is available, but surely there is something that will export me to Excel as is the information. and I'm sure powerautomate can do it as it contains a lot of connectors. Has anyone been able to do something similar?

Was this reply helpful? Yes No