I cannot find the mistake - security roles acting weird breaking gallery with search and filter

[kenneth_here]

Hi,

This worked earlier, and I am pretty sure I did not change anything. I have 2 security role levels, IT Asset Manager, and not IT Asset Manager. For me, the IT Asset Manager, the gallery does not load in. For employees it does load in and works perfectly. So the error is somewhere in that region. 

EDIT: After some more thought, it seems like the problem is the 'in' operator. There is a lot of issues with it apparently, realising after some googling, but I cannot fathom the solution even though other people have been through something vaguely similar.

Hope someone can help. 

This code is from 'Items' 

Sort(
    If(
        LookUp(
            'Security Roles',
            Name = "IT Asset Manager",
            Role
        ) in Concat(
            LookUp(
                Users,
                'Primary Email' = User().Email
            ).'Security Roles (systemuserroles_association)',
            Role & ";"
        ),
        Search(
            Filter(
                'IT Assets',
                'IT Model'.Brand in _brandfilter.Result,
                'IT Model'.Type in _typefilter.Result,
                User.'Full Name' in _userfilter.'Full Name',
                Condition in _conditionfilter.Result,
                Year('Created On') in _yearfilter.Result,
                Price >= Slider1.Value,
                Price <= Slider1_1.Value
            ),
            TextInput1.Text,
            "na_name"
        ),
        Filter(
            'IT Assets',
            User.'Full Name' = UserName
        )
    ),
    Name,
    Ascending
)