Answered

Outlook Calendar Flow is a Day Off

(0) Share

Report

Posted on by ester

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

Categories:

Building flows

All responses (2)

Answers (1)

Sort by

Verified answer

ccc333ab 1,144 on at

Like
a
(1)

Report
Copy link

Link copied!
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).
ester 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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