Answered

Create full day event from Forms submission

(0) Share

Report

Posted on by RP5

I'm trying to create an all-day event on a outlook calendar based on a Forms submission.

The original template included timezone conversions- I tried converting from UTC to EST, based on another thread from here, but the flow kept failing the timezone conversion.

I then tried to by-pass time zone conversion from another thread (below are the expressions I copied into start and end date/times)

If I have to include a timezone I can- it's just not permanent to the output.

flow question.PNG

concat(formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd'),'T11:30:00')

concat(formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd'),'T12:00:00')

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Winlou 27 on at

Like (0)

Report
Copy link

Link copied!

Have you tried the built-in time conversions?

Also, do you have access to FindTime or Bookings?

Was this reply helpful? Yes No
Johalloran 37 on at

Like (0)

Report
Copy link

Link copied!

From looking over the flow you are working with the time zone should be irrelevant. You should be able to just set the time zone to where the meeting is happening. As it is an all day event the issue is not the time zone but the duration.
The start date should be the date field entered in your form. If this is not a multi-day event then the end date is something like this:
addDays(body('Get_response_details')?['r62d75bfa72874d22b644a7d1076ef2e9'],1)
That is pasting the date field into the addDays() function. If it is a multi-day event you want to paste the end date into the function. If you do not the event will end a day early on the calendar.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @RP5 ,

You could save the date from the form response in a Compose action then convert the date in the compose with expression, such as when save the start date in the Compose:

formatDateTime(outputs('Compose'),'yyyy-MM-ddT11:30:00')

And you could save the end date in the Compose 2 and then convert it.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Johalloran 37 on at

Like (0)

Report
Copy link

Link copied!

I just noticed something else. Reading your formulas you are only creating an event for the current day. It is not pulling any date and time information form the form. The end date is also identical to the start date which does not make much sense. If you are going to create an event based on a form the start and end date should not be based on utcNow().

Was this reply helpful? Yes No