compare two lists

[DjLeiiii]

First List was [userroles] = numblist

2nd Lists was using any(select(employee[department],USEREMAIL() =[email])) to find

I been looking at alot of references from here and youtube but non works. Can anyone of you help me?

first scenario

[list 1 ] = {1, 2, 3}
[list 2 ] = {1,5,6}
=true

[list 1] = {1,2,3}
[list 2] = {4,5,6}
= False

[JuneCorpuz]

Try this: IF(ISNOTBLANK(INTERSECT("List 1", "LIst 2")), TRUE, FALSE)

[Aurelien]

Great catch.

More simple:

ISNOTBLANK(  INTERSECT([List 1], [List 2]))

For reference:

INTERSECT() - AppSheet Help

 ISNOTBLANK() - AppSheet Help

[DjLeiiii]

@JuneCorpuz 

Error. i been trying to around  :((

[JuneCorpuz]

Put LIST() for each parameter inside your INTERSECT() expression

[DjLeiiii]

Any idea what should i do? 

[1minManager]

So by using ANY(... your telling appshet that this will be a single item and not  a list.   Thats why INTERSECT() is erroring, as it insists on 2 lists.  Removing ANY() might work equally as well assuming that ...UserEmail=[Email]... only ever pulls in one record

[DjLeiiii]

@JuneCorpuz  Hello June i found the solving method i dont mind to share it here so you can have idea about it also! :DDD But thank you for taking yout time to help me 🙂