Hi @spoye ,
Thank you for the reply.
Believe this is stored in a list in SharePoint.
Option 1:
You could trigger against list modified or created. Check all the checkboxes are set to true. Disadvantage is flow will trigger multiple times (minimum 8 times).
Option 2:
If you don't want the flow to trigger mulitple times then schedule your flow to trigger once or two times a day. Look for the list and check all the checkboxes are set to true or not. Here the disadvantage is email won't be going immediately after all the checkboxes are set due to flow is triggered on a particular schedule interval.
Option 3:
I am not sure about this. You could investigate whether you could dynamically show a field and set a particluar value. So in your case create a new field called "All Dept Ok" (Check box. Default as false). This field will be hidden in your form initially. When ever the form gets saved you need to check all check boxes are set then set this value to true. Trigger a flow against this new field when it is set to true. So to achieve this you need to customise your form to set some dynamics values.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
Thanks
