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....
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.
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.
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.
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.
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.
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?
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2