Excel Error Codes

Fix Power Automate GetTable NotFound Error in Excel

Steve K Oct 7, 2026 870 views

Question details

Power Automate cannot retrieve a table from an Excel workbook stored in a SharePoint Documents library, returning a NotFound error.

Fix Power Automate GetTable NotFound Error in Excel

Product: Microsoft Excel / Power Automate
Device & OS: not provided
Scenario: Using the 'List rows present in a table' action in a Power Automate flow to extract data from a SharePoint-hosted Excel workbook.
Observed behavior: The flow fails and returns a 'GetTable NotFound' error, even when the workbook and table name appear to be correct.

Before you start

Ensure you have the necessary edit permissions for the SharePoint document library where the Excel file is stored, and verify that the file is not currently locked or being edited by another user.

Solution 1Recommended

Verify Table Formatting and Close the Workbook

Power Automate requires data to be explicitly formatted as a named Excel table. Furthermore, open files may cause access errors.

A common cause of the GetTable NotFound error is attempting to read standard cell ranges. Power Automate can only interact with official Named Tables. Additionally, if the workbook is open in the Excel desktop app or web browser, SharePoint may place a lock on the file, preventing the flow from reading the table.

Format data as a table

Open the Excel file, highlight your data range, and press Ctrl+T (or navigate to Insert > Table) to convert the range into a formal Excel Table.

Confirm the table name

Click anywhere inside your new table, go to the Table Design tab on the ribbon, and note the exact name in the Table Name box on the far left.

Save and close

Save your changes and completely close the workbook to ensure no file locks remain active in SharePoint.

Verify Table Formatting and Close the Workbook

Table Naming Tip: Avoid using spaces or special characters in your Excel table names to ensure seamless compatibility with Power Automate.

Solution 2

Refresh Power Automate Connector Settings

Ensure the flow uses the correct connector and that the file ID is properly mapped to the updated SharePoint location.

Solution 3

Seek Assistance in the Power Automate Community

If troubleshooting steps do not resolve the issue, consult Microsoft community experts for advanced diagnostic help.

Free Microsoft Office alternative

Try WPS Office for Your Everyday Spreadsheet Needs

While Power Automate requires the Microsoft ecosystem, WPS Office provides a lightweight, free alternative for standard spreadsheet creation and data management, offering exceptional compatibility and performance.

1. Download WPS Office: Visit the official WPS website to download the free office suite for your operating system.
2. Open Excel Files: Launch WPS Spreadsheet and easily open your existing .xlsx files without losing any table formatting.
3. Manage Data: Utilize robust data processing tools to create, manage, and analyze named tables efficiently.

Fully compatible with Microsoft Excel (.xlsx, .xls) filesFree, lightweight, and fast-loading alternative to Microsoft OfficeFamiliar user interface ensuring seamless migration with no learning curveAdvanced built-in tools for data formatting, charts, and table management

Frequently Asked Questions

Why does Power Automate say my Excel table is not found?

This error usually occurs if the target data is not formatted as an official named table in Excel, if the file is currently locked because it is open in another window, or if the file ID has changed in SharePoint.

How do I find or change the name of my Excel table?

Open your Excel workbook, click on any cell within your data table, and navigate to the 'Table Design' tab on the top ribbon. You can view and edit the table's name in the 'Table Name' box on the far left side of the menu.

Does the Excel file need to be closed for Power Automate to read it?

Yes, it is highly recommended to keep the workbook closed when a flow is running. If the file is open, SharePoint may apply a file lock, causing Power Automate to fail with a NotFound or locked file error.

Can I use dynamic table names in the List rows action?

Yes, but using dynamic content for table names requires passing the exact Table ID or an exact string match as a custom value. If the string evaluates incorrectly at runtime, it will trigger the GetTable NotFound error.

Microsoft Office Error Codes