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

 

 

flow.png

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.

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

flow.jpg

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

destination.png

 

 

 

 

 

 

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)

updated.png

 

Below is the flow snapshot

1.png

 

 

 

 

 

 

 

 

2.png