cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ester
New Member

Outlook Calendar Flow is a Day Off

I created a simple flow to allow users to request time off through MS Forms. If it is approved, it will automatically add the request to a calendar.

The Flow works fine, but the date on the calendar is off by one day.  For example, if vacations were approved from 7/5/2021 to 7/9/2021 (5 days), the calendar shows 7/5/2021 to 7/8/2021, not including the last day. But if I double-click the event or place the mouse on top of it, it says 7/5/2021 to 7/9/2021 (the correct dates). 

 

What can I do to make the calendar show the last day of vacation? 

 

calendar 1.JPG

I thought it may have to do something with the event ending at 12:00 AM. If that's the case, the dates come from MS Form and don't include the time. How can I set it up to end at 11:30 PM?

 

This is the setup I currently have: 

Event flow.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
ccc333ab
Solution Sage
Solution Sage

Yes, the reason is the 12:00AM time. What I would do is something like just add the time of 11:59PM to the date, or use something like the following expression (this adds a day to the END Date and then subtracts a minute from it). 

 

 

 

addtotime(adddays(triggerBody()['date_1'],1),-1, 'minute', 'yyyy-MM-dd h:mm tt')

 

 

You can just create a Compose with this as its expression (replacing the triggerbody()['date_1] with your [Last Day Off] dynamic content.  Then use the Compose Output in your Create Event action (Or just create the expression directly into your Create Event action itself). 

View solution in original post

2 REPLIES 2
ccc333ab
Solution Sage
Solution Sage

Yes, the reason is the 12:00AM time. What I would do is something like just add the time of 11:59PM to the date, or use something like the following expression (this adds a day to the END Date and then subtracts a minute from it). 

 

 

 

addtotime(adddays(triggerBody()['date_1'],1),-1, 'minute', 'yyyy-MM-dd h:mm tt')

 

 

You can just create a Compose with this as its expression (replacing the triggerbody()['date_1] with your [Last Day Off] dynamic content.  Then use the Compose Output in your Create Event action (Or just create the expression directly into your Create Event action itself). 

View solution in original post

Thank you very much! I opted for adding "11:59 PM," and it worked! 

 

calendar 2.JPG

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,652)