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:

Mobile App

Sharepoint List.png

Date picker.png

PowerApp .png

All responses (4)

Answers (0)

WarrenBelz 146,618 Most Valuable Professional on at

Like (0)

Report
Date Picker

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
timl 34,935 Super User 2025 Season 1 on at

Like (0)

Report
Date Picker

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) )
AshanSilva 17 on at

Like (0)

Report

Date Picker

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.
WarrenBelz 146,618 Most Valuable Professional on at

Like (1)

Report
Date Picker

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