I try to build a flow that is filtering a list o tasks then send an email based on specific conditions. I filter the task by an TaskID column. When all the task that have commune ID have the status completed i send an email.
When an item is modified i use the get items filter by this taskID to get all the items that have this ID.
Further i don't know how to check if all this filtered items (with specific ID) has status completed , and if all are completed i send an email to a manager, else do nothing .
In example bellow it's like this:
If task3, 4 and 2 (TaskID 1) are completed i send an email, else do nothing.
Thank you
My list have this kind of structure:
| Task | TaskID | Status |
| task3 | 1 | In progress |
| task4 | 1 | Completed |
| task1 | 2 | Completed |
| task2 | 1 | In progress |
