Repeat previous step using do until

[jasa88]

Hello,

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:

https://preview.ibb.co/mJO1fH/Flowrepeat.png

[v-yuazh-msft]

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.

Regards,
Alice Zhang

[jasa88]

Hi Alice,

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.

[Dub66]

Did you ever solve this? 

[jasa88]

Still no solution I’m afraid.

[Dub66]

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.