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.
Any updates on this issue?
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.
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.
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... 😞
@AddDay(DATE, 1) //dd/MM/YYYY
Does this do what you want?
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.
The last massive update included a fix for this problem. It works now. Thanks. (at least in Korea)
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?
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+09before 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.