Power Platform Community Forum Thread Details

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:

Each night, the flow attempts to connect to a table named 'Table1' in an Excel file on SharePoint.
The number of loops changes daily.
On this most recent error (June 11, 2024) of 23 loops, the connection succeeded 22 times.
On one occasion, the connection fails with the following error:

"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

Categories:

General topics