Power Platform Community Forum Thread Details

Happy Holidays everyone!

I'm a bit stumped on how to use 2 checkboxes as filters on a gallery connected to a sharepoint list. Each item of the list has a "complete" yes/no column. Each item also has a "Requester" column that is filled with the User().FullName function when the item is created in powerapps.

So the 2 checkboxes I have on screen are:

"Show only requests submitted by me."

and

"Hide completed requests."

The function I have written for this is in the items property of the gallery is:

Filter(MaintenanceRequests,
 RequestLocation = LocationDropDown.Selected.Value,
 If(MyRequestsCheckbox.Value = true, 
 User().FullName = Requester,
 If(CompletedRequestsCheckbox.Value = true,
 Complete = false, 
 RequestLocation = LocationDropDown.Selected.Value
 )))

So the issue here is that when you have the "MyRequestsCheckBox" set to true, it wont pass through to the "CompletedRequestsCheckBox" filter and will only filter out complete requests when "MyRequestsCheckBox" is false. I'm sure the solution is simple, but how can I have it apply both filters to the gallery items at the same time if they are both checked?

Thanks!

Categories:

Building Power Apps