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

Do until loop sends all emails at once after flow times out

Hi

 

In the middle of my flow i have following logic:

1. Create item on secondary sharepoint list with simple unique "password" which is ID with some text (f.e. pass12) from first, main sharepoint list.

2. Send email with 1 button option to requestor - he is asked to fill the microsoft form, and then confirm action by clicking the button inside email.

Then I have another flow for submitting this answers to the item created at secondary list. It is quered by this specific password and it is working fine.

2020-02-20_9-47-08.png

 

3. Then, in first flow, I have check if requestor actually fill the form - he could click the button without filling the form.

2020-02-20_9-57-32.png

If he does everything well, the flow updates item. If he didnt fill the form, or enter wrong pass in form, but confirm by clicking the button inside email, flow enters the loop where 3.1 send next email alike with also info about possible errors 3.2 wait for click the button 3.3 check item if it is updated. The loop is running until the item is proper updated.

 

 

The problem is it works fine when I tested it. But yesterday, two seperate flows timed out (they were running more than 30 days), and they sent 60 (as limit count in do until action) emails to requestor in 2 minutes:

2020-02-20_10-09-21.png

 

2020-02-20_10-12-11.png

 

It was so bad reputational for me, as requestors are serious bussines partners. 

 

Do you know how to fix that ? I know it is a bit complicated, but I don't know where to find answer at this time

 

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft rimatos
Microsoft

Re: Do until loop sends all emails at once after flow times out

Hi @golabem ,

 

Looking at the Flow and the issue you presented, and since the e-mails were sent although the flow had timed out, i believe the issue might be in one of the actions after the e-mail is sent.

 

The reason the e-mail was sent these 60 times is the effect of this action being inserted inside the Do Until action loop. As such my recommendation would be to change your logic in a way that the e-mail is sent outside of this loop (e.g. before the loop), otherwise this issue might occur to you again.

 

An alternative for this would be to create a separate flow to evaluate the response of the requester once he clicks in the button, and construct your logic from there.

 

 

Hope this information has helped you in any way!

 

Regards,

Ricardo 

View solution in original post

1 REPLY 1
Microsoft rimatos
Microsoft

Re: Do until loop sends all emails at once after flow times out

Hi @golabem ,

 

Looking at the Flow and the issue you presented, and since the e-mails were sent although the flow had timed out, i believe the issue might be in one of the actions after the e-mail is sent.

 

The reason the e-mail was sent these 60 times is the effect of this action being inserted inside the Do Until action loop. As such my recommendation would be to change your logic in a way that the e-mail is sent outside of this loop (e.g. before the loop), otherwise this issue might occur to you again.

 

An alternative for this would be to create a separate flow to evaluate the response of the requester once he clicks in the button, and construct your logic from there.

 

 

Hope this information has helped you in any way!

 

Regards,

Ricardo 

View solution in original post

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (10,693)