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.
@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.