cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarCBB
Advocate II
Advocate II

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
edgonzales
Super User
Super User

@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
edgonzales
Super User
Super User

@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-

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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,368)