Answered

Creating Gallery with Date Filter and Text Filter

(0) Share

Report

Posted on by PabloSpurr

Hi there!

I have created a gallery which I can filter by text, but I also want to add a date filter. I'm new to PowerApps and any kind of coding really, so any help would be greatly appreciated.

I add the date picker, go to OnSelect and then I get confused about what to enter. I've tried putting this in there:

Filter(Gallery1.Selected.'DateofDrop-in'), but I get the red cross on the date picker.

Any help?

Thanks!

Paul.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PabloSpurr ,

If you want the records to match the selected date, you need this (assuming 'DateofDrop-in' is the field name in the list) on the Items of the gallery.

Filter( YourListName, Text('DateofDrop-in',ShortDate)= Text(YourDatePickerName.SelectedDate,ShortDate) )

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.

Was this reply helpful? Yes No
PabloSpurr 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Just tried that, I've got a 'x' over the date picker itself. Have I missed something?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@PabloSpurr ,

You have Filter(Gallery1.Selected) on the OnSelect of the DatePicker?

That is an Items property of a gallery or drop-down, not an action to be performed on a trigger. The code I gave you will work on the gallery and is nothing to do with the error.

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.

Was this reply helpful? Yes No