Power Platform Community Forum Thread Details

Hi everyone,
I’m working on a Power Automate flow and running into an issue with Excel actions.
What I want to achieve:
Whenever any Excel file is uploaded to a specific SharePoint folder, the flow should read the table inside that file and use the data to populate a new Excel file.
Current setup:

Trigger: When a file is created (properties only)
Action: Get file content using path
- The path is built dynamically using Filename with extension from the trigger
- This part works and always picks up the correct uploaded file
Next action: List rows present in a table
- File: dynamic output from Get file content using path
- Table: "Accounting" (same table name and structure in every uploaded file)

The problem:
List rows present in a table fails during testing and says the table cannot be found, even though it definitely exists in the file. Since each uploaded Excel has a different filename, I can’t select a fixed file in this action.
Question:
What is the recommended way to read data from any Excel file in SharePoint when the filename changes but the table name and schema are always the same?
In short: take the uploaded Excel, read table Accounting, and create a new Excel from those rows.

Any guidance on best practices here would be appreciated.

Categories:

Building flows

Power Automate Desktop