You’re offline. This is a read only version of the page.
16
Hi everyone,
I'm encountering a frustrating issue with a Power Automate flow that interacts with an Excel table stored in SharePoint. The flow runs in a loop, and while it usually works fine, I'm experiencing random connection failures that break the entire process.
Here's the situation:
Share
Report"status": 404,
"message": "No table was found with the name 'Table1'.\r\nclientRequestId: ****
"error": {
"message": "No table was found with the name 'Table1'."
}
Despite this error, the table does exist. The flow connects to it successfully in each of the previous and subsequent loops. This single failure disrupts the entire process, causing significant issues.
It's worth noting that there is no issue at all on 9 out of every 10 runs (The flow runs once per day). This makes the problem even more perplexing and difficult to troubleshoot. Over the past few months, I have averaged 2-3 of these errors per month over thousands of connections to the Excel tables.
Another note, the table, 'table1' is a new table in a new Excel document that is created every day. I have tried doing this in multiple SharePoint sites and using different folder locations within the same SharePoint site. Eventually, I always get the error.
Has anyone else encountered a similar problem or have any suggestions for troubleshooting this intermittent failure? Any advice or potential solutions would be greatly appreciated!
Thanks in advance for your help.
Best regards,
Jacob
Update: Here are three photos that I probably should have included in my original post. First, of the action.
Second, of the settings.
Third, of the failed action.
Any and all assistance is appreciated. Thank you.
All responses (
Answers (
