Flow to send notification to managers with a list of staff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
53m ago
I have a requirement to send an email on an adhoc basis to managers of staff that have a staff member who's end date is coming up (we have a large contractor staff base).
This is to be instigated by another team and we store the end dates in the ServiceNow profile in a custom field called "u_accountexpirydate" or display name of "Account Expiry".
I have a notification set to be triggered by a flow called "IT account expiry notification"
The flow is being triggered by a catalog item that just has the date that is to be used to find all active accounts with an expiry date at or before that date.
I have used a look up records action on the sys_user table and can find the records and can generate an individual email to a manager for each staff member they manager, however that for example might mean that one manager will get 30 separate emails for 30 separate staff who have end dates.
Anyone able to give me an idea of how I could make it so it would loop through, find all staff for a single manager, send a notification to that manager with their staff listed, then move onto the next manager and so forth untill all managers are notified of their staff if they are to expire?
