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.