Answered

Datepicker to filter Gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, I have looked at the other posts regarding this same issue however I'm not able to use the solutions to resolve my issue. I am very new to Powerapps.

I have created a list in Sharepoint, and I used it to create a Powerapp. I have the gallery sorting my list correctly, however, I would like to add a Datepicker to filter only the list items that meet the selected date. I have a column in the Sharepoint list with a date.

I have read about Powerapps getting invalid results because of the shortdate issue and Sharepoint has the time with the date. I have seen several workarounds like setting the selected date specifically such as

"Filter('Right Start Attendees','RSO Date'<=Date(Year(DatePicker.SelectedDate),Month(DatePicker.SelectedDate),Day(DatePicker.SelectedDate)),'RSO Date'>=Date(Year(DatePicker.SelectedDate),Month(DatePicker.SelectedDate),Day(DatePicker.SelectedDate)))

And this one

(https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-gallery-using-datepicker/m-p/308046#M88579)

Filter('SharePoint List Name',Text(Date,ShortDate) = Text(DatePicker1.SelectedDate,ShortDate))

However, I'm not doing something correctly.

Currently, my Gallery Items object looks like this:

Sort('Right Start Attendees', Title,Ascending)

I'm not sure how to filter on the column in my SharePoint list name 'RSO Start Date' with the datepicker, I'm not sure what all other information I could include that would be helpful to include here.

Thanks in advance!

Dale

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

If not tried before could you try the below code ?
Let me know the outcome.
Sort( Filter('Right Start Attendees','RSO Start Date' = DatePicker.SelectedDate),Title,Ascending)

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello PG_Worxz10, thank you so much for helping! Unfortunately, that line did not produce the desired effect.
I will attach screen captures of the before and after results, however, the result was that the title was missing from the Gallery, and the date was not recognized.

Was this reply helpful? Yes No
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please try below code ?

SortByColumns( Filter('Right Start Attendees',Text('RSO Start Date',"dd/mm/yyyy") = Text(DatePicker.SelectedDate,"dd/mm/yyyy")),"Title",Ascending)

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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello PG_WorXz10,
Thank you for your patience on my reply. That worked! thank you so much! I'm studying the line to learn the syntax for future projects.

The only issue with it, there is a delegation warning on the Filter. I have read about this issue with Sharepoint lists and excel sheets, I suppose that is a different issue to tackle. Again, thank you so much for taking the time to help me, I will mark this as the accepted solution. You Rock!

Was this reply helpful? Yes No