Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 18

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.

 

Florida_0-1718977921804.png

 

  • Suggested answer
    R.K. Profile Picture
    R.K. on at
    Bug: No table was found with the name....in a Flow that's worked for 5 years +
    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. 
  • Johnwitt_dfin Profile Picture
    Johnwitt_dfin 42 on at
    Re: Bug: No table was found with the name....in a Flow that's worked for 5 years +

    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.

  • Flo-rida Profile Picture
    Flo-rida 18 on at
    Re: Bug: No table was found with the name....in a Flow that's worked for 5 years +

    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 Profile Picture
    Johnwitt_dfin 42 on at
    Re: Bug: No table was found with the name....in a Flow that's worked for 5 years +

    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 Profile Picture
    Flo-rida 18 on at
    Re: Bug: No table was found with the name....in a Flow that's worked for 5 years +

    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
  • Flo-rida Profile Picture
    Flo-rida 18 on at
    Re: Bug: No table was found with the name....in a Flow that's worked for 5 years +

    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.

  • FLMike Profile Picture
    FLMike 29,105 on at
    Re: Bug: No table was found with the name....in a Flow that's worked for 5 years +

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics

Restore a deleted flow