You’re offline. This is a read only version of the page.
63
I got stuck while using Excel Connector, "Add a row into a table".
I need to add a flow using the connector with dynamic excel files.
I referenced to the information below and successfully get the file ID of the excel file.
How to Read and Write from Dynamic Excel Files with Microsoft Flow
https://johnliu.net/blog/2019/5/workarounds-needed-to-use-the-excel-connector-in-microsoft-flow
https://www.youtube.com/watch?v=64lSykOYmzI
However when I use it in my flow, it get error:
I set up a parallel step and compare between using dynamic file or choose file directly in the step.
I cannot found any difference in the "show input raw ".
"Show input raw" - Success: direct choose file
"Show input raw" - Failed: use expression to fill up dynamic file ID
Please kindly advice what I did wrong on the settings.
Thanks.
Peek Code of both steps are provided below.
I can only found the system has added metadata information at the end of the code (circled in red) after i choose the file. But i don't think it is related to my issue now.
"Peek Code" - Success: direct choose file
"Peek code" - Failed: use expression to fill up dynamic file ID
Share
Report
All responses (
Answers (
