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)

[Ankur Bawiskar]

@markchristianh 

so it means 1 email per approver listing down pending approvals

see below link where I shared solution for something similar, enhance it

I used scheduled job for that earlier

Email script 

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

[kaushal_snow]

@markchristianh ,

You can schedule a daily SN job (or a Flow) that queries sysapproval_approver for records in Requested state older than 7 days, groups them by approver, fires an event for each approver, and uses an email notification with a mail-script that looks up all their pending approvals (RITM / Change / etc.), builds a single HTML table, and sends one consolidated email per user instead of one per record......

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.