Bug: No table was found with the name....in a Flow...

Flo-rida · ‎06-21-2024

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.

FLMike · ‎06-27-2024

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

Flo-rida · ‎06-28-2024

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.

Flo-rida · ‎07-02-2024

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. &nbsp;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

Johnwitt_dfin · ‎07-08-2024

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.

Flo-rida · ‎07-08-2024

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.

Johnwitt_dfin · ‎07-10-2024

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.

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

Helpful resources

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

Updates to Transitions in the Power Platform Communities

Restore a deleted flow