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

(0) Share

Report

Posted on by wonka1234

909 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?

All responses (16)

Answers (0)

Suggested answer

NP-09010158-0 2 on at

Like (0)

Report

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

Hello, I'm fixing the flow in power automate for another action but I get a sudden error in the data retrieval/connection section.
Action 'Get_file_properties' failed: Item Not Found clientRequestId: faaa09bc-ba9b-4a30-a310-c1ae9d71de2a serviceRequestId: 32ae75a1-30b0-4000-5488-492d356bb4dc.

Help me get it done, thank you
Pstork1 66,910 Most Valuable Professional on at

Like (0)

Report

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

You can convert it in Excel on the Desktop. I'm merely suggesting doing that for one run to see if that is the issue. I'm not aware of any way to do it in a flow.
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

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

@Pstork1 yes its a excel binary file. Is there a way to convert it to xlsx in a flow?
Pstork1 66,910 Most Valuable Professional on at

Like (0)

Report

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

The only thing that looks off to me is .xlsb. What does the b in the extension stand for? If you are using an actual binary version of the file I don't think Excel Online can open that. I would convert the file to .xlsx to test and make sure that isn't the problem.
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

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

@Pstork1 am I missing something here?

encodeUriComponent('/Shared Documents/jon/copy/TEST_FILE (4.11).xlsb')
Pstork1 66,910 Most Valuable Professional on at

Like (0)

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

Even though you have specified the library make sure you include the full path from the root of the site including the document library.

encodeUriComponent('/Shared Documents/Data/1000 books.xlsx')

1000 books.xlsx is in a Data folder in the Documents library.
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

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

@Pstork1
getting bad request error in syntax when trying this:
Pstork1 66,910 Most Valuable Professional on at

Like (0)

Report

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

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 909 Super User 2024 Season 1 on at

Like (0)

Report

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

@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() ?
Pstork1 66,910 Most Valuable Professional on at

Like (0)

Report

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

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.