Filter and search with multiple conditions on gallery

(0) Share

Report

Posted on by ShineTan123

213

Hi,

I am trying to add one more condition on searching the gallery, but it doesn't work.

The part I added is StartsWith(ID,TextInput0.Text), there is no error with the formula, but when I tested it, it's not working.

Anyone can help with this?

Sort(Filter('WuXi OTC digitization',StartsWith(Title,TextInput1.Text) || StartsWith(ID,TextInput0.Text) && (IsBlank(ComboBox1.Selected.Result) || 'Cost Type'.Value = ComboBox1.Selected.Result.Value) && (IsBlank(ComboBox4.Selected.Result) || Status= ComboBox4.Selected.Result) && (IsBlank(ComboBox3.Selected.Result) || Market.Value = ComboBox3.Selected.Result)),Created,If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

eltibu on at

Like
a
(0)

Report
Copy link

Link copied!
Looks to me that your text filter isn't set up to handle no entry into your text box. I would suggest to change

StartsWith(ID,TextInput0.Text) && (IsBlank(ComboBox1.Selected.Result)

to

(StartsWith(ID,TextInput0.Text) Or IsBlank(TextInput0.Text)) && (IsBlank(ComboBox1.Selected.Result)

Also, from your screenshot looks like you have a delegation warning that you may want to tackle.

Also, is your ID column a number? In which case using a text input to supply a string should result in an error of trying to match string to number in which case you'll want to write
(Value(StartsWith(ID,TextInput0.Text)) Or IsBlank(TextInput0.Text)) && (IsBlank(ComboBox1.Selected.Result)
instead
ShineTan123 213 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @eltibu,
I tried both codes, but still not working. Any ideas?
Verified answer

WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ShineTan123 ,

That is because ID is a number - to keep this mostly Delegable, try this

With( { wData: Sort( Filter( 'WuXi OTC digitization', StartsWith( Title, TextInput1.Text ) && ( IsBlank(ComboBox1.Selected.Result) || 'Cost Type'.Value = ComboBox1.Selected.Result ) && ( IsBlank(ComboBox4.Selected.Result) || Status= ComboBox4.Selected.Result ) && ( IsBlank(ComboBox3.Selected.Result) || Market.Value = ComboBox3.Selected.Result ) ), Created, If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) ) }, Filter( AddColumns( wData, "IDTxt", Text(ID) ), StartsWith( IDTxt, TextInput0.Text ) ) )

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