Unanswered

Bug: No table was found with the name....in a Flow that's worked for 5 years +

(0) Share

Report

Posted on by Flo-rida

This flow adds items to a list when an excel file replaces an existing file. It's worked daily for years but today I get an error "No table was found with the name..." and the name shown is a guid.

Trigger: replacing daily xl file in site's docs library. Get tables from file. If table exists > terminate. If no tables > create table > get rows > filter out empty rows > pass filtered "body" to create items action in list

It fails on the create table action which makes zero sense. I can see the file is replaced and the table is created in the excel file with new data so the error is incorrect.

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Flo-rida

If you looked at the flow run that had a failure, can you please explain, how it added if it failed?

I ask this, because in the Flow, if it fails, it should have

1. been caught by your error handling or

2. Flow stops and throws the error

But unless you have "Configure Run After Settings" to ignore failures, then can you please share the flow that failed, but still wrote the data?

Can you verify that you see that happening IN the flow that failed?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Flo-rida 18 on at

Like (0)

Report

No, the flow partly worked-it does create a table in the file but terminates with the error that "table xxx doesn't exist" - so the items weren't added to the list. It's clearly a bug because I tried it again later and it worked and has worked everyday since.

Was this reply helpful? Yes No
Flo-rida 18 on at

Like (0)

Report
Fine for a week or two but now it happened again-with "Action 'Get_tables' failed". Again, the file is uploaded fine, the table is added. Disturbing that we can't rely on this functionality. Not much point automating processes if you then have to manually redo everything later.

<!DOCTYPE html> <html> <head> <title>The resource cannot be found.</title> <meta name="viewport" content="width=device-width" /> <style> body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Consolas","Lucida Console",Monospace;font-size:11pt;margin:0;padding:0.5em;line-height:14pt} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:pointer; } @media screen and (max-width: 639px) { pre { width: 440px; overflow: auto; white-space: pre-wrap; word-wrap: break-word; } } @media screen and (max-width: 479px) { pre { width: 280px; } } </style> </head> <body bgcolor="white"> <span><H1>Server Error in '/' Application.<hr width=100% size=1 color=silver></H1> <h2> <i>The resource cannot be found.</i> </h2></span> <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "> <b> Description: </b>HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable.  Please review the following URL and make sure that it is spelled correctly. <br><br> <b> Requested URL: </b>/x/_layouts/xlrestinternal.aspx<br><br> </font> </body> </html> clientRequestId: xxx serviceRequestId:xxx

Was this reply helpful? Yes No
Johnwitt_dfin 42 on at

Like (0)

Report

I just started seeing this error as well. It's random and typically occurs in the Add a Row into a Table. I also randomly get errors saying Table id not found, and then it runs fine a minute later. These errors just started occurring. I am working with MSFT on a similar issue and will post here if I hear anything.

Was this reply helpful? Yes No
Flo-rida 18 on at

Like (0)

Report

Thanks @Johnwitt_dfin I didn't bother submitting a service request because Msft rarely fixes anything, so I'd appreciate hearing of any progress you make.

Was this reply helpful? Yes No
Johnwitt_dfin 42 on at

Like (1)

Report

I am getting this 20x per day now randomly so going to open a SevA with MSFT. Hopefully it was a bad deployment they can quickly fix, as I only started seeing this last week and today's it's far worse.

Was this reply helpful? Yes No
Suggested answer

R.K. Microsoft Employee on at

Like (0)

Report

This problem should now be resolved. This specific problem was categorized as a bug by the Excel Online team that also impacted the Excel Online connector in Power Automate, and a fix was released for it via a rollback.

Was this reply helpful? Yes No