Unanswered

How to add my combo box selections to my filter

(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 conditions is that it then searches by the two search boxes and the selected office value as per below.

If('Select Office_(All)'.Selected.Value= "All Offices", Filter('CDR Tracker 1', StartsWith( 'Case Reference', searchCaseQuery ) && StartsWith(Requestor.DisplayName,searchRequestorQuery)), // First Part Filters via Case and requestor 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)) // If not all offices selected then this filters via the office select in addition to the Case Query and Requestor query.

I have a combo box whereby you can select multiple statuses (There are 7 Statuses in total), however every time I try to add it the filter I get errors, does anyone what I should be doing to ensure that I can include the selection criteria of the combo box within both conditions of this IF statement and Filter

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Cargue96 ,

Could you please tell me:

What is the data source? Is it a SharePoint list?

What is the statuses column's data type? Is it a choice column? Does it allow multiple selections?

I assume the statuses column is a choice column and do not allow multiple selections. Maybe you could try

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)
) ,
StatusColumn.Value=StatusCombobox.Selected.Value
)

Best Regards,

Bof
Cargue96 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

The Data Source is a Sharepoint list and the combo box is a choice column which allows multiple selections.

Many thanks!
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Cargue96 ,

Ok. Please try

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)
) ,
StatusCombobox.Selected.Value in StatusColumn.Value
)

Best Regards,

Bof
Cargue96 38 on at

Like
a
(0)

Report
Copy link

Link copied!

So, there are no errors in the formula, but this is what it's returning, the gallery now doesn't return anything at all as shown in the picture below.

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)), 'Select Office_(All)'.Selected.Value in Status.Value
)// If not all offices selected then this filters via the office select in addition to the Case Query and Requestor query
Cargue96 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you think of any reason why the gallery is returning nothing, from the formula you provided?