cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MartinLee
Helper I
Helper I

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
v-micsh-msft
Community Support
Community Support

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.

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
Community Champion
Community Champion

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

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
Community Champion
Community Champion

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,539)