Fix Power Automate Adding Excel Data at the Bottom of a Table
Question details
The user needs to understand why Power Automate places incoming records at the bottom of an Excel table instead of filling the expected fields.

- Product
- Microsoft Excel and Power Automate
- Device & OS
- not provided
- Scenario
- An automated flow adds incoming data to an Excel workbook, but the records do not populate the intended table columns or fields.
- Observed behavior
- Power Automate appends the incoming record at the bottom of the worksheet or table, often because the table range, headers, or mapped columns are incorrect.
Open the workbook in Excel and identify the exact table name, header row, and columns that the flow should update. Also open the Power Automate flow in edit mode so you can compare its selected table and field mappings with the workbook.
Correct the Excel table and Power Automate column mappings
Use this solution when the flow is targeting the wrong range or when Excel headers do not match the fields selected in Power Automate.
Power Automate can add a row reliably only when the worksheet range is a defined Excel table with a single, clear header row. Blank, duplicate, or changed headers can cause the action to map fields incorrectly or place values outside the expected columns.
In Excel, select the complete data range including the header row, choose Insert > Table, enable My table has headers, and select OK.
Select any cell in the table, open the Table Design tab, and confirm the table has a unique name. Make sure every header is filled in, unique, and matches the intended field name.
In Power Automate, edit the Excel step and choose Excel Online (Business) > Add a row into a table. Select the correct location, document library, file, and table instead of a worksheet range.
Expand the Add a row into a table action and map each source value to the matching Excel column. Remove mappings for outdated or duplicate columns, then save the flow.
Close and reopen the workbook or use Excel's refresh options, then run the flow with a test record and verify that each value appears in the intended column.
Rebuild the table when its structure has changed
Use this option when the workbook contains merged cells, blank header columns, duplicate headers, or a table that no longer matches the flow configuration.
Use WPS Office to Review and Prepare Excel-Compatible Tables
Although WPS Office does not repair Power Automate flows directly, it provides a free, lightweight way to open, review, and prepare Excel-compatible workbooks. Its familiar spreadsheet interface helps you clean headers, check table data, and migrate files with minimal disruption.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, select Spreadsheets, and open the Excel .xlsx workbook containing the source data.
- 2. Clean the table structure: Check the first row for blank or duplicate headers, remove merged cells from the data range, and ensure each column has a clear name.
- 3. Save in Excel format: Choose Menu > Save As, select the .xlsx format, and save the cleaned workbook before using it with Microsoft Excel or Power Automate.

Frequently Asked Questions
Why does Power Automate add data below my Excel table instead of into the columns?
The flow may be targeting a worksheet range instead of a defined table, or the table headers may be blank, duplicated, or different from the flow's field mappings. Confirm the action uses Add a row into a table and select the correct table.
Which Power Automate action should I use to add a record to Excel?
Use Excel Online (Business) > Add a row into a table. Select the correct file and table, then map each incoming value to the corresponding table column.
Can duplicate Excel headers cause incorrect Power Automate mappings?
Yes. Duplicate or blank headers make it difficult for Power Automate to identify the target fields. Give every table column a unique, nonblank header and refresh the action's fields afterward.
How do I make Power Automate recognize a newly created Excel table?
Save the workbook after creating the table, then reopen the Power Automate action and reselect the file and table. If the table still does not appear, refresh the browser or remove and add the Excel action again.




