Showing results for 
Search instead for 
Did you mean: 

Cannot use EXCEL file ID on action Insert Row

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.




Status: Under Review

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.

Level: Powered On

@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....


Level: Powered On

Hi @zdliang,

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.test.png

Level: Powered On



Assume below Excel is your source file.Source.png






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