email remainder notification

[PRAVALIKAREDDYL]

set up an email remainder that runs once a week and goes to the assignment group's manager of each queue with a description of all the past sla incidents that their team has open. existing report: when i opened it has count of the breached sla incidents and filter condition is like all active true and has breached true and task. task type is incident. and my requirement is like a weekly email notification is sent to each assignment group manager of any queue with an incident in breach of sla and all breached incidents for the managers team are included in the notification. 

[TejasSN_LogicX]

Hi @PRAVALIKAREDDYL ,

Create Flow: give name Name – “Weekly SLA Breach Email to Managers”.(run as system user)
Trigger: Scheduled → Run weekly (set time).
Action 1: Look up records from Incident table where Active = true, Has breached = true, Task type = Incident.
(we get all incident records where sla is breached)
Action 2: For Each → Loop through Assignment Group from the breached incidents.
Action 3: Inside loop → Look up Incident records again for that Assignment Group with same conditions (Active & Has breached).
Action 4: Look up sys_user_group table to get Manager of the current Assignment Group.
Action 5: Send Email → To Group Manager email, Subject: “Weekly SLA Breach Report for {{Assignment Group}}”.
Action 6: In email body, list the breached incidents (number, short description, priority, assigned to) using HTML table.

[PRAVALIKAREDDYL]

Hi @TejasSN_LogicX , 
i got confused, if you don't mind can you please elaborate the steps with screenshots?

Thank you!