Unanswered

Vacation Request Calendar always leaves out the last day

(0) Share

Report

Posted on by Triplem

I created a Vacation Request flow base of the template. I use a MS FORMS questionnaire that the requester fills out and submits for approval. If the vacation request is for only one day the flow doesn't work and if the vacation request is for multiple days and gets approved, when the flow goes to make a calendar entry it's always short 1 day. I've heard some people say its a timezone issue and some say you just need to create an addDays expression but I can't seem to get either one working. If someone could assist me in figuring this out it would be greatly appreciated.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

Hi @Triplem

It's strange because if I read it correctly, the start date is correct, right? So if there are timezone problems, both dates would be wrong.

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members find the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Triplem Pls use two compose action and pass your start and end date . Then run your flow and see output of these compose.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
David- 1,254 on at

Like (0)

Report
Copy link

Link copied!

You may need to use a formatDateTime expression on your start and end time fields. I use the expression
formatDateTime(triggerOutputs()?['body/Start'],'yyyy-MM-ddTHH:mm:ss') for several flows that I add events to calendars and have not had any problems.

It also sounds like you want to create all-day events. If so, expand the advanced options and set "Is all day event?" to yes and see if that resolves your issue.

Was this reply helpful? Yes No
Triplem 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your suggestion. All day event is set to "Yes" but for the expression how do incorporate the Start and End dates generated by the form the users submit? Please remember I am not an expert by any means.

Thank you,

Was this reply helpful? Yes No
Triplem 4 on at

Like (0)

Report
Copy link

Link copied!

I don't think it's a timezone issue either. This is my last ditch effort to get this working, if I can't get it working soon I'm just going to change the form to ask the requester what day they will be returning from vacation instead of when does the vacation end.

It's lazy but it would work.

Was this reply helpful? Yes No