Unanswered

Flow Fails with error: Action 'List_rows_present_in_a_table'

(0) 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:

Business Process Flows

All responses (3)

Answers (0)

AD-10041242-0 2 on at

Like (0)

Report

Flow Fails with error: Action 'List_rows_present_in_a_table'

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}"
ronaldwalcott 3,126 on at

Like (0)

Report

Flow Fails with error: Action 'List_rows_present_in_a_table'

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.
grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Flow Fails with error: Action 'List_rows_present_in_a_table'

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']