List Rows Present in a Table preventing saving Flow Error

(0) Share

Report

Posted on by MJ-29031308-0

Hi Power Automate Community members

I'm running into an error with List Rows Present in a Table. Generates the below error when saving.

Flow save failed with code 'DynamicOperationRequestClientFailure' and message '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 'Item not found'.\r\nclientRequestId: e9f71cbd-199f-411b-a992-da5fa18eba16\r\nserviceRequestId: ae3c1c37-727e-4f6e-83f5-e98695e03edb", "error": { "message": "Graph API request failed. Error code is 'itemNotFound'. Error message is 'Item not found'." }, "source": "excelonline-ne.azconn-ne-002.p.azurewebsites.net" }'.

As per firstly Copilot's suggestion I have confirmed that I can access the file. I have deleted the step and added it again multiple times. I have downloaded the file and placed it in my OneDrive rather than SharePoint. I still get the same error. There is no dynamic content everything has been selected via drop-down. I have turned-off New Designer and tried again. I still receive the same error.

I am completely at a loss on this especially since the Flow was working around 4 weeks ago when this error started appearing. Please let me know if more details are required.

Here is the structure of the flow. I'm copying rows from one Excel into a new Excel file.

Here are the Parameters for List rows present in a table.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi

You haven’t mentioned whether the table itself was checked.

From your post, you confirmed access to the file, but you didn’t say whether:

the workbook still contains an actual Excel table

the table still exists

or the table is still named Table1

Can you check this please? Thanks!

Was this reply helpful? Yes No
MJ-29031308-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Chiaralina

I've checked the file and it contains an Excel table called Table1. So yes the table still exists and the workbook contains an actual Excel table. Please see a screenshot below for your reference. Any further steer on what might be wrong?

Thank you

Was this reply helpful? Yes No
MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@MJ-29031308-0,

As @chiaraalina mentioned the error is not clearly defined and there is no detail screenshot about the failure of the error.

Can you please explain the issue in details so that community can assist on this issue.

Was this reply helpful? Yes No
Mahesh Birudu 28 on at

Like
a
(0)

Report
Copy link

Link copied!

MJ-29031308-0,

The format below is meant to fetch records from Excel, but it looks like the default table is being used every time in the “List rows present in a table” step. Could you please check and fix this?

Was this reply helpful? Yes No
MJ-29031308-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Mahesh and other community members

I have modified the name of the table from Table1 to ExportTable.  Please see the second screenshot for this.

To add clarify to the problem, this error occurs when I click the Save button (as mentioned in my first post) below see the error in context in the first screenshot. There are no errors found by the Flow Checker.

Purpose of the flow

Copy an Excel file (export file) containing date reformatting script to a folder in my OneDrive and renaming it to include todays date.

Create a new worksheet in this file

Create a table in this worksheet with Column names matching the ENV March 2026 excel file

List the rows present in the ExportTable within the ENV March 2026 excel file

Use the For each loop to add each row into the export file

Run a script to reformat the dates and delete the unneeded worksheet

I hope this background helps.

The error is referencing  'GetTable' and that the file or Table is not found. I have selected the file via the dropdowns and can open it either on OneDrive or SharePoint. The flow is using my account as its connection. I have also shown via my post that file exist and it contains the Excel table.

Could anyone shed light on why the API request would fail when the file exists? I have also deleted my account from Connections and readded it then fixed the connections on each step of the Flow.

Thanks in advance!

Was this reply helpful? Yes No