
Announcements
Hi,
I need to send an email to the approvers who has completed their approvals, and email should not trigger to the one whom we have sent the email already.
I have Status column in SharePoint of type dropdown with Approved/Reject.
here we need to send an email to Approver when all his status is filled with Approved or reject.
likewise, I have nearly 450 approvers for whom I have to send an email when his records are completed.
Note: Email should trigger only when all are completed
Ex: Approver Ahemed has 5 records, so email should trigger when all 5 records status is completed.
Hi @Ahemed ,
To meet the requirement, you can follow the steps below:
1. Trigger the flow using the "When an item or a file is modified" trigger.
2. Add an action to query the items based on the triggered item's EmpId and Status equal to null. You can use the "Get items" action with a filter query like this:
EmpId eq '@{triggerOutputs()?['body/EmpId']}') and (Status eq null)
3. After the "Get items" action, add a condition to check the count of retrieved items
length(outputs('Get_items')?['body/value'])
4. If the count is zero (meaning no items were retrieved), add an action to send an email notifying that all approvals completed
Please consider giving it a thumbs up!
Click "Accept as Solution", if your problem has been resolved.
Regards,
S.Venkadesh