Unanswered

Combo Box filtering Gallery not working

(0) Share

Report

Posted on by Cargue96

Hi,

I have a filter whereby, it utilises an IF statement to check if a selected value "All Offices" is selected, it then filters by two search boxes, if "All Offices" is not selected the else condition is that it then searches by the two search boxes and the selected office value as per below.

I then have a filter whereby it checks the selection of the status in a combo box which allows multiple selection; the filter however only filters by one selection on the combo box. e.g I could select picked up & Complete, but the gallery will only show the one I selected most recently.

Filter(If('Select Office_(All)'.Selected.Value= "All Offices", Filter('CDR Tracker 1', StartsWith( 'Case Reference', searchCaseQuery ) && StartsWith(Requestor.DisplayName,searchRequestorQuery)),

Filter('CDR Tracker 1',StartsWith('Case Reference',searchCaseQuery) && StartsWith(Requestor.DisplayName,searchRequestorQuery) && Office.Value = 'Select Office_(All)'.Selected.Value)), 'Status Filter (All)' .Selected.Value in Status.Value
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Cargue96 ,

Can you please try the below:

Filter( 'CDR Tracker 1', StartsWith('Case Reference',searchCaseQuery), StartsWith(Requestor.DisplayName,searchRequestorQuery), 'Select Office_(All)'.Selected.Value= "All Offices" || Office.Value = 'Select Office_(All)'.Selected.Value )

What I have done is use formatting to make the code more readable and found that the two filters are almost identical. Then I replaced && operators with commas for more logical separation of the conditions and merged the differences between the two filters using a || operator. This will return true in case "All office" are selected, effectively ignoring the second part of the condition where it filters for selected office.

Was this reply helpful? Yes No
Cargue96 38 on at

Like
a
(0)

Report
Copy link

Link copied!

My deepest apologies, I have posted the wrong code on here and just realised.

So, this is the actual code, I need the gallery to filter by multiple selections in the status value, it only seems to return one selected value.

Filter(If('Select Office_(All)'.Selected.Value= "All Offices", Filter('CDR Tracker 1', StartsWith( 'Case Reference', searchCaseQuery ) && StartsWith(Requestor.DisplayName,searchRequestorQuery)), // First Part Filters and checks if All Offices is Selected
Filter('CDR Tracker 1',StartsWith('Case Reference',searchCaseQuery) && StartsWith(Requestor.DisplayName,searchRequestorQuery) && Office.Value = 'Select Office_(All)'.Selected.Value)),'Status Filter (All)' .Selected.Value in Status.Value
)

Was this reply helpful? Yes No