cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MartinLee
Level: Powered On

Filter Via Date Picker and then Drop Down

Good Afternoon/Morning

 

Im trying to filter via date picker and then filter via dropdown

 

the date picker is working great but the dropdown is not working?? this my code below? 

 

Filter('Rebooking Tracker', Region = Dropdown2.Selected.Value,  RB_Date=DatePicker1.SelectedDate)

i want to be able to selected a date and then filter this via the region? 

 

Hope someone can help

5 REPLIES 5
Community Support Team
Community Support Team

Re: Filter Via Date Picker and then Drop Down

Hi @MartinLee,

 

Could you please share about the errors you encountered when using this formula, and the meaning of "the date picker is working great but the dropdown is not working?"

Please make sure the Dropdown control is configured with the right value, make sure the value is mapped to the region.

68.PNG

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MartinLee
Level: Powered On

Re: Filter Via Date Picker and then Drop Down

Hi @v-micsh-msft

 

It there are no errors showing but only filters to central? when i click on the dropdown and select a different region stays with central??  

image.png

 

 

 

image.png

 

 

hpkeong
Level 10

Re: Filter Via Date Picker and then Drop Down

Hi

 

May I suggest to have

Filter(DS, Formula1 && Formula2)?

In fact, if Formula1, Formula2, by defaults it is AND,

bu just in case of bug.

Can you try?

 

TQ

hpkeong
MartinLee
Level: Powered On

Re: Filter Via Date Picker and then Drop Down

Hi @hpkeong

 

Thank you i have tried both 

 

Filter('Rebooking Tracker', RB_Date=DatePicker1.SelectedDate && Region=Dropdown1.Selected.Value)

This is the same above and below code 

 

Filter('Rebooking Tracker', RB_Date=DatePicker1.SelectedDate, And(Region=Dropdown1.Selected.Value))

this is displayed? 

 

image.png

hpkeong
Level 10

Re: Filter Via Date Picker and then Drop Down

Hi

 

The BLUE Exc. Dot showed that you have delegation limitation.

Maybe the data you wish to sort  has exceed 500 rows.

Please verify?

 

TQ

hpkeong

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (5,389)