cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dvictor881
Helper I
Helper I

Incorrect timezone - SharePoint list column

I am displaying a date time column from SharePoint in powerapps and it is displaying wrong timezone. I am in UTC-5 and SharePoint is set to the same timezone but when I display time in Powerapps it is 3 hours ahead. 

 

To reproduce the issue: 

 

I have created two date time fields: Start Time and End time and I have selected both date and Time option. 

 

In PowerApps, I am using:

Concatenate(Text(Start_x0020_Time,DateTimeFormat.ShortTime), " - ",Text(End_x0020_Time,DateTimeFormat.ShortTime))

 

So for e.g. if the Start time and End time in SharePoint field is set to 10:30 AM and 11:00 AM, In powerapps it is showing 1:30 PM - 2:00 PM.

1 ACCEPTED SOLUTION

Accepted Solutions
bean
Continued Contributor
Continued Contributor

Hey guys, 

 

I had the same problem (Saving into Common Data Service). I THINK I have solved this problem.....Here is my code I use for my data card for storing a date.

 

Text(DateAdd(DateTimeValue(I_FinishDate.SelectedDate & " " & I_FinishTime),

DateDiff(Now(), DateAdd(Now(),TimeZoneOffset(), Minutes),Hours),Hours)

, "[$-en-US]yyyy-mm-ddTHH:mm:ssZ") 

 

Read over it, and see if it makes sense(I'm still a bit rough on it). It's working for me at the moment.I'd also appreciate any feedback!

 

Cheers,

Sean

View solution in original post

5 REPLIES 5
Leo09
Helper V
Helper V

Hi, please double check if your SharePoint site and powerapps are in the same timezone. As I cannot reproduce your issue. Mine always returns the right time.

Sorry, I am not able to find a way to validate PowerApps timezone. What's the way to check it ?

I am not able to find a way to see PowerApps Timezone settings. What would be the way to check/change PowerApps time zone ?

Metalitera
Frequent Visitor

I am having the same problem... Did you find a solution yet?

bean
Continued Contributor
Continued Contributor

Hey guys, 

 

I had the same problem (Saving into Common Data Service). I THINK I have solved this problem.....Here is my code I use for my data card for storing a date.

 

Text(DateAdd(DateTimeValue(I_FinishDate.SelectedDate & " " & I_FinishTime),

DateDiff(Now(), DateAdd(Now(),TimeZoneOffset(), Minutes),Hours),Hours)

, "[$-en-US]yyyy-mm-ddTHH:mm:ssZ") 

 

Read over it, and see if it makes sense(I'm still a bit rough on it). It's working for me at the moment.I'd also appreciate any feedback!

 

Cheers,

Sean

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (3,398)