cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kenneth_here
Frequent Visitor

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

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
)

 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,059)