Power Automate extract data from excel with dynamic file path and write to another excel file

[ethan_anderson]

Hello,

I am trying to create a flow that when a file is created in a folder: 

- get the file content (excel file) *this file name is going to change so it needs to be dynamic

- list rows present in a table

- add row into a table (excel file) *this file name is static

- delete file in folder

When I run the flow is says it ran successfully but I am unable to see any of the outputs past the Get Files (properties only) action

[ethan_anderson · Accepted solution]

This solved my issue.

Power Automate: Use Excel connector with dynamic paths or files - YouTube