Fix Power Automate Cannot Find Excel Table Named Table1 Error
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.

- 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.
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.
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.
Launch your target Excel file from its SharePoint or OneDrive location in Excel Desktop or Excel Online.
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.
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.
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.

Use Table ID Instead of Dynamic Table Name
Power Automate sometimes struggles to resolve dynamic table names at runtime. Passing the internal Table ID bypasses this issue.
Seek Help from the Power Automate Community
If standard troubleshooting fails, the issue may stem from connector limitations or specific SharePoint permissions.
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. Download the software: Visit the official WPS website to download the free installation package for your operating system.
- 2. Complete the installation: Run the installer and follow the quick on-screen prompts to set up WPS Office.
- 3. Open your Excel files: Launch WPS Spreadsheets and open your .xlsx files directly to enjoy a seamless editing experience.

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.




