Forum Discussion
Sharepoint list vs powerapps datetime timezones
I have a sharepoint list with several datetime fields and I use a powerapps form to update them. I have a coworker that is in central timezone while I am in eastern timezone. The site is set to east...
BeachBenns I think by default Power apps shows the date values based on local/system time of current logged in user.
You may need to convert the date times in UTC or as per your site time zone settings using TimeZoneOffset() function while displaying the date values.
Documentation: DateAdd, DateDiff, and TimeZoneOffset functions in Power Apps
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Thanks for replying. I'm looking to show the time (on the list and the form) that was put into the form without doing any conversions when displaying them. For example, if I add a record using the form and set the field to 10/19/22 11:00 AM, the SharePoint list should show that date and time no matter what time zone a person is in looking at it. Then if that record is edited, that field should still show that date and time regardless of the time zone the person editing is in. Does that make sense?
- BeachBenns I know it's a year and half later ! but did you ever get a resolution to this?
