Answered

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

(0) Share

Report

Posted on by MarCBB

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?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ed Gonzales 4,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MarCBB 49 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No