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.