I'm attempting to create a flow to export the contents of a document library (metadata, not document contents) to an Excel workbook. For business purpose reasons, I'm creating the Excel workbook dynamically. How can I configure the Add Rows action to allow me to specify a dynamic filename? I can enter dynamic content for the filename, and enter the table name manually, but I can't figure out how to specify the list data-to-column mapping since it can't read the metadata for the Excel table due to the dynamic filename.
I hope I'm explaining that clearly enough.
At this time Flow does not support Excel dynamic file names within the excel connector.
As a work around follow this great blog post by John Liu:
I had a similar issue to try and dynamically create an excel document based on microsoft forms responses. The way I worked around it was by having a template blank document with 2 tabs, front sheet and data.
The front sheet duplicated the data tab in a format that could be easy to read and the data tab has a single row ID 1 where all the answers from the form get put into following a form submission.
After a minute delay to give the sharepoint site time to update, the flow would then copy the file elsewhere and blank out row ID 1 ready for the next. Concurrency of 1 means only a single instance at a time and no overlap.
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.