Unanswered

Flow Fails with error: Action 'List_rows_present_in_a_table'

(2) Share

Report

Posted on by AD-10041242-0

I have multiple flows setup to copy a Table from an Excel Spreadsheet to a Sharepoint list.

The Spreadsheet is the same and is updated daily and the flow is used to either copy new data or overwrite existing data.

These flows work for a while sometimes weeks / sometimes months but then all of a sudden I get the following error:

Action 'List_rows_present_in_a_table' failed: Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.

If I go to edit the flow I get this error message:

Failed to retrieve dynamic outputs. As a result, this operation's outputs might not be visible in subsequent actions. Error details: The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.'.\r\nclientRequestId: e05d597c-ffab-4cc5-9c1f-87d161923bcb", "error": { "message": "Graph API request failed. Error code is 'itemNotFound'. Error message is 'The resource could not be found.'." }, "source": "excelonline-we.azconn-we-003.p.azurewebsites.net" }

I have to repoint the parameter at the same file and select the same table again for it to work.

Has anyone else come across this and found a fix?

Thanks

Categories:

Using flows

I have the same question (4)

All responses (4)

Answers (0)

grantjenkins 11,063 Moderator on at

Like (1)

Report
I can't recall seeing this issue before. A workaround "AKA. hack" might be to retrieve the tables in the Excel file, then get the first table returned (assuming your Excel file has only one Table, or it will always be the first Table).

The expression to get the first table is below:

first(outputs('Get_tables')?['body/value'])?['name']

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

This could be caused by a token expiration issue. The connections are maintained using tokens which expire and are supposed to refresh automatically but could sometimes fail. When you repoint the parameter it recreates the connection with a new token.

Was this reply helpful? Yes No
AD-10041242-0 4 on at

Like (0)

Report

Update, when I relink the spreadsheet the table stays the same but the file changes:

Original:

"file": "01UDFABJT7YLT3FDW3NBEJECJT75AM7ADE",
"table": "{B5805672-F6BD-4A80-B5DA-C74E87DC0674}"

Re-Linked version:

"file": "01UDFABJTCQZ2TOK45VFA3UWBQWARHARJM",

"table": "{B5805672-F6BD-4A80-B5DA-C74E87DC0674}"

Was this reply helpful? Yes No
RS-08051429-0 12 on at

Like (0)

Report

Hi, we're experiencing the same issue with two Power Automate flows, and as you mentioned, it only happens occasionally. Did you find a solution?

Was this reply helpful? Yes No