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