Automation sending email some people role from another table

AppSheet AppSheet Q&A
,
1

Hi

I have an automation where I sending email some employees. The issue is I have to send the email some people if his area is x and position x

For instance,

The table where I have email is like this (Position is a REF column and Area is ENUMLIST) :

table 1

Name Position Area Email
Maria Marketing Manager Marketing, Corporate maria@mycompany.com
John Analyst Marketing john@mycompany.com
Taylor CEO Corporate Taylor@mycompany.com
Juan Asistent Marketing Juan@mycompany.com
Jenna Analyst Finance Jenna@mycompany.com

And, the table to trigger the automation is like this:

table 2

Id Date Area Production Production Hour Send invite
dej32 01-11-22 Corporate Room 2 18:30 yes
sdh4a 13-01-22 Marketing Room 3 14:32 No
saj42 20-01-23 Marketing Room 2 18:34 yes

The outcome desire is, when I add Id saj42 I send email to people with Area = Marketing and position = Analyst

The email must be sending only to John

I have tried formula like this in task “send a email” :

AND(

SELECT(table 1[Email], IN([_THISROW].[Area], [Area])),

table 1[Position] = ‘Analyst’

)

thanks

2

Try your expression like this instead:

SELECT(table 1[Email], AND(IN([_THISROW].[Area], [Area]), [Position] = "Analyst"))
2 Likes