
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 01, 2022 12:40 PM
Hi all!
Im trying yo send a gmail with an automation, I want to send an email to a list fo mails which are in a lookup record separated with commas.
I try to do this but the test says that my To field is empty
Some help, pls?
Many thanks
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 02, 2022 05:50 AM
Here’s a template for you to review. Seems to be working for me with a Rollup and ArrayJoin as the formula.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 01, 2022 12:54 PM
Instead of using a lookup, try a Rollup field.
With ARRAYJOIN(values)
as the formula.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 01, 2022 01:52 PM
Thanks,
it is the same
some other idea?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 01, 2022 04:16 PM
Did you re-test your trigger step?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 01, 2022 11:11 PM
yes, i build a new automation, but is the same problem
the field is just emails with commas…
Some idea, sirs?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 02, 2022 05:50 AM
Here’s a template for you to review. Seems to be working for me with a Rollup and ArrayJoin as the formula.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 02, 2022 11:36 AM
Many thanks!!
Now it works!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 08, 2023 01:15 PM
Any way someone can let me know how to do this. The above links AND image is not working

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 17, 2023 01:27 AM
I also followed this solution and works for me.
First you need to add field as rollup field. you can find it when you scroll it down when adding a field.
check the table you want to lookup from.
choose the field you want to bring in to the table.
write the formula to the aggregation formula box as ARRAYJOIN(values)
and then, you can go to automation and trigger as you want the conditions to be.
for 'send an email' action choose your newly added rollup field for "To"
I hope you'd already have found the way out.
