select user email

[ADAJALAN]

I want make a task and send email with filter kriteria,

someone can helpme…

i’m use this formula, but can’t work :

Select(User[Email],
And(
[Email Automation]=Ya,
CONTAINS(USER[AKSES JOB SITE],[_THISROW].[SITE]),
CONTAINS(USER[AKSES MENU],VALIDATOR)
)
)

and i also try this :

Select(User[Email],
And(
[Email Automation]=Ya,
in([Site],[Akses Job Site]),
IN(“Validator”,[AKSES MENU])

))

[Marc_Dillon]

@ADAJALAN

Select(User[Email], And( [Email Automation]=Ya, in([Site],[Akses Job Site]), IN(“Validator”,[AKSES MENU])

)

IN() requires the 2nd arg to be a List. Are [Askes Job Site] and [AKSES MENU] Lists?

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

https://help.appsheet.com/en/articles/2357277-in