web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Customized Power App f...
Power Apps
Unanswered

Customized Power App form Date and Time field without convert to any Time zone.

(0) ShareShare
ReportReport
Posted on by 56

I am working on customized power app form. In this form I have one Date and Time field. End user will set date and time and then it will stored in SharePoint list.

But getting issue because of Time Zone. If user select 4/30/2023 and time 2:00 while saving to SharePoint list its time is converting and it stored like 4/30/2023 5:24 AM .

SharePoint Regional setting set to Eastern Time Zone (US & Canada)

 

My requirement is it should not convert to any Time Zone. If I select 4/30/2023 2:00 it should stored  4/30/2023 2:00 in SharePoint also.

Personallearn_1-1682682071430.png

Personallearn_3-1682682127834.png

Personallearn_0-1682682020124.png

 

Please suggest something.

Categories:
  • WarrenBelz Profile Picture
    156,940 Most Valuable Professional on at

    Hi @Personallearn ,

    Dates in SharePoint are actually stored in UTC and converted by the Time Zone of the SharePoint site and the user's device. You can look at the TimeZoneOffset function, which returns the difference between the User's device and UTC. Either that or store it in Text and convert it back with DateValue(), but it is not something I would recommend.

     

    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.

    MVP (Business Applications)   Visit my blog Practical Power Apps

  • Personallearn Profile Picture
    56 on at

    Hi @WarrenBelz 

     

    Thanks for response.

    I know I am asking very weird question but I am new to power app 

    Let say we have date and time in EST in the SharePoint list and in power app it's local time 

    So how to write Timezoneoffset() function in this case and where to write.

    Thanks 

  • WarrenBelz Profile Picture
    156,940 Most Valuable Professional on at

    Hi @Personallearn ,

    Using apps and data sources across time zones is a challenge and at times there is not real answer for all users to see all records with the time from the zone it was written in. This document should assist you.

     

    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.

    MVP (Business Applications)   Visit my blog Practical Power Apps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard