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
