Hi all,
I’m trying to make a show if filter based on an column with email adresses in there. Based on THIS webpage i used the first one.
Table = Toegang
Colmn = Acces
1: USEREMAIL(Toegang[Acces])
2: Toegang[Acces] = USEREMAIL()
I get this on 1: USEREMAIL is not used correctly
I get this on 2: Cannot compare List with Email in (TOEGANG[Acces] = USEREMAIL())
Hope somone can help!
Solved! Go to Solution.
The USEREMAIL() function takes no arguments, so USEREMAIL(Toegang[Acces])
is invalid.
USEREMAIL() produces a single value, but Toegang[Acces]
produces a list of values (see Constructing a List in List Expressions and Aggregates). You can’t directly compare a singular value to a list, so Toegang[Acces] = USEREMAIL()
is also invalid.
To check whether a singular value (e.g., USEREMAIL()
) occur in a list of values (e.g., Toegang[Acces]
), use the IN() function, like this:
IN(USEREMAIL(), Toegang[Acces])
The USEREMAIL() function takes no arguments, so USEREMAIL(Toegang[Acces])
is invalid.
USEREMAIL() produces a single value, but Toegang[Acces]
produces a list of values (see Constructing a List in List Expressions and Aggregates). You can’t directly compare a singular value to a list, so Toegang[Acces] = USEREMAIL()
is also invalid.
To check whether a singular value (e.g., USEREMAIL()
) occur in a list of values (e.g., Toegang[Acces]
), use the IN() function, like this:
IN(USEREMAIL(), Toegang[Acces])
THANKS STEVE ! , this did the trick for the app that i’m building, thanks a ton for all that you do .
Ciao Steave, se io volessi estrarre un valore dal una lista e confrontarlo con USEREMAIL(), come posso fare? Grazie
Please start a new topic for help with this.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |