cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Create all-day Exchange event (multiple days)

Hello,

 

I tried to get into flow today and created a workflow (based on the online training) to approve vacations. It basically works fine but when I tried to add an automated Exchange calendar event as last step I hit a wall. The resulting event is not created/displayed correctly in Exchange - a two-day event is displayed as one-day.

The list item, where the value is based on, is formatted as Day/Time but of course without time, because the applicant shouldn't fill it in or even see it.

 

Another board topic here is about the same issue but the solution (implementing a Jquery into the Sharepoint List) seems a bit odd to me (and to be honest not applicable with my current knowledge).

https://powerusers.microsoft.com/t5/Building-Flows/Creating-all-day-event-in-Sharepoint-from-approve...

 

Is there really no way (maybe with new Office 365 updates since that topic was created) that an Exchange all-day event can be created over multiple days?

 

My output currently:

Flow outputFlow outputResulting event (only 1 day)Resulting event (only 1 day)

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Create all-day Exchange event (multiple days)

Okay, of course a little while after I had almost given up, I found a solution 🙂

Through other posts I got a clearer picture about date operations and spaces in names of dynamic content in Flow. So, I tried to add a Compose action with an expression which adds 12 hours (to accomodate for any time zone hickups that could occur) to the end date of the vacation request.

addHours(triggerBody()?['Urlaub_x0020_bis'],12)

The date for a two-day event then is displayed correctly in Exchange.

I guess this has to do with some technical oddities in Outlook/Exchange - an all-day event that goes from Saturday until Sunday starts on the first day at 00:00 and ends on the third day at 00:00. So Flow simply creates the wrong date for the calendar entry.

 

Expression to add 12 hoursExpression to add 12 hoursUse output from compose in event creationUse output from compose in event creationResult in OutlookResult in Outlook

View solution in original post

1 REPLY 1
Highlighted
Anonymous
Not applicable

Re: Create all-day Exchange event (multiple days)

Okay, of course a little while after I had almost given up, I found a solution 🙂

Through other posts I got a clearer picture about date operations and spaces in names of dynamic content in Flow. So, I tried to add a Compose action with an expression which adds 12 hours (to accomodate for any time zone hickups that could occur) to the end date of the vacation request.

addHours(triggerBody()?['Urlaub_x0020_bis'],12)

The date for a two-day event then is displayed correctly in Exchange.

I guess this has to do with some technical oddities in Outlook/Exchange - an all-day event that goes from Saturday until Sunday starts on the first day at 00:00 and ends on the third day at 00:00. So Flow simply creates the wrong date for the calendar entry.

 

Expression to add 12 hoursExpression to add 12 hoursUse output from compose in event creationUse output from compose in event creationResult in OutlookResult in Outlook

View solution in original post

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (4,698)