Date Picker

(1) Share

Report

Posted on by AshanSilva

Hi Team,

Please help with the below if possible!

I have a Date picker which filters a SharePoint List gallery as seen in images attached.

But the Date picker only shows entries that has 00:00 in SharePoint list

How to make it show all the entries in SP list on the selected day of the date picker regardless of the time.

Any help is appreciated.

Kind regards,

Ash

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,299 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi AshanSilva

If you are filtering on a Date/Time field, you need to do this which is after 0:00 on the date selected and before 0:00 on the next day.
Filter( 'Signing in Register', 'Time In' > DatePicker2.SelectedDate && 'Time In' < DatePicker2.SelectedDate + 1 )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
AshanSilva 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,

This is what I need to do but entering your suggestion did not do anything. Not even an error. Please see image attached.

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Ash

The first part probably should use the >= operator to capture those records with a 00:00 timestamp.

I would try this to see if it makes a difference. I typically call the DateAdd function to explicitly state the time unit.

Filter( 'Signing in Register', 'Time In' >= DatePicker2.SelectedDate && 'Time In' < DateAdd(DatePicker2.SelectedDate, 1, TimeUnit.Days) )

Was this reply helpful? Yes No
WarrenBelz 156,299 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi AshanSilva

You can probably expand this with
With( { _Next: DateAdd( DatePicker2.SelectedDate, 1, TimeUnit.Days ) }, Filter( 'Signing in Register', 'Time In' >= DatePicker2.SelectedDate && 'Time In' < _Next ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No