cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jasa88
Level: Powered On

Repeat previous step using do until

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

5 REPLIES 5
Community Support Team
Community Support Team

Re: Repeat previous step using do until

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
Level: Powered On

Re: Repeat previous step using do until

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
Level: Power Up

Re: Repeat previous step using do until

Did you ever solve this? 

jasa88
Level: Powered On

Re: Repeat previous step using do until

Still no solution I’m afraid.
Dub66
Level: Power Up

Re: Repeat previous step using do until

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. 

  

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 165 members 4,698 guests
Please welcome our newest community members: