Using IN() with List() Problem

Anyone know what’s wrong with it? just wondering why the expression is not match the IN() with the LIST()

An expression of the form table[colum] already returns a List type, you do not need to wrap it with LIST(), and that is probably what is causing your error here.

3 Likes

@Marc_Dillon awesome, spot on. thanks .

what if i have two LISTS for the IN() to be checked against? let’s said a column
_AccessRoles[Service Desk] and ,_AccessRoles[Field Engineer])

OR ( IN(USERSETTINGS(Access Code), _AccessRoles[Admin] ), IN(USERSETTINGS(Access Code), _AccessRoles[Service Desk] ) )

Is this be a good way of doing it or there is a better way

That is a good way.

3 Likes