Hello,
Update:
On further investigation I have found that the problem is not with the deletion but the file creation. The file that gets created does not have the new row added to it. I think the file is getting created before the row gets added. Any idea, what could be the reason for that.
--------------------------------------
I have a flow where I am trying to do the following:
When a form is submitted, the response from the form added as a row to a table in a sharepoint file. This sharepoint file is more like the template to be used. The updated file is then copied to another sharepoint folder with a different name.
But now I don't want to retain the form response on the template anymore so I delete the row that was added.
Problem: When I delete the row - it gets deleted from both the template and the copy file. I have tried adding a delay of 5 seconds between creating the file and deleting the row but even then it gets removed from both the files.
I am using the following steps in the same order:
1. When a response is submitted
2. Get response details
3. Update a row -- for file name, I am not using any dynamic content
4. Get file content using path (I have tried using Get file content also)
5. Create file
6. Delete a row - this is when the row from both the files get deleted.
Any help on what I am missing?
-----------------------------------------------------------
Solved! Go to Solution.
Update:
I have found a post with similar issue. The problem is not with deleting the row but rather that the files gets created before the add row is completed. Adding a delay between adding the row and getting the file content can be used as a temporary solution. How much the delay time will differ from case to case so you will have to determine on your own. This author used a 50 seconds delay, mine worked with 5 seconds delay.
More details on the solution here: https://powerusers.microsoft.com/t5/Using-Flows/Add-row-in-Excel-not-working-all-times/m-p/469535#M1...
I am closing this issue now. Thank you to those who took out the time to go through it.
Hello @AnkitaM ,
I see that you are trying to update file A, copy the data from File A to file B and when you delete it from File A it gets removed from File B too.
I did the same operation and it's working fine for me. Would it be possible for you to share your Flow?
Just sharing here a screenshot of a Successful Flow Run and My Source and Target Excel Files.
Flow Run
Source File (Row has been deleted)
Newly Created File
Hi @NiloferA,
I tried again but it is the same. Here are the flow and the results.
Flow
Adding a row to the template
Getting file content
Creating new file in a different location
Deleting the row from template
New file
Template file
Update:
I have found a post with similar issue. The problem is not with deleting the row but rather that the files gets created before the add row is completed. Adding a delay between adding the row and getting the file content can be used as a temporary solution. How much the delay time will differ from case to case so you will have to determine on your own. This author used a 50 seconds delay, mine worked with 5 seconds delay.
More details on the solution here: https://powerusers.microsoft.com/t5/Using-Flows/Add-row-in-Excel-not-working-all-times/m-p/469535#M1...
I am closing this issue now. Thank you to those who took out the time to go through it.
User | Count |
---|---|
24 | |
15 | |
14 | |
10 | |
10 |
User | Count |
---|---|
44 | |
29 | |
29 | |
23 | |
22 |