Answered

Converting Time

(0) Share

Report

Posted on by Alex-W

327

I have a SharePoint classic calendar and a SharePoint list. When an item is modified on the classic calendar, Power Automate updates the date and time on the list. The problem I am having here is PA is receiving the date/time in UTC format and when PA sends it to the list, the date/time is being converted from UTC to local time. For example, event start date on the calendar is an all day event and the date/time is 3/1/2026 0:00. PA receives this date/time as '2026-03-01T00:00:00Z' and SharePoint converts it to 2/28/2026 18:00.

I tried to convert time zone from local time to UTC and it did not work.

convertTimeZone('2026-03-01T00:00:00Z', 'Central Standard Time', 'UTC')

Output: 2026-03-01T00:00:00.0000000Z

How do I convert the time PA receives from the calendar so that the time on the list is the same as the time on calendar?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Pstork1 69,129 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

SharePoint stores all Date/times as UTC, but converts it to display as the regional timezone setting for the SharePoint site. If you want the date and time to show as equivalent to UTC in SharePoint then you need to use the AddHours() function to subtract the number of hours between your SharePoint regional time and UTC.

Your convertTimeZone() function won't work because you are trying to convert an Explicit UTC DateTime but telling the function its Central Standard Time.

You should use

AddHours('2026-03-01T00:00:00Z', -6) to get a UTC time that will convert to midnight Central time.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Verified answer

Alex-W 327 on at

Like (0)

Report
Copy link

Link copied!
@Pstork1 AddHours would be fine if I lived in a region that did not have daylight savings time.

I figured out a way to make this work but I do not understand how it works.

I used a Convert time zone action with Central Time as the source and UTC as the Destination. Then I used the convert time zone function to convert the output of the convert time zone action from Central to UTC and this works.

convertTimeZone(body('Convert_time_zone'), 'Central Standard Time','UTC') Output: 2026-03-01T06:00:00.0000000Z

When SharePoint receives that output, it displays it as 03/01/2026 0;00

Was this reply helpful? Yes No
Alex-W 327 on at

Like (0)

Report
Copy link

Link copied!

I think I understand what's going on here.

The output of the Convert time zone action is '2026-03-01T00:00:00'. It drops the Z at the end of the string. The convert time zone function is then formating that time to Central so that it can be converted to UTC.

This may not be the book answer, but it works for me.

Was this reply helpful? Yes No
Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I don't think its actually dropping the Z exactly. I suspect what its doing is converting the ISO 8601 UTC time to a Time Zone Independent format. That's essentially the same thing. Then you are applying a Time zone by converting to Central.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No