I am currently adapting a Commissions App, and need to add additional filters to an existing Gallery (Gallery1), the code on the Items property of Gallery1 at present is as follows;
If(UserSTRANDVar = Blank(),
Filter('DLD Team Commissions', PID = UserPIDVar),
Filter('DLD Team Commissions', Strand.Value = UserSTRANDVar)
So, I have used variables to determine if the User is on a permission list in a SharePoint list (UserSTRANDvar), this looks up the SharePoint list, if the user is not on that list, then it only shows them items in Gallery1 which contain their Personal ID (PID).
I now need to add additional filters, so I have added another Gallery (Gallery2) and created a table within that Gallery (see below):
In the item property of this Gallery (Gallery2) I have the code, this contains each Business strand:
On the SharePoint list side I have a choice column for each Business Strand (IT, Team, Maintenance Team, Design Team, Accessibility Team).
So what I am trying to achieve is add additional filters to the code provided at the top of this post (in Gallery1), which allows me to filter by the checkboxes selected in Gallery2 but also show all if the 'All' checkbox is selected.