Power Platform Community Forum Thread Details

HI All,

I have been trying to create a workflow in power automate, from my outlook all emails and future emails to be updated in Excel to maintain a daily/monthly tracker, but flows are fine, in excel the data has not been getting, i check with copilot end up with same issue, any one guide me how to fix this issue or correct workflow?

outlook to excel ...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building flows

Hi there,

I tested the same scenario in a development environment, and it worked successfully. Here are the steps and observations:

Before using the Add a row into a table action in Power Automate, make sure that the Excel file is formatted as a Table rather than a normal range of cells, as shown in the image below.
After creating the table, add the required column headers in Excel. Once the table and headers are in place, Power Automate will automatically detect the columns and display them in the action, as shown below.
Run the flow and verify that it completes successfully.
After the flow runs, open the Excel file again. You should see the values (such as From, To, and Subject) populated in the table.

In my test, the data was inserted into the 8th row because In my case, Power automate assumes first 7 rows already contained data. The Add a row into a table action always appends a new record to the next available row in the table.

I hope this helps and clarifies the behavior.

Please let me know if you continue to experience any issues after following these steps, and I'll be happy to help further.