Data Import & Export

Fix Power Automate Flow Not Adding Rows to Excel Tables

Amos Gikunda Sep 25, 2026 869 views

Question details

The user needs to troubleshoot a Power Automate flow that successfully parses file names but fails to write the extracted values into the destination Excel table.

How to Fix Power Automate Not Adding Rows to Excel Tables

Product: Microsoft Excel / Power Automate
Device & OS: not provided
Scenario: Using Microsoft Power Automate to extract file names and insert them as new rows into an Excel file.
Observed behavior: The flow completes successfully without any error messages, but the extracted data does not appear in the destination Excel table.

Before you start

Ensure your Excel file is saved in a supported cloud location like OneDrive for Business or SharePoint, and verify that the file is not currently locked or being edited by another application in desktop mode.

Solution 1Recommended

Verify Excel Table Formatting and Action Mappings

Ensure the target Excel file has a properly formatted table and that the flow's 'Add a row into a table' action is correctly mapped to the right columns.

Power Automate requires the destination data range in Excel to be formatted as an official Table. If the flow runs but nothing appears, it is usually because the target is just a normal range, or the flow is writing to empty or incorrect columns.

Format Data as a Table

Open your target Excel file in Excel Online or desktop. Highlight your data range, navigate to the Home tab, and select 'Format as Table' (or press Ctrl+T). Ensure your table has headers.

Check Flow Mappings

Open your flow in Power Automate and edit the 'Add a row into a table' action. Verify that the correct Location, Document Library, File, and Table are selected. Check that the dynamic content (like file names) is mapped to the correct specific column fields.

Inspect Run History

Go to the flow's Run history, select the most recent successful run, and expand the 'Add a row' action. Check the raw outputs to see if the data was actually passed to the columns or if it was submitted as blank.

Verify Excel Table Formatting and Action Mappings

Sync Delay: Sometimes changes made by Power Automate take a few moments to reflect. Refresh your Excel Online page to ensure it is not just a display delay.

Solution 2

Seek Assistance in the Power Automate Community

Since custom Power Automate flows can have complex parsing logic, getting help from the official community is the best step for specific workflow errors.

Free Microsoft Office alternative

Try WPS Office for Your Data Management Needs

While Power Automate is specific to the Microsoft ecosystem, if you're looking for a lightweight, powerful, and highly compatible alternative to Microsoft Excel for everyday data management and spreadsheet tasks, WPS Spreadsheet is an excellent choice. It offers a familiar interface and seamless handling of large datasets at no cost.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
2. Install and Open: Run the installer and launch WPS Spreadsheet from the main dashboard.
3. Open Your Excel File: Drag and drop your .xlsx file directly into the application to continue analyzing your data seamlessly.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csvLightweight architecture ensures fast loading even with large data importsFamiliar ribbon interface guarantees a seamless transition with zero learning curveRich set of built-in data analysis tools and free professional templates

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Power Automate flow show as successful but no data appears in Excel?

This usually happens if the 'Add a row into a table' action is mapping dynamic data to the wrong columns, the extracted variables were actually blank, or the flow is pointing to a duplicate or older version of the Excel file.

Can Power Automate add data to a standard Excel worksheet without a table?

No, the standard Excel connector in Power Automate explicitly requires the destination data range to be formatted as an official Excel Table (using Insert > Table).

Do I need a premium connector to add rows to Excel via Power Automate?

No, the standard 'Excel Online (Business)' or 'Excel Online (OneDrive)' connectors can add rows to tables without requiring a premium Power Automate license.

Excel & Data Problems