Power Automate - Get a Row - dynamic file

[Ckatz]

Hello,

We have a rather large flow that calls many actions. We're having trouble with this excel "Get a Row" action, when it fails it says that it can't find the specified table. However, the table is definitely in the file. I think the problem is the "dynamic content" type not working as expected. It's forcing me to use "Id" from a prior Get a Table action, which I don't want to use. I want to refer to a dynamic file from OneDrive, same dynamic file I'm referring to in the List Rows action right before this Get a Row action.

Additional detail for the Get a Row action

Apply to Each Output =dynamic content for List Rows "Value" from the List Rows action prior to this one

File=I apply the dynamic value for OneDrive Find a File "Id" (an action earlier in the flow)and after I save the flow and go back in, the flow changes the dynamic value to what is shown below Get a Table "Id" (an action earlier in the flow)

Table= The name of the table that is in every file in this workflow. The List of Rows action prior to this Get a Row action successfully recognizes the table from the dynamic file and lists the rows in the table.

Workflow Overview=

Trigger: New file is saved/created in OneDrive folder

Calls PAD flow: Refers to the OneDrive trigger file "Id" and then converts all excel files to .xlsx file extensions (does this by opening original file,save as with new extension, deletes the original file from the trigger)

Find File in OneDrive with Path: I find the newly created files from the PAD flow by searching for the original filename (without the extension)

Get Tables: I refer to the new dynamic OneDrive file "Id" from the Find File action (above) to see if there's a table in the file.

If Yes= the workflow ends

If No= the workflow continues to create a table w/specific table name in the file

Run Script: This script will run on the files that don't have a table. It refers to the dynamic OneDrive file "Id" from the Find File action and it will create a table w/specific table name

List Rows: I refer to the OneDrive file "Id" from the Find File action and list the rows in the newly created table w/specified table name

Apply to Each: Due to there being the possibility of multiple row from the List Rows actions, the flow forces me to use an Apply to Each here. I'm using the Output from List Rows "Values" in the Apply to Each

Get a Row: I want to get the rows from List Rows and then eventually add them to a completely different excel file. This is where the flow fails, it won't let me use the dynamic content value for OneDrive file "Id" from the the Find File action that I used on the other actions above it . Instead it changes it to "Id" from the Get Tables action

Any help or insight is greatly appreciated

Thank You

[Ckatz · Accepted solution]

I figured this out. For anyone else having the same problem, I was able to fix the issue by creating a "Compose" action for the OneDrive Find a File by path "File Id" and then using the dynamic output from the compose action in the File field for the Get a Row action.