cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (2,676)