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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Change hour coming fro...
Power Apps
Unanswered

Change hour coming from SharePoint

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hello, what I am trying to do is display a sharepoint list in a power apps gallery.

the issue is that the date column is sharepoint is not display correctly in the power app, for example in sharepoint I have "20/11/2019 7:30" and when I call it from power apps using ThisItem function,  I get "20/11/2019 10:30", it has 24 hour format and dd/mm/yyyy format. 

Any help or suggestions on how to aproach this would be great, thanks!

Categories:
Building Power Apps
  • Pstork1 Profile Picture
    Pstork1 69,661 Most Valuable Professional on at

    This is usually because of a shift from UTC time to the local timezone.  Make sure that both sides are formatting the date to show in the same timezone.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Thanks for the reply. where do I look to check that?

  • Pstork1 Profile Picture
    Pstork1 69,661 Most Valuable Professional on at

    If you print out the date and time in a label using the full UTC formatting is should convert everything to UTC.  Like this

    Text(DatePicker1.SelectedDate,DateTimeFormat.UTC,"en-US")

    Just replace DatePicker1.SelectedDate with whatever your date is.  That should show you whether the dates/Times are actually the same or not.  If they are then you can do some math using DateAdd() and TimeZoneOffset() to adjust as needed.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    In sharepoint is 16/08/2019 7:00  

    In power app, with ThisItem.Date I get 16/08/2019 9:00  

    now, with Text(ThisItem.'Date';DateTimeFormat.UTC;"en-US"), I get 2019-08-16-T14:00:00.000Z.

    I do not quite get how to change it

  • Pstork1 Profile Picture
    Pstork1 69,661 Most Valuable Professional on at

    The 'Z' at the end designates that the date time value is now being displayed in the UTC timezone, which is +/- 0.  Depending on where you are located you can use DateAdd() to add minutes to that to get a datetime value for your local timezone and display that.

    Where are you located?  If I can figure out your local timezone I can give you an example.  SharePoint tries to do this adjustment for you automatically, which is why I think you are getting a different result in PowerApps.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    I am located in colombia

  • Siriyala Profile Picture
    Siriyala 2 on at

    As you have 2 hours time difference, you can substract 2 hours using DateAdd().

    Try following formula

    DateAdd(This.'Date',-2,Hours)

  • Pstork1 Profile Picture
    Pstork1 69,661 Most Valuable Professional on at

    Columbia is GMT -5 hours.  So if your time in UTC is 2019-08-16-T14:00:00.000Z in UTC then it would be 2019-08-16-T9:00:00.000 (14-5) in local time, which is what is displayed in PowerApps.  Seattle is GMT -7 hours right now.  So since the default setting for SharePoint online Seattle time, SharePoint displays the time as 2019-08-16-T7:00:00.000 (14-7).  You can change the REgional Settings of the site collection to Columbia's Timezone at which point SharePoint will show the same time as PowerApps.  Here's an article on how to change the timezone settings for a site.

    https://sharepointmaven.com/sharepoint-time-zone/

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

    Hi @Anonymous ,

    Is the Time zone/Locale value of your SP Site set to same value as that in your local time zone (as your PC)?

     

    Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. According to the issue that you mentioned, I think this issue is related to time zone.

     

    On your side, please check if the Time zone/Locale value of your SP Site set to same value as that in your local time zone (as your PC). Please go to the "Site Settings" of your SP Site -> "Regional Settings", then configure Time Zone property and Region property as below:9.JPG

    Please consider take a try with above solution, then re-generate a new app based your SP List, then check if the issue is solved.

     

    Best regards,

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

News and Announcements

Welcome to the Power Platform Communities

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

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 381 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 340

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans