Unanswered

Repeat previous step using do until

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

v-yuazh-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
jasa88 8 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Dub66 7 on at

Like (0)

Report

Did you ever solve this?

Was this reply helpful? Yes No
jasa88 8 on at

Like (0)

Report

Still no solution I’m afraid.

Was this reply helpful? Yes No
Dub66 7 on at

Like (1)

Report

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.

Was this reply helpful? Yes No