I have a SharePoint List that tracks the progress of creating a new material in our ERP system. I have a column- "Status" that is a choice column, and is not part of the Form for new entries.
The logic goes like this- Engineering creates a New item in the SharePoint list, and fills in the first few fields. The last field they fill in is a choice column with (2) options. This is the trigger that determines who the next department to work on this process is (US20 Operations OR US21 Operations) by setting the Status column to show this. Then the next department (US20 Operations OR US21 Operations) completes their boxes (all are Yes/No columns, with default set to No), in which the flow should update the Status to show the next downstream process name (Purchasing, Accounting, Quality, Sales, Complete). The last column of their respective columns is the trigger for the next department, and so on until the last department checks their box, then the Status will display "Complete".
I have a Flow setup that sets this column's value when a New Item is Created (US20 Operations OR US21 Operations)- and it works as intended.
Then I have a second flow setup where when an Item is Modified, it is supossed to update the Status column based on If the trigger columns (all Yes/No columns whose default is No) changes. I have it set up to check the trigger columns working backwards, from end to the beginning and then terminating if it finds a "true" condition- because as the SharePoint is updated by the various departments, their respective check boxes will be "true" and I would not want the Status to be stuck on the first step of the process.
Problem Statement: The flow tests successfully and no errors are found, but it is not Updating the SharePoint List as intended.
SharePoint List-
Flow-
When Item is Modified-
Test Results-
When Item is Modified outputs=
But, for the Condition action=
