Hi,
we have the requirement to allow a user to upload a Excel File and import the data in it via flow.
Therefore I made a SharePoint trigger when the file was created and a excel online (business) connector to get the rows of a table.
Is it possible to add a dynamic path (the path of the uploaded document) instead of using the file picker?
Best regards
HI an_ht and @v-yuazh-msft
I created a template with a workaround for this issue. You can find the explanation and the template here:
https://manueltgomes.com/microsoft/flow/how-to-access-dynamic-path-excel/
Hope it helps you
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
Hi @ an_ht,
I have made a test on my side, you need to select an Excel file through File Browse in the “File” field of “Create table” action of “Excel Online (Business)” connector, rather than use the dymanic content of the new updated file in the “File” field.
Using the dymanic content of the new updated file in the “File” field of “Create table” action of “Excel Online (Business)” connector is not supported in Microsoft flow currently, If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
For you situation, you could add the excel file in the sharepoint library firstly, then you could use the trigger “Manually trigger a flow”, and you could select an Excel file through File Browse in the “File” field of “Create table” action of “Excel Online (Business)” connector.
Regards,
Alice Zhang