Power Platform Community Forum Thread Details

Hi All,

Been trying to solve this for the last couple of days but seems like I need help now.

I'm creating this flow that triggers when I receive an email with an excel attachment, the first stage of the flow is to save the attachment (by replacing an existing file) in a SharePoint folder, then convert the file to a table format (using the run script action to allow Power automate read the content), then auto send an email to specific people using the emails from the newly replaced file content (email column).

The issue is, I keep getting error from the "List rows present in a table" Action. It appears like the "Table" Parameter (or Table id) keeps changing every time the file updates with a new file (from the first run script part of the workflow) even though it's still the same filename and tab name.

Error code snippet - "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 'The requested resource doesn't exist."

Any help will be much appreciated.

Categories:

Building flows

Using connectors

Using flows

Power Automate Desktop

General topics

Hi @CU13031742-0,

Why it breaks

Table IDs aren’t stable when you recreate/replace a workbook. Even if the file name and worksheet name are the same, the internal table ID/GUID is different after your “Run script / convert to table” step creates a new table. When a flow action has the “Table” parameter set to a previously discovered ID, it later fails with GetTable NotFound.

If you delete and recreate the file (same name), SharePoint/Graph assigns a new file identifier, so any step bound to the old ID also fails.

How to fix:

Immediately after that, add Excel → Get tables for that file and use the returned Id of the table for the next step. Don’t hard‑wire the Table parameter.
Use Excel → List rows present in a table, set Table = dynamic content → Id from Get tables.

You might get some help from the below blog for receiving the table name dynamically from an excel sheet that has uploaded to a SharePoint document library.

Merge Multiple Excel Files into One Master Table on SharePoint

Merge Multiple Excel Files - Workflow Screenshots

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.