cancel
Showing results for 
Search instead for 
Did you mean: 

Timezone Support for Sharepoint Date Column

If I output the date column from a sharepoint list with the value 5.4.2017(UTC+01), it actually outputs 4.4.2017. This is because flow currently only supports UTC+00.

A workaround is to change the timezone from the sharepoint list to UTC+00. But then the "Created" and other time Column are wrong.

 

Please add support for other Timezones, even if it has to be declared in the flow himself.

Status: Planned
Comments
Frequent Visitor

Any updates on this issue?

Power Apps
Status changed to: Planned
 
Regular Visitor

Until last week, datetime column timezone was set as the sharepoint site timezone and worked perfectly, but today whenever the flow is activated it changes to utc + 00. I didn't change anything. I wonder what's going on.

New Member

I am waiting for a call back from a Microsoft FLOW expert right now regarding this issue.  I need the time to show correctly in the approval email.  It is correct in my list and on the Outlook calendar where the FLOW creates the event.  Approval email shows 21:00:00Z instead of 5pm.

 

Kudo Kingpin

@Piagno 

I am also waiting for this feature to be fixed soon!

I am avoiding to apply a WDL-based workaround (i.e. addhours) since as @Muffin states, if this feature is temporarily fixed, then such workaround would cause problems... 😞

 

Advocate I
If(@Contains(DATE, "UTC+01"))

@AddDay(DATE, 1) //dd/MM/YYYY

Does this do what you want?

Frequent Visitor

Hi @ChrisCC

 

Where exactly do you put that code to make it work?  I have the same issue and need the dates/times to reflect in AU (+10) timezone.

 

Cheers

Regular Visitor

The last massive update included a fix for this problem. It works now. Thanks. (at least in Korea)

Frequent Visitor

Doesnt look like it is in Australia 😞   I even just found the Settings and Locale setting and updated that but no go.   My output is still 2017-08-31T14:00:00Z.

 

is there perhaps a way i can manually use the addHours acheive this?

Regular Visitor

@bstaples

The output still comes out with UTC + 00, but I'm assuming now it has the timezone info with it.

Which means when you use it as an input to another service, the timezone changes to the service's setting automatically.

Here's my case. I setted both my sharepoint and outlook timezone as UTC+09
before the update

sharepoint 9:00 -> flow 0:00 -> outlook 0:00

after the update

sharepoint 9:00 -> flow 0:00 -> outlook 9:00

 

It seems Flow itself including Approval doesn't support to show the time with local timezone yet though.