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.
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.
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.
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.
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
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.
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