cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dvictor881
Level: Powered On

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
Highlighted
bean
Level 8

Re: Incorrect timezone - SharePoint list column

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
Level 8

Re: Incorrect timezone - SharePoint list column

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.

Dvictor881
Level: Powered On

Re: Incorrect timezone - SharePoint list column

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

Dvictor881
Level: Powered On

Re: Incorrect timezone - SharePoint list column

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
Level: Powered On

Re: Incorrect timezone - SharePoint list column

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

Highlighted
bean
Level 8

Re: Incorrect timezone - SharePoint list column

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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 382 members 6,065 guests
Please welcome our newest community members: