Form Response to List/Calendar: How to add 1 day to the End Date?

(0) Share

Report

Posted on by klarson

Hi, I'm back with another question about the flow I'm working on to record responses from a MS Form to a list. The flow is working well now, except the dates on the calendar show up one day short. Here is an example:

This is what was loaded from the form:

But in calendar view, it shows up like this:

I'd like it to show up booked THROUGH 3/21.

Here are the details of the form and the flow:

Form:

Flow:

I was thinking maybe there was a way to use an expression in the End field? Or to declare a variable with the end date to add a day or make the end date the date plus the time of 23:00 before the create item step? But I'm not sure if that's right or how to go about it. I'm sure someone here can easily help me solve this one though. Looking forward to learning something new. Thanks!

All responses (2)

Answers (1)

klarson 61 on at

Like (0)

Report

Re: Form Response to List/Calendar: How to add 1 day to the End Date?

Thank you so much, this worked perfectly!! 🙂
Verified answer

v-yetonggu-msft on at

Like (2)

Report
Re: Form Response to List/Calendar: How to add 1 day to the End Date?

Hi @klarson ,

I did a test for your reference.

In my scenario:

Use this expression if you want to add a day to the 'End date'.

addDays(End,1,'yyyy-MM-dd')

Best Regards,

Sunshine Gu