Skip to main content

Notifications

Community site session details

Community site session details

Session Id : /iUeNZsGtdk+fDgcbCPCym
Power Apps - Building Power Apps
Unanswered

Submitting time to SharePoint in CST, regardless of timezone of user

Like (0) ShareShare
ReportReport
Posted on 13 Jan 2022 17:35:43 by 278

Below is my current setup for DateTimeZone.

It is set to local.

User1 is CST

User2 is EST

User3 is Mountain

User4 is Pacific

 

So I will have people from each of the time zones using this tool.

When they submit the case, it will update SPO.

Right now, when each user submits their ticket, the time will reflect their individual time zone.

So I want to know, if this is possible, or if there is an easier way to do this.

I want the app to display local time zone to the end user.  So that is all working as it should.

What I would like to do, is when the user submits their ticket, the time that is posted will be CST to SPO.

Example.

User2 who is EST.  User2 pulls up the tool at 9:00am their local time.  They are submitting at ticket at this time.  It shows 9am to them, all is good.  They click submit, and it goes back to the first screen as it should.  The time that actually gets posted to SPO though, is 8am CST.

 

So, is there a way to local time zone, but when the App goes to submit the time to SPO, it converts the time to CST (without the user seeing it in the APP), and posts the time to SPO in CST.

 

Travis5150_0-1642095306022.png

 

 

  • Jeff_Thorpe Profile Picture
    6,085 Super User 2024 Season 1 on 13 Jan 2022 at 19:40:39
    Re: Submitting time to SharePoint in CST, regardless of timezone of user

    SharePoint stores Date/Time as UTC and when it displays the Date/Time in SharePoint it converts it to the time zone set in the users SharePoint Profile. If the user doesn't have a time zone set in their profile then it will use the default time zone of the site. 

     

    When Power Apps gets the Date/Time from SharePoint it is in UTC and then convert to the users local time based on the time zone of the user's device (pc or mobile device). When you save Date/Time to SharePoint from Power Apps it converts the Date/Time to UTC based on the time zone of the user's device.

     

    If the users have their time zone set the same on both their device and SharePoint then the Date/Time should display correctly for everyone. Most of time when there are time zone issue it is because a user doesn't have their time zones set correctly in SharePoint or on their device.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard
Loading started