Power Automate Excel Table Not Found Error
Quick answer
Excel actions only work on formatted tables, not plain ranges. Create an Excel table, refresh the connection, reselect the file and table, or use Get tables to pass the name dynamically.
Most likely fix: Fix the file
How to fix it
Try these in order — the most common fix is first.
1. Fix the file
- In Excel select the data and choose Insert > Table
- Save the file in OneDrive or SharePoint
- Reselect the file and table in the action
Did this fix it?2. Fix the flow
- Refresh the Excel Online (Business) connection
- Delete and recreate the action
- Use Get tables and pass its name when files are regenerated
Did this fix it?3. Avoid loop issues
- Turn off or lower concurrency on Apply to each that writes rows
- Re-run after a minute if the error is intermittent
Did this fix it?
Symptoms
Add a row into a table or List rows fails with 'No table was found with the name' or 'Table not found', sometimes intermittently.
Why it happens
- Data is a worksheet range, not a table
- File was replaced or regenerated
- Intermittent Excel Online errors
- Stale connection or action configuration
This guide also covers
- power automate excel table not found
- power automate no table was found with the name
- power automate add a row into a table error
Still not working?
If Microsoft Power Automate keeps failing, you're not alone. See every Microsoft Power Automate problem users report or the alternatives people switch to.
Done fighting Microsoft Power Automate? Our small team builds your own Microsoft Power Automate alternative, or any software you need: web, mobile, games, desktop. Price agreed together.
Talk to usThe same problem in other apps
Other Microsoft Power Automate errors
- Power Automate Flow Not Triggering
- Power Automate Flow Failed
- Power Automate Connection Error (401 Unauthorized)
- Power Automate Flow Turned Off Automatically
- Power Automate 429 Too Many Requests Error
- Why Is My Power Automate Flow So Slow
- Power Automate Premium License Required Error
- Power Automate Desktop Flow Failing in Unattended Mode