Adding rows to an Excel document with a dynamic filename

[jdmillar]

Hi all;

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.

Thanks,

Jason

[ChristianAbata]

hi my friend @jdmillar  possible you need to follow this example

[Jcook]

Hello @jdmillar 

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:

http://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow

[Anonymous]

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.