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

[Julie-Anne97]

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!

[JPAlpano]

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. 

[Steve]

---

@Julie-Anne97 wrote:

SELECT(relay[email],(relay[agency]=[[Profit center short name]]))

---

Should be:

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