Power Automate Dynamically Append Tables

[JWB2423]

Hi all,

I am having trouble with creating a flow to add regularly sent data onto a master spreadsheet.

Currently my flow triggers when a certain person sends an email with a certain subject line-

- Next Power Automate gets the attachment, renames it to a filename containing which dates it is to/from.

- It then saves the file into a folder in a SharePoint site with the new name

- An office script then triggers, cleaning the data appropriately, and converting the data into a table to be read

My problem is that the 'list rows present in a table' will not let me have a dynamic filename based on the string I used to rename the file previously.

As such I cannot select the correct file/table to be able to then create new rows in the master table.

I can however use a dynamic file name in the 'get tables' excel step.

Any help would be appreciated.

Best,

Joe