cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JWB2423
New Member

Power Automate Dynamically Append Tables

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

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,656)