Cannot compare list with text : send email to multiple users with one criteria

AppSheet AppSheet Q&A
1

Hello,

I am getting the error “Cannot compare Text with List in ([[CENTRE PROFIT NOM COURT]] = relais[agence])” from the Expression Assistant when configuring email automation recipients.

My appsheet uses 2 tables : one with general data and one with contacts, I cannot link these two tables into one.

I want to send a email to all the contacts in my second table which meet the criteria of the first table.

I have tried :
relais[agence]=[[Centre profit nom court]]

And:
SELECT(relais[email],(relais[agence]=[[Centre profit nom court]]))

But neither work. Any ideas? Many thanks!

2

The error tells you exactly what the issue is. You cannot compare a list to a text.

This means one side of your “=” is a list while the other side is a text.

“My Text” = LIST(“Text 1”, “Text 2”)

This wont work.

And what is this [[Centre profit nom court]] with double brackets? I havent seen that before.

2 Likes
3

Should be:

SELECT(relay[email],([agency]=[_THISROW].[Profit center short name]))
2 Likes