Unanswered

Gallery filter not working properly ( 3 options to choose from)

(0) Share

Report

Posted on by esantos01

Hi Everyone,

My app has a gallery and I am trying to setup a filter, so users can select 2 options to filter from. Meaning that they can select a code from a dropdown and a range of date.

Option 1 dropdown

Option 2 Start date

Option 2 End date

I have the following code setup to do the filter:

If(Dropdown1.Selected.Value = "All", PAN2, Filter(PAN2, 'Pay Group' = Dropdown1.Selected.Value, 'Effective Date' >= DatePicker1.SelectedDate && 'Effective Date' <= DatePicker2.SelectedDate))

The issue is that when All is selected from the dropdown and the two DatePickers is selected it doesn't seem to be working. what I am missing here?

Thanks for your help,

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@esantos01 Are you getting any error or is it just not showing any data?

Was this reply helpful? Yes No
esantos01 17 on at

Like (0)

Report

@CNT No errors. It just does not filter the gallery.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
@esantos01 Try this,
Filter(PAN2, Switch(Dropdown1.Selected.Value, "All", true, "Pay Group", If('Effective Date' >= DatePicker1.SelectedDate && 'Effective Date' <= DatePicker2.SelectedDate, true, false) ) )

Was this reply helpful? Yes No
esantos01 17 on at

Like (0)

Report

thanks the reply. I didn't work.

Was this reply helpful? Yes No
Verified answer

rizkyaditya 292 on at

Like (1)

Report
Hello @esantos01 ,

You can also try this :
Filter(PAN2, Dropdown1.Selected.Value = "All" Or 'Pay Group' = Dropdown1.Selected.Value , 'Effective Date' >= DatePicker1.SelectedDate And 'Effective Date' <= DatePicker2.SelectedDate)

I hope this helps!

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@esantos01 What results are you getting?

Was this reply helpful? Yes No
esantos01 17 on at

Like (0)

Report

If the dropdown has all selected it does not filter by the datepicker only and if the dropdown has something other than all selected the gallery doesn't display anything.

Was this reply helpful? Yes No
esantos01 17 on at

Like (1)

Report

@CNT the code below worked like a charm. Thanks for your help!
Filter(PAN2,
Dropdown1.Selected.Value = "All" Or 'Pay Group' = Dropdown1.Selected.Value ,
'Effective Date' >= DatePicker1.SelectedDate And 'Effective Date' <= DatePicker2.SelectedDate)

Was this reply helpful? Yes No