Answered

Filtering a gallery with Datepicker

(0) Share

Report

Posted on by GenioyFisura

Im really new to powerapps. I have a Gallery populated by a sharepoint list. This sharepoint list has a single line text column named Day and another column which is a Date and time column. I added a DatePicker control and on the OnChange property of it I need for it to filter the records on the sharepoint list so if the selected date in the DatePicker is for example a Monday it would show me only the records with Monday in the Day column. Is that even possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

madlad 2,637 Moderator on at

Like (1)

Report
Copy link

Link copied!
It is! Try changing the Items of your gallery to something like:
Filter( *YourSPList*, Text(DateTimePicker.SelectedDate, "dddd") = Day )

Hope this helps!

Was this reply helpful? Yes No
GenioyFisura 11 on at

Like (0)

Report
Copy link

Link copied!

Thanks! I added that code to the Items property code of the gallery but I think the problem is on the OnChange property of the Datepicker as it's still not filtering anything. Im using:
Filter(MySPList, Text(Day) = Text(Weekday(DatePicker1.Value), "[$-en-US]dddd")) Im completely lost here

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (1)

Report
Copy link

Link copied!

Add this to the Items/Datasource property of your gallery, not the OnChange of your DatePicker.

Filter isn't a function which inherently changes data - rather it returns a unique table based off of the data provided in it. As such, it won't change an existing collection/list by itself, it needs to be placed inside another function or property.

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!

Try this

Filter( MySPList, Text(Weekday(DateColumn), "[$-en-US]dddd") = Text(Weekday(DatePicker1.SelectedDate), "[$-en-US]dddd") )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
GenioyFisura 11 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your answer! It doesnt give me any errors (except for a delegation warning) but it is still not filtering, I mean I dont see any results in the gallery. Am I doing something wrong?

Was this reply helpful? Yes No
GenioyFisura 11 on at

Like (0)

Report
Copy link

Link copied!

Disregard my first response! It is working perfectly! Thank you so much!

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Check the data type of the "Day" column in your SharePoint list. It should be a single line of text column.
Check the format of the date value in the "Day" column. It should match the format used in the Text function in your formula.
Check the format of the date value in the DatePicker control. It should match the format used in the Text function in your formula.
Check the number of items in your SharePoint list. If it contains more than 500 items, the filter may not work correctly.
Try using a combination of the Filter and Search functions to filter the records in the SharePoint list based on a date range.

Was this reply helpful? Yes No