Filter sharepoint list using DateOnly field, should we pass the local date or UTC date

(0) Share

Report

Posted on by johnjohnPter

1,888 Season of Giving Solutions 2025

now i a have a dateonly inside sharepoint i enter it as 15/05/2026 and it got saved as 14/05/2026 21:00 inside sharepoint, as the local setting and sharepoint site setting is UTC+3.. then inside power apps i added a Date Picker , and i set this filter to the gallery:-

Filter(SPlist, DateOnlyField = DatePicker.SelectedDate)

where i selected 15/05/2026 inside the date picker and i got the above item, although in shrepoint it is stored as 14/05 and not 15/05... so where was the magic?

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,300 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@johnjohnPter

There is no actual "magic" - a lot depends on the time zone of the SharePoint site and the local user device. If they are the same, there is no issue.

What actually happens in the background is that the SharePoint database saves the actual UTC value of the date/time entered into the user's device. If the SharePoint site has a different Regional Setting, then viewing the data in a SharePoint View converts it to the Time Zone of the SharePoint site. Viewing it (or querying it) from Power Apps looks for the conversion to the time zone of the local device.

Date only fields are converted to time 0:00 on the same date, so if the SharePoint site is behind the local machine, this will be sometime on the previous day.

Example -

Local device UTC + 10 and SP Site UTC + 8

User saves a date 15/5/2026 0:00 in Power Apps

SP Database converts and stores to UTC 14/5/2026 14:00 (10 hours behind)

When displayed on SP Site View at + 8, converts to 14/5/2026 22:00 ( UTC + 8 - so you will see the day behind there)

When viewed in Power Apps at UTC + 10, comes back to 15/5/2026 0:00 (so you will see the correct day)

I have this exact issue with a customer I have in Western Australia (UTC + 8) as I am in Queensland (UTC + 10)

Please ✅ 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
johnjohnPter 1,888 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz thanks for the great helpful reply, but i am still confused, in my case the sharepoint site and local users' machine are the same UTC+3. so i am not sure how filtering the gallery using 15/05/2026 00:00 will get an item that is stored as 14/05/2026 21:00 ???

Was this reply helpful? Yes No
WarrenBelz 155,300 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@johnjohnPter,

How are you looking at the data in SharePoint - the "back end" data storage is absolutely correct for UTC + 3 - as the UTC time conversion for the date stored is minus 3 hours. If you are looking at it from a Flow, then yes, you will see the "raw" UTC time and need to do a Time Zone Conversation element to get it back to what you need, however a SharePoint View should show the conversion based on the Regional Settings of the SharePoint site (one of mine below) - as should Power Apps for the user's device settings (which it is)

So you might want to check this first.

Please ✅ 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No