Date picker that when select a date, it filters the gallery items

(1) Share

Report

Posted on by Charlie Martharper

943 Season of Giving Solutions 2025

Hi!

So I have a list in SharePoint that is getting items with date in a column but in text column type, and want that in this type of screen, when a date is selected (on datepicker on the right) it filters the date in the gallery on the left. What should I add in the gallery so When a date is selected the gallery filters it?

Think that the date that is in the gallery in the left is a text column type, not date.

Categories:

Connector development

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

@Charlie Martharper,

If(

    IsBlank(DatePicker1.SelectedDate),

    YourSharePointList,

    Filter(

        YourSharePointList,

        Date_petició = Text(DatePicker1.SelectedDate, "mm/dd/yyyy")

    )

)

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Suggested answer

TechFreak 149 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

This happens because your SharePoint date column is stored as text, while the DatePicker returns a date value. Power Apps can’t directly compare text with date, so you need to convert one side.

Set the Items property of your gallery like this:

Filter( YourListName, Text( DateValue(YourTextDateColumn), "dd-mm-yyyy" ) = Text( DatePicker1.SelectedDate, "dd-mm-yyyy" ) )

Make sure the format (dd-mm-yyyy) matches how your text date is stored.

If your text date format is different (for example yyyy-mm-dd), adjust the format accordingly.

Better long-term approach:

Change the SharePoint column type from Text to Date

Then use a simpler filter:

Filter( YourListName, YourDateColumn = DatePicker1.SelectedDate )

This removes the need for conversions and improves performance.

Best regards,
Satyam Pandey

✅ If this helped solve your issue, please mark it as Accepted Solution so others can find it quickly.

❤️ If it was helpful, please click Yes on “Was this reply helpful?” or give it a Like

🏷️ For follow-ups, feel free to tag @TechFreak

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @Charlie Martharper

If no date is selected, it will show all records. Once you select a date, it will filter and show only the records that match that selected date.

Please try below code:

Filter( YourList, (IsBlank(DatePicker1.SelectedDate) || YourTextDateColumn = Text(DatePicker1.SelectedDate,"mm/dd/yyyy")) )

Note:

YourList - Replace with your SharePoint list name

DatePicker1 - Replace with your date picker control name

YourTextDateColumn - Replace with your date type text column name

If you are storing the date in "dd/mm/yyyy" format then use below formula:

Filter( YourList, (IsBlank(DatePicker1.SelectedDate) || YourTextDateColumn = Text(DatePicker1.SelectedDate,"dd/mm/yyyy")) )

If you want to show only selected date data then and date format is "mm/dd/yyyy".

Filter( YourList, YourTextDateColumn = Text(DatePicker1.SelectedDate,"mm/dd/yyyy") )

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Charlie Martharper,

Both approaches above work. Just one thing to be aware of: neither Filter formula is delegable to SharePoint because you're filtering on a text column with a converted value. Power Apps will only process the first 500 (or 2000) records locally, so if your list grows large you might miss results.
The long-term fix TechFreak mentioned is the right call: change the column type to Date in SharePoint. That makes the filter fully delegable and removes the text conversion entirely.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No