Send automated email to more than one address, based on filter/lookup

[BenCarney]

Hi - I'm looking to send email notifications to multiple, specific people, based on a column in the team table.

Each record has a [Cloud or Industry], and within my Team Assignments, people are assigned Clouds or Industries they're responsible for. My problem is having the automation send the email to more than one person.

My current formula is:

Lookup([Cloud or Industry Name],"Team Assignments","Cloud or Industry Assignment","Email")

How do I get this to keep searching all the records in the table, and send to all contacts with that particular assignment?

[Marc_Dillon · Accepted solution]

LOOKUP() is a wrapper for ANY(SELECT()). The ANY() part returns only a single record. So you just need to use SELECT alone.

https://help.appsheet.com/en/articles/2357314-select

Additionally, for the to field of an email task, make sure to wrap it in TEXT() as well...TEXT(SELECT(...))

[BenCarney]

Thank you. End formula was:

Text(SELECT(Team Assignments[Email], ([_THISROW].[Cloud or Industry Name]=[Cloud or Industry Assignment])))

For anyone else who might get stuck here - I was having an error for a while because I used

[_THISROW].[Cloud or Industry Name]=Team Assignment[Cloud or Industry Assignment]

[Marc_Dillon]

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column...