Unanswered

drop down filters not working

(0) Share

Report

Posted on by davidgegorek

so i have a list that i want to filter by the drop down selection, this syntax works in 3 other lists but when applying it to work in this list for some reason when selecting the drop down menu choice, the filtering doesnt actually happen. it stays the same

please help its driving me crazy

SortByColumns(
Filter(
[@'Fix Database PPM'],
StartsWith(
Title,
FixDbsearchName.Text
) Or StartsWith(
'Area/Function',
FixDbsearchName.Text
)&& (Len(FixDbmachineDRP.Selected.Value) = 0 || Machine.Value = FixDbmachineDRP.Selected.Value)
),
"ID",
If(
SortDescending1,
Ascending,
Descending
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @davidgegorek ,

Firstly, do you have the Default of the Text Search box set to "" (empty string) - also may need some bracketing as below

SortByColumns( Filter( [@'Fix Database PPM'], ( StartsWith( Title, FixDbsearchName.Text ) || StartsWith( 'Area/Function', FixDbsearchName.Text ) ) && ( Len(FixDbmachineDRP.Selected.Value) = 0 || Machine.Value = FixDbmachineDRP.Selected.Value ) ), "ID", If( SortDescending1, Ascending, Descending ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
davidgegorek 61 on at

Like (0)

Report

yes the dropdowns default is set to ""

i noticed that if i type something into my search bar it will perform both the search bar filter and drop down filter ,
it will perform the search on its own but will not perform the drop down on its on

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

@davidgegorek ,

Did you change the bracketing I posted ? There is nothing wrong with the syntax assuming Machine is a Single Select column

Was this reply helpful? Yes No
davidgegorek 61 on at

Like (0)

Report

im sorry i missed that part. yes it worked thank you so much for your assistance

Was this reply helpful? Yes No