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 / Timezone Independent f...
Power Apps
Unanswered

Timezone Independent field in powerapps form

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I am having hard time to configure Date time field in the power apps form connected to SP list.  I need the field  to be timezone independent like if user submits 9/14/2020 12:00 am then it has to be updated same in SP List ( Note : We have users in CST, EST, IST and UTC timezone  and SP regional settings are set to CST).   I Used UTC / Local time settings in canvas app, Timezone Offset,  Date Add functions to add / Subtract hours but nothing seems to be working, please help

 

I am still very new to power apps hence not sure if I have to connect to any other Common Data services to get the desired results.

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

    Hi @Anonymous ,

    Have a look at the TimeZoneOffset function which returns the difference between the User's timezone and UTC. I believe this will do what you need.

     

    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.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I have already tried Timezone offset function. It doesn't give me desired result. 

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

    @Anonymous ,

    That is the only Power Apps function that will compensate for different User's timezone as related to the setting on the SharePoint Server when you have variable values across users.

    It is a mathematical exercise more than a programming/syntax issue. What does not work? 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    See the attached screenshot. Assuming user is currently in IST Timezone, the selected Date and time can be converted to desired value ( here 9/15 12am - both in selection and update)  but when I submit the form - this 12am will be converted to CST and Date & time shown in SP list is 9/14 1.30 PM.    I believe the time is getting converted from user timezone to UTC again in CDS.

     

    Hope i was clear on above explanation.

     

    Capture.PNG

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

    @Anonymous ,

    What is the timezone on the CDS?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I don't exactly know how to see CDS timezone. Did you mean timezone in the screenshot ?  

     

    Capture.PNG

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

    @Anonymous ,

    I am not a CDS user, but this has to be a timezone difference between the user and wherever the central data timezone is set.

    Have a look at this Microsoft guide.

     

    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.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks for your time. Yes, something going off with timezone settings. I have read this Microsoft Article earlier, I am still not very clear where to change the timezone settings apart from screenshot I shared above. I created this thread to understand the same, hope someone else will help identify where exactly I am going wrong.

  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi  @Anonymous ,

    Do you want to update the same time from powerapps to sharepoint list?
    The key point is that the time zone in powerapps and sharepoint list is different.

    Time zone in powerapps is local time zone and could not be changed.

    Time zone in sharepoint list is one setting that you need to set in site settings.

    So the most simple way is to change time zone in sharepoint list to your local time zone.

    You could check your time zone in powerapps like this:

    -TimeZoneOffset()/60

    9166.PNG

     

    In my example, my time zone is utc+8.

    In sharepoint , you could set time zone like this:
    site information->view all site settings->regional settings->timezone

    9167.PNG

     

    9168.PNG

     

    You just need to change this time zone to the time one in your powerapps.

    Then time zone in powerapps and sharepoint will be the same. You could directly use time in powerapps to update to sharepoint list, no need any transferring.

     

    If you want to use utc time to update to sharepoint list and display as utc time in sharepoint list too, you could set like this:
    1)in powerapps transfer time to utc time to update:

    DateAdd(Now(),TimeZoneOffset(),Minutes)

    // transfer now() to utc time

    2)in sharepoint list, change time zone to utc.

    3)display this time field in powerapps, use this formula to display:

    DateAdd(ThisItem.timefield,-TimeZoneOffset(ThisItem.timefield),Minutes)

    //transfer utc to local time zone

    Then in powerapps, you will always view local time zone. In sharepoint, you will always view utc time.

     

    About transferring time, please refer this:
    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff

     

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @v-yutliu-msft  Thanks for the explanation. I can't change the settings of SharePoint to different time Zone.  Because I am using the user submitted time to add to SP calendar. I assume, In case of full day events adding time to 12am - 12am would be hard. Also, it might create issues with other apps on the SharePoint site.

     

    Is there a way where we can set power apps timezone to UTC and then convert the time to CST before pasting to SharePoint ?   It would be ideal to have all timeZone in CST.

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 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard