web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate - Actio...
Power Automate
Suggested Answer

Power Automate - Action 'Get_tables' failed. The resource could not be found

(0) ShareShare
ReportReport
Posted on by 920 Super User 2024 Season 1
Hi,

why am I getting error Action 'Get_tables' failed?

{
 "status": 404,
 "message": "The resource could not be found.\r\nclientRequestId: 58bfb995-21d7-4fda-af12-6f61e663b189\r\nserviceRequestId: 6bee2833-510e-4646-a9d4-e6a54a277ad2",
 "error": {
 "message": "The resource could not be found."
 },
 "source": "excelonline-eus.azconn-eus-002.p.azurewebsites.net"
}


The resource could not be found.
clientRequestId: 58bfb995-21d7-4fda-af12-6f61e663b189
serviceRequestId: 6bee2833-510e-4646-a9d4-e6a54a277ad2

the file does exist in the location. Any reason as to why this is happening?

 

wonka1234_0-1682194010890.png

 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    69,401 Most Valuable Professional on at

    Are you picking the file and document as static values using the controls or are you using dynamic content values?  If you are using dynamic content values then you need to wrap them in an EncodeDataURI() function to translate spaces and special characters.  That's the most common reason for this error.

  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    i am picking the file like so , using the picker on the right - 

     

    wonka1234_0-1682200389520.png

     

     

    please advise on what to do from here.

  • Pstork1 Profile Picture
    69,401 Most Valuable Professional on at

    Then I'm not sure what is the problem.  Usually this only happens when you are accessing the file dynamically or creating it earlier in the program. It can also be a problem if you copy the Excel file overtop of the original outside the flow.

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @wonka1234 

     

    Are you taking data from sharepoint ?

  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    @Pstork1 the file is created(deleted and recreated each time it runs) with another flow before the above flow is ran.

     

    @Nived_Nambiar data is coming from an online excel file.

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    What i meant is whther the that excel file is stored in sharepoint or not ?

  • Pstork1 Profile Picture
    69,401 Most Valuable Professional on at

    If the file is recreated each time then you need to put the path to the file in an

    encodeUriComponent() function.  Otherwise it won't use the actual path it will use the reference GUID that it retrieved when you picked the file.  When the file is recreated the path stays the same but the reference GUID changes.  Using the encoded path will force it to always use the path at runtime.
  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    @Nived_Nambiar  yes it is stored on a sharepoint.

     

    @Pstork1  so in my other flow that creates the copy of the excel file, i need to wrap which part with the encodeUriComponent() ?

     

    wonka1234_0-1682339615682.png

     

  • Pstork1 Profile Picture
    69,401 Most Valuable Professional on at

    Not the one where you create the Excel file.  You need to wrap the path of the file in the encode function when you use the path to read the file in the List Tables action.

  • wonka1234 Profile Picture
    920 Super User 2024 Season 1 on at

    @Pstork1  

    getting bad request error in syntax when trying this:

    wonka1234_0-1682364601360.png

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 1,005

#2
Valantis Profile Picture

Valantis 825

#3
Haque Profile Picture

Haque 619

Last 30 days Overall leaderboard