Answered

Incorrect timezone - SharePoint list column

(0) Share

Report

Posted on by Dvictor881

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Leo09 212 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Dvictor881 34 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Dvictor881 34 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Metalitera 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

bean 568 on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No