Unanswered

Multiple search , nested filter

(0) Share

Report

Posted on by AmritaOS

Hi All, I for the life of me cant figure what am doing wrong. i want to have a multiple search like this

my gallery that i have linked to the search box and the two combo boxes is blank until i select something in both combo boxex. i want it to show everything and filter when i search and update the combo boxes and teh search bars individually or two or all three. what have i done wrong? i am fairly new to power apps.

thanks,

Amrita

Search(
Filter(
Filter(
'TEST REPAIRER LIST',
IsBlank(CbTypeFilter.Selected.Result) || Type1 = CbTypeFilter.Selected.Result
),
IsBlank(CbCountyFilter.Selected.Result.Value) || County.Value = CbCountyFilter.Selected.Result.Value

),
TextSearchBox1.Text,
"Title"
)

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey! Check this video, thelast screen. It is in Portugueses but you can try to understand..

The code is here:

If(IsBlank(DatePicker1_2.SelectedDate) && IsBlank(DatePicker1_3.SelectedDate) && IsBlank(BarraPesquisa.Text); Sort(Registo;'Decision Date';Descending); If(!IsBlank(DatePicker1_2.SelectedDate) && IsBlank(DatePicker1_3.SelectedDate) && IsBlank(BarraPesquisa.Text); Filter(Sort(Registo;'Decision Date';Descending);'Decision Date' >= DatePicker1_2.SelectedDate); If(!IsBlank(DatePicker1_2.SelectedDate) && !IsBlank(DatePicker1_3.SelectedDate) && IsBlank(BarraPesquisa.Text); Filter(Sort(Registo;'Decision Date';Descending);'Decision Date' >= DatePicker1_2.SelectedDate; 'Decision Date' <= DatePicker1_3.SelectedDate); If(!IsBlank(DatePicker1_2.SelectedDate) && !IsBlank(DatePicker1_3.SelectedDate) && !IsBlank(BarraPesquisa.Text); Filter(Sort(Registo;'Decision Date';Descending);'Decision Date' >= DatePicker1_2.SelectedDate; 'Decision Date' <= DatePicker1_3.SelectedDate; StartsWith(Nome;BarraPesquisa.Text)); If(IsBlank(DatePicker1_2.SelectedDate) && !IsBlank(DatePicker1_3.SelectedDate) && IsBlank(BarraPesquisa.Text); Filter(Sort(Registo;'Decision Date';Descending);'Decision Date' <= DatePicker1_3.SelectedDate); If(IsBlank(DatePicker1_2.SelectedDate) && !IsBlank(DatePicker1_3.SelectedDate) && !IsBlank(BarraPesquisa.Text); Filter(Sort(Registo;'Decision Date';Descending); 'Decision Date' <= DatePicker1_3.SelectedDate; StartsWith(Nome;BarraPesquisa.Text)); If(!IsBlank(DatePicker1_2.SelectedDate) && IsBlank(DatePicker1_3.SelectedDate) && !IsBlank(BarraPesquisa.Text); Filter(Sort(Registo;'Decision Date';Descending); 'Decision Date' >= DatePicker1_2.SelectedDate; StartsWith(Nome;BarraPesquisa.Text)); Filter(Sort(Registo;'Decision Date';Descending); StartsWith(Nome;BarraPesquisa.Text)) ) ) ) ) ) ) )

I am filtering between 2 dates and name.

You can check between 2 combobox and the text input

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!
v-chenzhi Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AmritaOS ,

Do you want Gallery to display items filter by combobox and search box and displays all items when the combo box is empty?

I have a test on my side, please try the following workaround.

I have three text column in SharePoint named 'Type','County','Title'.

Search( Filter( Filter( TEST, If( !IsBlank(ComboBox1.Selected.Result), County exactin ComboBox1.SelectedItems, County = County ) ), If( !IsBlank(ComboBox2.Selected.Result), Type exactin ComboBox2.SelectedItems, Type = Type ) ), TextSearchBox1.Text, "Title" )

It works fine, please try to modify your formula to the following:

Search( Filter( Filter( 'TEST REPAIRER LIST', If( !IsBlank(CbTypeFilter.Selected.Result), County exactin CbTypeFilter.SelectedItems, Type = Type ) ), If( !IsBlank(CbCountyFilter.Selected.Result), Type exactin CbCountyFilter.SelectedItems, County = County ) ), TextSearchBox1.Text, "Title" )

Best Regards,

Zhi Chen