Cannot compare list with email

[benny94]

Vorrei mostrare un determinato menu solo all'utente con livello di revisione = 2 e se l'e-mail del richiedente = all'utente che ha effettuato l'accesso,
AND (CONTAINS(
FILTER(Reviewers,[Review Tier]="2"),
USEREMAIL()) ,
USEREMAIL()= UNIQUE(request[e-mail richiedente]))

ma ricevuto:

Impossibile confrontare l'e-mail con l'elenco in (USEREMAIL() = UNIQUE(richiesta[e-mail richiedente])) 

[dbaum]

---

@benny94 wrote:

USEREMAIL()= UNIQUE(request[e-mail richiedente]))

---

The UNIQUE function returns a list (even if the list comprises only a single value), while the USEREMAIL function returns a single value. I don't know exactly what you need, but the following would avoid the error you received. You may want to use the IN function also where you currently use CONTAINS.

IN(USEREMAIL(), UNIQUE(request[e-mail richiedente])))

[benny94]

hello, thanks for your response

but not work, because:

list return: aaa@gmail.com, bbb@gmail.com, xxxx@gmail.com

e useremail(() is aaa@gmail.com, 
therefore, aaa@gmail.com can also see requests entered by others and not only those entered by itself

[Steve]

Something like this?

IN(USEREMAIL(), SELECT(Reviewers[Reviewer Email], (2 = [Reviewer Level])))