I want to create a email notification that is triggered monthly on the last day of the month. It should send an email to all members of a specific team, and each team member should receive an email with a list of all open incidents that were assigned to them within the last 30 days. Is this functionality possible with flow designer?
EDIT: I've got the some of the logic I want to accomplish set up in flow designer, but I'm still having a few issues.
Firstly, I'm using a flow variable to hold the list of open incidents for each team member. When an email is sent to a team member with their open incidents, the sys_id of the incident is shown instead of the number. To remedy this, I tried using the following script when I set the flow variable:
var incidentNum = fd_data._3__look_up_records.records.number;
return incidentNum;This did not display the incident number, but nothing instead.
Secondly, I want these values to stack vertically instead of horizontally as seen below
