High level - I have a single SharePoint list I am using for tracking purposes. Multiple columns for each department and a status associated to each department. I want to update status automatically with flows when a department adds an assessment in their associated column. So initially - my flow trigger is "when an item is updated" because it's waiting for a department to add their assessment. If they do, then I call a "update item" looking at the field that was updated, so I can update the column next to it (the status). But that "update" would trigger the initial "when an item is updated" and cause a loop again and again. Am I using the right triggers/actions? or is there any control I can add to ensure this doesn't happen?
