cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
randalloglesby
Level: Powered On

Flow -> Create Calendar Event in Outlook, times don't match.

I'm using Flow to create a calendar event in Outlook. The event itself seems to have all the right information, but the time that it shows on the calendar view does not match.

mismatch times.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Flow -> Create Calendar Event in Outlook, times don't match.

Hi @randalloglesby,

 

Could you please share a screenshot of your flow's configuration?

 

I think this issue is related to the time zone. When working datetimes in Microsoft Flow, the datetimes would be converted into UTC (Coordinated Universal Time) format automatically.

 

In default, the time in event details panel shows up in UTC (Coordinated Universal Time) time zone format as below:3.JPG

But the time in the Calendar view shows up in your local time zone format.

 

If you want the time within the event details panel to show same time format with that in the Calendar view, please take a try with the following workaround:4.JPG

The Start time field set to following formula:

utcNow('yyyy-MM-ddT13:00:00Z')

The End time field set to following formula:

utcNow('yyyy-MM-ddT14:00:00Z')

The Time zone field set to your local time zone format.

 

 

Note: The utcNow(...) expression within Start time field returned as below:

2018-05-15T13:00:00Z

The utcNow(...) expression within End time field returned as below:

2018-05-15T14:00:00Z

 

The flow works successfully as below:5.JPG

 

6.JPG

 

7.JPG

 

 

 

Please check and see if the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/I-Found-A-Bug/staffhub-time-drifts-2-hours/m-p/113130/highlight/...

 

 

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

 

 

Best regards,

Kris

 

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Flow -> Create Calendar Event in Outlook, times don't match.

Hi @randalloglesby,

 

Could you please share a screenshot of your flow's configuration?

 

I think this issue is related to the time zone. When working datetimes in Microsoft Flow, the datetimes would be converted into UTC (Coordinated Universal Time) format automatically.

 

In default, the time in event details panel shows up in UTC (Coordinated Universal Time) time zone format as below:3.JPG

But the time in the Calendar view shows up in your local time zone format.

 

If you want the time within the event details panel to show same time format with that in the Calendar view, please take a try with the following workaround:4.JPG

The Start time field set to following formula:

utcNow('yyyy-MM-ddT13:00:00Z')

The End time field set to following formula:

utcNow('yyyy-MM-ddT14:00:00Z')

The Time zone field set to your local time zone format.

 

 

Note: The utcNow(...) expression within Start time field returned as below:

2018-05-15T13:00:00Z

The utcNow(...) expression within End time field returned as below:

2018-05-15T14:00:00Z

 

The flow works successfully as below:5.JPG

 

6.JPG

 

7.JPG

 

 

 

Please check and see if the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/I-Found-A-Bug/staffhub-time-drifts-2-hours/m-p/113130/highlight/...

 

 

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

 

 

Best regards,

Kris

 

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Re: Flow -> Create Calendar Event in Outlook, times don't match.

What would the expression be if you want to use it to select time that is entered? 

 

I added this into my flow but it only returns appointments with time of 13:00 - 14:00 - so if the time is variable how do you account for that @v-xida-msft

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,536)