Fix Power Automate Excel Table Not Found After OneDrive File Replacement
Question details
Resolve a Power Automate flow that cannot overwrite a OneDrive workbook and then cannot find its Excel table.

- Product
- Microsoft Power Automate, Excel Online, OneDrive, and SharePoint
- Device & OS
- not provided
- Scenario
- A flow reads an Excel table in OneDrive to update a SharePoint list, but the workbook must first be replaced or updated.
- Observed behavior
- The workbook cannot be overwritten, and a later flow action reports that the Excel table resource cannot be found.
Identify the OneDrive workbook, its table name, and the flow actions that replace the file and read the table. Check the latest failed run for the exact error and the action where it occurred.
Check the OneDrive workbook and refresh the Excel table reference
Use these checks to investigate file locks and stale workbook or table references after a replacement.
Open the flow in Power Automate, select the failed run under Run history, and expand the file and Excel actions to review their inputs and error messages.
Close the workbook in Excel and Excel for the web, and ask other editors to close it. Run the flow again to see whether an active editing session was preventing the overwrite.
Open the replacement workbook from OneDrive in Excel. Select a cell in the data and check Table Design for the table name; if the data is not already a table, select it and use Insert > Table.
In Power Automate, open the flow and select Edit. In the Excel action that reads the rows, reselect the OneDrive location, workbook, and table from the available fields, then save the flow.
Select Test in the flow editor and review the new run history. Confirm that the file action succeeds before checking whether the Excel action reads the table and updates the SharePoint list.

Ask the Power Automate Community for connector troubleshooting
Use this option if the overwrite or table lookup still fails after checking the workbook and flow references.
Edit Excel workbooks with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format support for an easier move between office suites. It can help you edit spreadsheet data, but it does not fix Power Automate connector errors.

Frequently Asked Questions
Why can Power Automate no longer find the Excel table?
The flow may still reference a previous workbook or table after replacement. Open the Excel action in the flow editor and reselect the current file and table, then test the flow.
How do I check whether my Excel data is a table?
Open the workbook in Excel and select a cell in the data. If it is an Excel table, the Table Design tab shows its table name. Otherwise, select the data and choose Insert > Table.
Could an open workbook prevent the file from being overwritten?
An active editing session can contribute to file locking. Close the workbook in Excel and Excel for the web, ask other editors to close it, and test the file action again.
Where can I get help if the flow still fails?
Post in the Microsoft Power Automate Community with the failed action names and error messages from Run history. Include how the OneDrive workbook is replaced, but remove sensitive information.




