I have 3 SharePoint lists:-
1) Posting Process
2) Posting Forms
3) Posting Process Posting Form. which stores the relation between the above 2 lists using the ID of the above list items.
And i want to build a process that email the managers when the Posting Process is completed (All the Posting Forms have their status as "Done")
Now in the schduled flow i am doing the following:- I am getting all the active "Posting Process" items >> then for each Process i am getting all the "Posting Process Posting Form" items >> then for each "Posting Process Posting Form" item >> I am getting the related "Posting Form" and check it is status = "New" or "Work Order Created" >> If so then this means that the Process still has at-least one not completed form...
Here the related sections of my work flow:-
1) First I am getting all the active processes + i am setting a variable to false:-
2) Loop through all the Active Processes >> and get all the relation items >> get the related Form, as follow:-
3) check the Form status it is not set to Done (either Status = New or = Work Order Created) >> if so set the Variable to True:-
Here is the overall steps:-
But the issue i am facing is with the efficiency of this flow. because if there is one Form with status = New Or =Work Order Created and i set the variable to true.. then i do not need to continue the current iteration of the ApplytoEach.. and i need to skip it and execute the next iteration and so on... so how i can achieve this inside my above actions? to improve the performance of my flow??
Thanks in advance for any help..
