Insert row can not be used with file ID. Get rows and other actions work fine.
Also, when EXCEL file is replaced,ID changes and flow don't recognise it anymore. The idea would
be to make ID dynamic , not static.
Thank you for the suggestion. What you are asking for is the ability to use an action with dynamic input but without selecting a particular file when you're designing the flow. We will evaluate this feature.
@amitK , the following chart is my testing flow. Update a row in an excel table, copy it to place A, then update another row in the same excel, copy it to place B. Sometimes, in place B, the content doesn't include the change made at 3rd step. This morning, I added delay action after update a row, it works better, no more issue. But when I try it in my real flow, sometimes, I can still encounter issues the content is not updated. It seems for a simple excel, the delay time is short, such as my example file, only 11k, for a big excel file, such as the file in my real flow, it is 10 MB, the delay time should be longer, now I use 1 min, failure rate is 50%, I will increase it to 2 min, and do more test. Anyway, working with Excel connector, nothing is expectable....
Assume below snapshot is of test.xlsx.
Now to replace content of seq "1" from "original content 1" to "test 1", from where do you get the "test 1" data. (I am assuming you are collecting "test 1", "test 2" data from some other excel and copying updated excel into folder like 1, 2, 3 depending on seq column number)
Can you please send snap shots of Excel file from where data is to read and destination excel file snapshot, which will be copied in folder like 1, 2, 3 as I am not understood required flow.
Assume below Excel is your source file.
and below is your test file
And after running flow, test file will be updated as shown below, is this something you are looking for? (copy file function is skipped in below flow)
Below is the flow snapshot