Skip to main content

Automation, send to multiple email addresses in Rollup field?

  • May 24, 2021
  • 4 replies
  • 70 views
S
Forum|alt.badge.img+7

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

4 replies

Kamille_Parks11
Forum|alt.badge.img+27

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

S
Forum|alt.badge.img+7
  • Strategy_Team
  • Author
  • Participating Frequently
  • May 25, 2021

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


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_Parks11
Forum|alt.badge.img+27

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


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)

kuovonne
S
Forum|alt.badge.img+7
  • Strategy_Team
  • Author
  • Participating Frequently
  • May 28, 2021

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)


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

Terms & ConditionsAccessibility statement