I'm using the helpdesk power app from Microsoft. I want to make a simple filter in the gallery, but I can't figure out how the expression should look.
The OOB expression is like this - showing alle tickets if you are administrator and user trimmed if you are an ordinary user:
If(isAdmin,Sort(Filter(AllTickets,TaskStatus.Value <> "COMPLETED"),Created,Descending),Sort(Filter(AllTickets,Author.Email = MyProfile.UserPrincipalName || Author.Claims = MyProfile.UserPrincipalName ),Created,Descending))
I want to put a check box in top of the app when ticked only shows tickets from a specific category:
If I change the expression manually it works fine but how do I make it dynamic with the check box? My expression where I manually filter the category in question:
If(isAdmin,Sort(Filter(AllTickets,TaskStatus.Value <> "COMPLETED" && Category.Value = "Rengøring"),Created,Descending),Sort(Filter(AllTickets,Author.Email = MyProfile.UserPrincipalName || Author.Claims = MyProfile.UserPrincipalName ),Created,Descending))
My checkbox is labled "KunReng".
