Add row in Excel not working all times

[Syaeger]

I have a flow built that in one section it get the response data, adds a row in excel, copy's the file and save it, then goes back and deletes the row in the original excel. 

This flow works successfully for a few times, and then all of a sudden the new files being created do not have the response in the Row on the Excel, but the flow results show them there. 

I have tried putting in delays before and after the Add Row, but the same issue comes up. 

Does anyone have any thought on why this would work successfully for a few times, and then stop?

Thanks for any help. 

[v-bacao-msft]

Hi @Syaeger ,

Could you share a screenshot of the Flow configuration? We need to reproduce your logic on our side and see if it will produce similar problems.

Best Regards,

[Syaeger]

@v-bacao-msft - Please see the screenshot of the full flow here. Screenshots have a caption on the order. 

I have been able to confirm that the row does get added to the master file, but when it is copied and saved to the new folder, the row is missing. I can not answer if the row is deleted before the copy, or if the added row does not make in time before it is copied. 

[kblair]

Hi SYAEGER

Did you solve this?  I am trying to do exactly the same thing but cannot find a solution.

[Syaeger · Accepted solution]

Hello kblair, 

I was not able to technically fix the current flow to make it work, but I did discover what was causing the issue and have a work around. 

The step of adding a row was not happening quickly enough, and so when the Copy of the xcel was made and saved to the sharepoint library, it was copying without the added row.  

I updated the flow to be the following:

After adding a row, I put in a delay of 50 seconds.

Additionally I removed the action to delete the row.

Because I removed the delete row action, In the excel I had to create the formula in the cell that needed the answer from the table as the following: (the excel tab is labeled Do Not Touch)

=@INDEX('Do Not Touch'!P3:P42, (COUNTA('Do Not Touch'!P3:P42))+1, 1)

This allowed the document to always grab the next answer that was added to the table every time one was created. as you can see  my master file is currently on # 42 of added rows.

This is working smoothly, and occasionally I go in and remove all the added answers in the table to keep it clean.  I have not tried putting in the 'remove row' on the excel again.  I may do this later.  The cause of the row not adding in the first place, was the delay wasn't long enough and the action could not complete in time. 

I hope this helps. 

[kblair]

Thanks for the feedback.  I feel like I'm so close but keep hitting walls.  All I want to do is make a copy of my file my_template.xlsx, populate it with data from a Form, then change the name using some of the data from a form.

I Tried a 3 min delay and still got old data.  In my flow I am updating the 1st row on my table, delaying 3 mins then copying the file.  I believe because the file is checked out/locked as the flow is running I am getting the previous version of the file.

I'm going to try running 2 simultaneous flows on the form updating.  Flow 1 will update template.  flow 2 will wait 2 mins then perform a copy.  It may work but the logic is then broken if I have two forms submitted in quick succession.

I'd be interested in your thoughts.

[kblair]

Getting closer.  I've put the delay back in and its working, until I try to submit two forms in close succession.  It returns two copies of the first submission, as the second instance cant update the root file as the first instance has it locked.

This would be solved if we could set a dynamic name for the file.

[AnkitaM]

I was facing the same issue and others were not able to reproduce it. I am so glad I found your post.