Hello Everyone,
TLDR: Can I populate the {to} field in the "send an email" action with a conditional list of email addresses?
I have a user accounts table with typical user account stuff (name, email address, etc.). In that table there is a single select field to describe each user's role within our org.
I would like to send an automated email to everyone who matches a specific user role when certain record triggers fire. I.e. "When a record is updated, send this email to all users with the role of {team leader}".
The list of users will not be static over time. Thus, I need automation to read the record data at the time the trigger fires, and fetch the appropriate email addresses for inclusion into the email {to} field.
We are on a pro account.
TIA
