Seeing many request for Dynamic Content in Excel. Please add the ability to get dynamic content in the file field so we can perform operations from newly created Excel Files.
We have to be able to choose a file at runtime for the Flow to make it useful. I am working on a project where I have a whole library of the exact same formated Excel files. Each file has the same table structure, just filled in by different people. I need to be able to process each file in the library, but that is not possible if I have to select the file in Flow, because then I can only choose one file from the entire library to work with.
Currently trying to get excel reports based on a template, we want to create a new copy of the template and write certain rows to a table to display data. However if we dynamically do this, we cannot update or create new rows at runtime as the Excel connector is unaware of the columns available in the table.
If dynamic content allowed you to specify custom columns in a custom defined table that you know exists at run time. It would solve everything
Excel Connectors and Actions in flow are a great idea but the obligation to indicate the name of the file cut off the huge possibilities to create incredible and usefull solutions. It would be a great new if the file parameter, table, key column and key value could be set dynamically.
Please, don't leave good ideas halfway.
it would be completely useless if it cant set to dynamic content
I have to use some Excel file as a template, further I copy it as new file and update rows in the table, after this I can attach\send etc the newly created and filled file.
*If I use workaround with some general master-template and all MS forms triggers put the data into the one file I had two issues:
1. mixed data - in case two MS Forms responces are very close by the time (in one second period close to each other)
2. corrupted master file template - do not know reason but I have it, and have to recover it periodically