I'm trying to get a flow to insert a row into a table, but it won't do it if the spreadsheet was recently opened. What I want to do is for the flow to attempt to insert the row but if the spreadsheet is locked, wait a few minutes and then try again. I've tried to use the Do Until to make this work but I haven't been able to get the syntax right.
Here is a graphic representation of what I'm trying to do:
Hi @ jasa88,
Do you want to create a flow to insert a row in the excel, and if the excel is locked, the flow would wait for a few minutes and would insert the row to the excel again until the row is inserted in the excel.
I have made a test on my side, and try to use "Do until" to realize your needs, but I couldn't manage to realize your needs currently, I would try again in the later, if I could accomplish your needs in the flow, I would reply here.
Yes that's exactly what I'm trying to do. I tried to use a do until and set the condition to be when row_id is equal to row_id (in other words, once the row has been inserted into the spreadsheet and is assigned a row_id), insert the row, but if it fails, wait 5 minutes and loop again. The problem is that it keeps saying that the flow was successful after waiting 5 minutes and it doesn't loop around.
Hi Jasa, I gave up on writing to Excel and switched to storing in sharepoint list instead.
I did find a great post that helped me with "Do Until" https://powerusers.microsoft.com/t5/Building-Flows/do-until/td-p/95974
Clearing the count made my Do Until work for me.
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!