Unanswered

Create Event Time Zone Field

(0) Share

Report

Posted on by olenhumphries

Hello - I have a Power Automate flow that pulls data from a SharePoint list and creates Outlook Calendar holds. In my MS List, I have a Event Start, Event End, and Time Zone selection field. I am trying to have the "Create Event (V4)" and "Update Event (V4)" reflect the time zone selected from the MS List, however, it is adjusting back to UTC in Outlook. My list is set up in Eastern Time (US & Canada). Does anybody know a solve for this?

Screenshot 2023-11-03 at 9.59.44 AM.png

Screenshot 2023-11-03 at 9.59.21 AM.png

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

wskinnermctc 6,519 Moderator on at

Like (0)

Report

When you put in the StartTime and End Time what is the expression/output you have? Can you show the expressions and the output results?

Also in the Time Zone dropdown, remove your dynamic content. Select Eastern Time from the drop down, then use the Peek Code on the action.

Does your SharePoint column value have the exact same string "(UTC-05:00) Eastern Time (US & Canada)"? Or does the SharePoint column value say something like "Eastern Time (US & Canada)"?

Can you show what the options are for the timezone in sharepoint?

Was this reply helpful? Yes No
olenhumphries 10 on at

Like (0)

Report

Hi! Thanks for the help! Here is the start/end time expressions.

Start: formatDateTime(triggerOutputs()?['body/Event_x0020_Start'], 'yyyy-MM-ddTHH:mm:ssZ')
End: formatDateTime(triggerOutputs()?['body/Event_x0020_End'], 'yyyy-MM-ddTHH:mm:ssZ')

This is the output given when the flow is ran.

Yes, it it has the exact timezone format.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report

Thank you,

Remove the "Z" from the end of your time format.

"Z" always means UTC timezone. No matter what you do to a time, if you end it with "Z" then it will be read as UTC.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
And looking at your start and end times in the example, I'm guessing they are coming out of a SharePoint datetime type column?

You are going to have to convert them as well to match the timezone.

Start Time:

convertFromUtc(triggerOutputs()?['body/Event_x0020_Start'], 'Eastern Standard Time')

End Time:

convertFromUtc(triggerOutputs()?['body/Event_x0020_End'], 'Eastern Standard Time')

Don't worry about formatting them, the output will be in the correct format.

Was this reply helpful? Yes No
olenhumphries 10 on at

Like (0)

Report

Thanks for the help! I was able to update the time format to remove the Z!

I tested the flow and getting a different time on the Outlook Calendar than the input on the MS List.

MS List Time - 08:00 - 10:00AM Central Time
Outlook Hold - 1400 - 1600

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report

I don't understand what that photo is showing.

You have 7:00PM UTC time and then 3:00PM Central Time.

Was this reply helpful? Yes No
olenhumphries 10 on at

Like (0)

Report

Hi - WQskinnermctc! My apologies for the confusion.

When running the flow, the time inputted on the MS List is extremely different than the output proceeded once the flow has ran and is added to outlook.

Time selected in MS Flow

Output into Outlook

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report

The datetime that you see displayed in the SharePoint list is in your local timezone. This is controlled by the SharePoint settings.

However, all datetimes are stored as UTC "Z" timezone. So that is why if you pull and item out of the SharePoint list, the time will look different in Power Automate.

Here is a SharePoint list I made with 1 item showing with the date it was created. I created this item September 15, 2023 at 10:03 AM in my Central Standard Timezone. This is displayed to me as 09/15/2023 10:03 AM in the SharePoint list.

List View - Date Time view as local - 09/15/2023 10:03AM

If I pull the Created time into Power Automate then it will be in the UTC timezone. This is because the date was actually stored as UTC time. The sharepoint list display didn't change the time value, it only displayed it as if the time was in my local timezone.

A flow that gets the Created value is in UTC "Z" timezone 2023-09-15T15:03:37Z

Does that help explain what the time is different?

Was this reply helpful? Yes No