Sending 1 email notification for all 7 days approval reminder

[markchristianh]

Hi All,

I have created a flow that triggers an event to send an email notification for every approval record that are created 7 days ago, but this is sending email for each record, I'm thinking of a way if it's possible to send  all the users pending 7 days approval record  in one email?

example:

user Beth Anglin

pending 7 days approval

3 RITM approvals

2 Change request

instead of sending  email for each record the notification will send 1 email for each table (RITM, CHANGE)

[Mark Manders]

You can use a mail script to do the count and print that in the email.
I would create a flow to check on all users that have open approval requests that have been created 7 days ago (or older).

Then within a 'for each' you can use the 'send notification' to send it to each user. Add a link to the portal where they can find all of them.

You could add all kinds of things in the mail script, from just getting the number of open approvals to all the information from the approval itself (for what, how old, or anything else).

[markchristianh]

Thanks I'll try this out will post the outcome here

[Ankur Bawiskar]

@markchristianh 

who is the recipient here?

Are you sending email to Approver's Manager stating this person has 3 RITM approvals pending, 2 CHG approvals pending etc?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[markchristianh]

sending to the approver itself (beth anglin), the notification goal is to remind them of the pending approvals