Time Zone Conversion Problem

(1) Share

Report

Posted on by JJ-10042320-0

Hello! I am fairly new to Power Automate, and am having trouble with converting time zones and using UTC format.

I have a Sharepoint list, and I want to create a flow that is triggered when new items are added to the list, and then generate an Outlook Event.

The major issue I am having is understanding my time zone conversions. The sharepoint list stores the date/time in UTC format.
So in this example I have entered an end date into sharepoint of '4/11/2025 01:00PM'. When I pull it into Power Automate it is showing as '2025-04-11T18:00:00Z'.

That is all well and good as 1:00PM CST is 6:00PM UTC time or 2025-04-11T18:00:00Z. However when I convert the time from UTC to Central Standard time it returns 2025-04-11 01:00:00 which is 1:00AM and not 1:00PM.

I have been bashing my head into this all day. My sharepoint regional settings are in CST. It is currently daylight savings time here, but I will figure that issue out later. For now I just want the conversion to bring back 2025-04-11 13:00:00.

What am I doing wrong?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

MichaelFP 1,943 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you show the action configuration of the conversion?

Was this reply helpful? Yes No
Suggested answer

DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!
Why are you converting the timestamp?

Leave everything in UTC and when you configure the Outlook action, select the correct timezone

and make sure you wrap the start and end dates from SharePoint in a ParseDateTime function e.g.

Start Date: parseDateTime(triggerOutputs()?['body/EventBegin']) End Date: parseDateTime(triggerOutputs()?['body/EventEnd'])

Was this reply helpful? Yes No
JJ-10042320-0 2 on at

Like (0)

Report
Copy link

Link copied!

I figured this out last night actually. Maybe somebody else will have the same problem and need this help though.

I was entering a custom time format of 'yyyy:MM:dd hh:mm:ss', but the lower case 'h' converts the time to the 12 hour format. So that is why I was giving me 01:00:00 instead of 13:00:000 after the conversion.

So I switched the time format to 'yyyy:MM:dd HH:mm:ss' and the data output remains in 24 hour format and I get the correct value.

Was this reply helpful? Yes No