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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ccc333ab 1,144 on at

Like (1)

Report
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).

Was this reply helpful? Yes No
ester 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No