Compare lists to produce yes/no for slice

AppSheet AppSheet Q&A
, ,
1

Hi,

I have tried to find a solution in posts but I cannot figure out how to do this correctly. I have a Current_User() slice on my Users Table with roles and several other columns. One column in Users is a enumlist (ref) of Cost Centers. A user could have 1 or more Cost Centers. I have another table Projects that stores ProjectCostCenter. Each project could also be 1 or more in an enumlist (text).

My slice I am trying to create is for the User to only see Projects that have a match any cost center in his lists of cost centers.

I am not sure how to produce a yes/no for two lists and slice the projects for the matching records

2

I finally was able to find a solution that worked after searching posts.

Not(List()= Intersect(ANY(Current_User 2[CCNumber]),[ProjectCostCenter])

1 Like
3

Perfect :ok_hand: