Skip to main content
Community site session details

Community site session details

Session Id : rr5MAoWpv2/jdOGwNfL2LN
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 26 May 2021 18:09:03 by 334

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

untitled.png

  • jasonzh Profile Picture
    9 on 16 May 2025 at 15:58:48
    Action 'Create_table' failed The resource could not be found.
    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.
  • webbrewer Profile Picture
    334 on 27 May 2021 at 21:18:51
    Re: Action 'Create_table' failed The resource could not be found.

    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. 

  • Pstork1 Profile Picture
    67,079 Most Valuable Professional on 27 May 2021 at 13:50:10
    Re: Action 'Create_table' failed The resource could not be found.

    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. 

  • webbrewer Profile Picture
    334 on 27 May 2021 at 13:43:39
    Re: Action 'Create_table' failed The resource could not be found.

    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.

  • Pstork1 Profile Picture
    67,079 Most Valuable Professional on 27 May 2021 at 00:24:43
    Re: Action 'Create_table' failed The resource could not be found.

    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.

  • webbrewer Profile Picture
    334 on 26 May 2021 at 18:41:20
    Re: Action 'Create_table' failed The resource could not be found.

    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. 

  • Pstork1 Profile Picture
    67,079 Most Valuable Professional on 26 May 2021 at 18:18:41
    Re: Action 'Create_table' failed The resource could not be found.

    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?

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading started
Loading complete