How can I send an email notification to multiple recipients that are in the same area as the person submitting the app sheet form,

[YIK3S]

I have an app sheet where users input their information and choose which area they are from. I want to be able to send email notifications when they submit but also send that email to other people in the same area as them, how can I do so. Please let me know

[YIK3S]

This is what I’ve done so far

[Aurelien]

Hi @mshello

Welcome to the community !

What about this ?

SELECT(PeopleToInform[Email address],
[Market Area]=LOOKUP(USEREMAIL(),"PeopleToInform","Email address", "Market Area")
)

For efficiency, I would use a slice and run the email on this slice.
Slice “sameAreaPeople”, with row filter condition:
[Market Area]=LOOKUP(USEREMAIL(),"PeopleToInform","Email address", "Market")

Then, expression for email list :
sameAreaPeople[Email Address]

For reference:

help.appsheet.com

Slices: The Essentials

Display only certain rows or columns of your table with slices.

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[YIK3S]

thank you so much!!