Others

Fix Power Automate Cannot Find Excel Table Named Table1 Error

John WilsonJohn Wilson Nov 2, 2026 869 views

Question details

The user encounters a 'No table was found with the name Table1' error when using the List rows present in a table action in Power Automate.

How to Fix Power Automate Cannot Find the Excel Table Named Table1
Product
Microsoft Power Automate and Excel
Device & OS
not provided
Scenario
Attempting to retrieve or manipulate data from an Excel spreadsheet using the Power Automate 'List rows present in a table' action with a dynamically or manually supplied table name.
Observed behavior
The automation flow fails and throws an error stating that the table cannot be found, despite the table name appearing correct in the variable outputs.
Before you start

Ensure the Excel file is fully closed, not locked by another process, and properly synced to a supported cloud location like SharePoint Online or OneDrive for Business.

Solution 1Recommended

Verify the Excel Table Name and Cloud Location

Confirm that the table actually exists in the target Excel file, is properly formatted as a table, and is fully synced to the cloud.

Power Automate requires the target data to be formatted as an official Excel Table, not just a range of cells. Additionally, the file must be fully uploaded to SharePoint or OneDrive without pending sync issues.

1
Open the Excel file

Launch your target Excel file from its SharePoint or OneDrive location in Excel Desktop or Excel Online.

2
Check table formatting

Click anywhere inside your data range. Go to the 'Table Design' tab on the ribbon. If you do not see this tab, your data is not a table. Press Ctrl+T to convert it into a table.

3
Verify the exact table name

Look at the 'Table Name' box on the far left of the 'Table Design' ribbon. Ensure it exactly matches 'Table1' with no leading or trailing spaces.

4
Re-select the file in Power Automate

Go back to your Power Automate flow, open the 'List rows present in a table' action, click the folder icon, and re-navigate to the file location to refresh the connection.

Verify the Excel Table Name and Cloud Location
Free Microsoft Office alternative

Experience Hassle-Free Spreadsheet Management with WPS Office

If you are dealing with complex integration errors and just want a fast, reliable way to manage and edit your tabular data, try WPS Office. It provides an intuitive spreadsheet editor that is a powerful alternative for your daily data processing tasks.

  1. 1. Download the software: Visit the official WPS website to download the free installation package for your operating system.
  2. 2. Complete the installation: Run the installer and follow the quick on-screen prompts to set up WPS Office.
  3. 3. Open your Excel files: Launch WPS Spreadsheets and open your .xlsx files directly to enjoy a seamless editing experience.
Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Lightweight architecture that opens large tables quickly without lag.Familiar, easy-to-use interface requiring zero learning curve.Completely free to download and use for essential spreadsheet editing.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Automate say no table was found when I clearly see it in Excel?

This commonly happens if the Excel file has pending sync operations with SharePoint/OneDrive, if the table name contains invisible trailing spaces, or if the flow uses a dynamic string variable that Power Automate cannot validate during the execution phase. Switching to a Table ID instead of a name often resolves this.

Can I use the Power Automate Excel connector with a file saved on my local desktop?

No. The standard 'Excel Online (Business)' connector in Power Automate requires the file to be stored in an accessible cloud environment like OneDrive for Business, SharePoint Online, or Microsoft 365 Groups.

How do I correctly format my data as a table in Excel?

Highlight your data range, click 'Insert' on the top ribbon, and select 'Table' (or press Ctrl+T). Ensure 'My table has headers' is checked, click OK, and then assign a name in the 'Table Design' tab.