Last recipient

[anna_2023]

Hello,

Building reminders fod incs & cases it turned out, not always people add email addresses to any field/watch list.

Is there any chance to get last email's recipient/or array of value/ for adding it as a dynamic content to the flow?

[mister_mentor · Accepted solution]

Anna, as with anything else on the platform there are many ways to accomplish this. As an example I created a business rule on the Email table.

When...{an email record (sys_email) for the target table of incident changes to sent}

Locate...{the incident and pull back the current watch list}

Lookup...{the email recipients on the user table and return email/ID}

Update...{the incident watch list with all new user ID's and email addresses}

See the attached update set. I would advise importing that into a PDI and reviewing it. I've commented out the code to help more easily understand it.

[anna_2023]

Thank you, will check it out!

[anna_2023]

Hello!
Thank you for your provided solution, mister_mentor, I've built smth around it, with the scheduled trigger, lookuping incidents and based on sys_email table data. Recipients are at their place ❤️

Best regards!