Filtering gallery with multiple filters

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

My app should allow users to filter the gallery 3 ways:

1. By Status from dropdown

2. Search input box

3. Sort gallery by priority

This is my current code:

If(StatusDropdown.Selected.Value = "All" && IsBlank(SearchBox.Text),
SortByColumns(DataSource, SortColumn,If(SortDecending,Ascending,Descending)), //SortColumn variable set on sort icon
Filter(Datasource, SearchBox.Text in Title || Status.Value = StatusDropdown.Selected.Value))

Problem: The problem I'm facing here is that it does everything except filter by other options from the status dropdown.

Any assistance is highly appreciated! Thank you

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

SortByColumns( If( StatusDropdown.Selected.Value = "All" && IsBlank(SearchBox.Text),Datasource, Filter( Datasource, Status.Value=StatusDropdown.Selected.Value || Title in TextInput1.Text ) ),If(SortDecending,Ascending,Descending) )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Drrickryp
I tried the code above and the gallery is empty. I added SortColumn variable to it, which shows the gallery but the search feature is not functioning.
SortByColumns( If( StatusDropdown.Selected.Value = "All" && IsBlank(SearchBox.Text),Datasource, Filter( Datasource, Status.Value=StatusDropdown.Selected.Value || Title in TextInput1.Text ) ), SORTCOLUMN, If(SortDecending,Ascending,Descending) )

Thank you for your help!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RezaDorrani

Can you please assist with this ?
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The reason for this problem is that when SearchBox.Text is empty, the null character is considered to exist in the Title column.
You should change your formula: Filter(Datasource, SearchBox.Text in Title || Status.Value = StatusDropdown.Selected.Value))
to: Filter(Datasource, SearchBox.Text in Title || Status.Value = StatusDropdown.Selected.Value&&!IsBlank(SearchBox.Text)))

Best Regards,
Levi
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That worked!

Thank you so much!