Answered

Filter list by dropdown and search box

(0) Share

Report

Posted on by Jensen

I have a gallery that has a dropdown filter and a search box and I'd like to be able to use both. I can get one or the other working, depending on the formula.

Search box (default)

SortByColumns(Filter(Trials, StartsWith(Title, TextSearchBox1_1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Dropdown filter:

IF(Dropdown1.Selected.Value = "All Sites", Trials, Filter (Trials, Foundry.Value = Dropdown1.Selected.Value))

I'm having a hard time combining two formulas into one usable formula. I found some similar threads but couldn't apply them specifically to what I was going for.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

tchin-nin 779 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Jensen
You can try something like this to combined the 2 formulas :
SortByColumns(Filter(Trials, StartsWith(Title, TextSearchBox1_1.Text) && (Dropdown1.Selected.Value="All sites" || Foundry.Value = Dropdown1.Selected.Value) ), "Title", If(SortDescending1, Descending, Ascending))
If "All sitess" is selected, the second condition is true so no need to filter the Foundry.Value.
But if it's false, then the filter on foundry will operate.

Théo

Was this reply helpful? Yes No
Verified answer

KroonOfficeSol 587 on at

Like
a
(2)

Report
Copy link

Link copied!
@Jensen

@tchin-nin is right, you should do it as he said.

You could also do it like this (I find it easier to read):
SortByColumns( Filter(Trials, IsBlank(TextSearchBox1_1.Text) || StartsWith(Title, TextSearchBox1_1.Text), Dropdown1.Selected.Value="All sites" || Foundry.Value = Dropdown1.Selected.Value ) , "Title" , If(SortDescending1, Descending, Ascending) )
You could also drop the DropDown and change to a ComboBox. A combobox can be with no selection. The formula then becomes like:
SortByColumns( Filter(Trials, IsBlank(TextSearchBox1_1.Text) || StartsWith(Title, TextSearchBox1_1.Text), IsBlank(ComboBox.Selected.Value) || Foundry.Value = ComboBox.Selected.Value ) , "Title" , If(SortDescending1, Descending, Ascending) )
Hope this helps,

Paul

Was this reply helpful? Yes No
Jensen 32 on at

Like
a
(0)

Report
Copy link

Link copied!

These work great, thank you very much!

Was this reply helpful? Yes No
Jensen 32 on at

Like
a
(0)

Report
Copy link

Link copied!

@KroonOfficeSol

What would I need to add to get a second dropdown filter to work with this?

Was this reply helpful? Yes No
KroonOfficeSol 587 on at

Like
a
(1)

Report
Copy link

Link copied!
@Jensen

Just add a comma and an extra line like the other dropdown. This one
Dropdown2.Selected.Value="All sites" || SecondField.Value = Dropdown2.Selected.Value

You can add as many you like.

Paul

Was this reply helpful? Yes No