cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DB1
Frequent Visitor

Create Event - Time Zone / All day event

I made a SharePoint out of office calendar that employees can enter their requests for time off. An approval email is sent to their manager. The calendar allows for all day events or those with specific start and end times.

 

When someone enters an all day event, and you format it to just show the date (because the time is not important) the date time - convert time zone rounds an event end time to the next day! So the Sharepoint calendar shows it ending at 11:59 PM on day 1. The email formatted to just show the date rounds to day 2.

 

If you do show the time, it actaully changes both the start and end times. I've changed the input and output time zones and it still changes the times.

 

Has anyone else seen the time zone formatting not process an all day event from a calendar properly? 

Thanks

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

Hi @ DB1,

 

Could you please share a screenshot of the configuration of your flow?

Do you want to use the “Convert time zone” action to get the date of an all day event?

 

What has you filled in the “Destination time zone” field?

If you choose a time zone and the time zone would early or late than the UTC time “11:59 PM on day 1”, and the time would be converted to the Destination time “day 2”.If you choose a time zone the “(UTC) Coordinated Universal Time” in the “Source time zone” and “Destination time zone” field, the UTC time “11:59 PM on day 1” wouldn’t be converted to the Destination time “day 2”.

 

If you only want to get the date of the all day event,

I have made a test on my side, you could refer to screenshot below to create the flow to get the date of an all day event:

1.png

You could choose the “End Time” dynamic content of the trigger “When an item is created” in the “Base time” field of the “Convert time zone” action, choose the “Short date pattern – 6/15/2009 [d]” in the “Format string” field, choose the “(UTC) Coordinated Universal Time” in the “Source time zone” and “Destination time zone” field.

 

When an event is created in the calendar, the flow would run successfully as below:

 2.png

 3.png

 

 

Regards,
Alice Zhang

Here is the part that matters. Notice the all day event starts on April 27th at midnight. This particular time was selected because in the calendar it was set as an "all day event". The person doesn't put in a time.

 

The Body output says April 26th! 

 TimeFormat2.png

 

 

 

 

Now the approval:

TimeFormat2.png

 

Here is the email that arrives:

TimeFormat3.png

. del

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,876)