Automation, send to multiple email addresses in Rollup field?

[Strategy_Team]

Hello,

I’m currently trying to setup an automation that will send off a notification email to multiple addresses (“Team managers”) when a record is created (or updated), if said record has linked to multiple other records in a specific field (“Other teams involved”). The email addresses are pulled through from another table using a Rollup field and ARRAYJOIN, and so are separated by commas, but the automation test fails, saying that the email address field is invalid.

Do automations not support sending to multiple email addresses? Any clarity would be great.

Many thanks and kind regards,

Matt

[Kamille_Parks]

Email steps do accept multiple addresses. Can you post a screenshot of your setup?

[Strategy_Team]

Hi Kamille,

Never mind, I appear to have figured out a solution using another prior automation to duplicate the email addresses from the lookup field (which seems to have been the issue) into a hidden long text field, from which the second automation now reads them correctly and sends them.

Many thanks for offering your help!

Matt

[Kamille_Parks]

If you want to avoid having extra fields you could also just convert the Lookup field to a Rollup field with an aggregation using ARRAYJOIN(values)

[Strategy_Team]

That has indeed streamlined both the data and the process! One less automation to achieve the same result. Many thanks for the tip :slightly_smiling_face:

Matt