Unanswered

Action 'Create_table' failed The resource could not be found.

(1) Share

Report

Posted on by webbrewer

338

So this was working yesterday, now I can't even save any changes because of this error. The flow creates items from a spreadsheet in a Sharepoint list. What does "the resource could not be found" refer to? The file? If so, it's wrong because the file is there and like I said worked yesterday. Flow has some nice features but is so incredibly buggy....

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Pstork1 69,543 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Why do you think you can create a table in the same file in the same place where you say you created a table yesterday? You can't create a new table over the old one. That doesn't make sense. Did you delete the table that was working yesterday before trying to create a new one today?

Was this reply helpful? Yes No
webbrewer 338 on at

Like (0)

Report
Copy link

Link copied!

Yes, I overwrite the file to trigger the flow, and the file has no tables initially. So need to create a table so the flow can copy the rows to Sharepoint.

Was this reply helpful? Yes No
Pstork1 69,543 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Then the problem is with timing and I agree in terms of the Excel Online connector its buggy. Overwriting the existing file with a new one takes time and the flow doesn't wait for the new file to be committed before trying to write to the new file. That's why you are getting the resource not found. It literally doesn't exist in the system yet, or at least isn't recognized as existing. So yes I agree that particular process of trying to overwrite an existing Excel file and use it immediately is buggy and will not work reliably. There is no fix for that other than not trying to overwrite existing files.

Was this reply helpful? Yes No
webbrewer 338 on at

Like (0)

Report
Copy link

Link copied!

It seems that way except for the fact that the flow worked when I first set it up for about a day of testing. I don't remember exactly but it could be after I added the "create table" action it started to fail. I'll try to recreate what I did to troubleshooot.

Was this reply helpful? Yes No
Pstork1 69,543 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Without a Create Table it has a better chance of working because you aren't trying to overwrite what already exists in the cached copy. In my experience copying over an existing Excel file and using it in a flow immediately is very unstable and will not work consistently. I would suggest looking for another way to accomplish your purpose.

Was this reply helpful? Yes No
webbrewer 338 on at

Like (0)

Report
Copy link

Link copied!

I think the issue was the name of the table was getting replaced by an identifier guid in the list rows present action. When I reset that to the table name, and added a minute delay after the file is saved, it seems to work. To stop the looping caused by the table creation retriggering the flow, I added a condition that checks whether the file has a table present, and terminates the flow if it does. The last problem is getting the filter array to ignore the empty rows.

Was this reply helpful? Yes No
jasonzh 9 on at

Like (0)

Report
Copy link

Link copied!

I ran into a similar issue. It's because the "Create Table" action will only create the table under the flow owner's OneDrive or SharePoint. This happens because the "drive" parameter is automatically hardcoded when you select a preset value in Power Automate. You have to check the code behind the action to verify whether you're using a dynamic resource or a hardcoded one. Otherwise, the flow runs fine for the owner, but when other people run it, they encounter an error.

Was this reply helpful? Yes No