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

SQL When an item is modified (V2) stuck in a Loop

Hi there,

 

I have a flow that is triggered by When an item is modified (v2) SQL Server, but it is stuck in a loop because the last step of the Flow is to update an item in SQL Server, thus triggering the flow to run again. How do I get around this?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: SQL When an item is modified (V2) stuck in a Loop

@MarCBB, Hi there! Check out this article from Melissa Hubbard on infinite loops. That might get you closer to where you'd like to be. (Apologies for the full link, stuck in jury duty with super slow WiFi so Rich Text wasn't an option). https://melihubb.com/2019/04/20/the-infinite-loop-what-it-is-and-how-to-avoid-it/ Keep us posted. -Ed-

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: SQL When an item is modified (V2) stuck in a Loop

@MarCBB, Hi there! Check out this article from Melissa Hubbard on infinite loops. That might get you closer to where you'd like to be. (Apologies for the full link, stuck in jury duty with super slow WiFi so Rich Text wasn't an option). https://melihubb.com/2019/04/20/the-infinite-loop-what-it-is-and-how-to-avoid-it/ Keep us posted. -Ed-

View solution in original post

MarCBB
Level: Powered On

Re: SQL When an item is modified (V2) stuck in a Loop

Yeah, that works, it does trigger the flow a second time, but with the logic check-in place, it ends there. Thank you @edgonzales 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand 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!

Users Online
Currently online: 358 members 4,629 guests
Please welcome our newest community members: