Answered

Text search box doesnt work on filter if dropbox is on a particular value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have an app with the following code, however if the dropdown is on "ALL" the text searchbox doesn't filter the gallery. Yet it works if the dropdown is on the other options?

Could someone help me modify the following code, i cant work it out

SortByColumns(
 If(StatusDropdown.Selected.Value = "ALL", 
 'JSA',
 
 Filter(
 'JSA',
 Status = StatusDropdown.Selected.Value,
 StartsWith(
 JSAID,
 TextSearchBox1_1.Text
 )
 )
 ),
 "Created",
 If(
 SortDescending1,
 Descending,
 Ascending
 )
)

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try
SortByColumns(
If(StatusDropdown.Selected.Value <>"ALL",
Filter( JSA,Status = StatusDropdown.Selected.Value && StartsWith( JSAID, TextSearchBox1_1.Text )),
Filter( JSA, StartsWith( JSAID, TextSearchBox1_1.Text ))),
"Created", If( SortDescending1, Descending, Ascending ) )
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

That is because you didn't apply the filter function to table when dropdown is 'All'. Please modify the code as follows:

SortByColumns( If(StatusDropdown.Selected.Value = "ALL", Filter( 'JSA', StartsWith( JSAID, TextSearchBox1_1.Text ) ), Filter( 'JSA', Status = StatusDropdown.Selected.Value, StartsWith( JSAID, TextSearchBox1_1.Text ) ) ), "Created", If( SortDescending1, Descending, Ascending ) )

Hope this helps.

Sik