Using IN() with List() Problem

[EugeneB]

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

[Marc_Dillon · Accepted solution]

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.

[EugeneB]

@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])

[EugeneB]

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

[Marc_Dillon]

That is a good way.