Answered

Create event in Outlook calendar based on Forms submission

(0) Share

Report

Posted on by Emil_Stenz

Hi there. I'm trying to use Power Automate to automatically create an event in a specific Outlook calendar when a certain form in Microsoft Forms is submitted.

The Form has the following fields, that respondents can fill out:

Date field: Where respondents can enter the date of the event (dd/MM/yyyy)
Name field: A text field, where respondents can enter the name of the event
Description field: A text field, where respondents can enter a description of the event
Start time field: A text field, where respondents can enter the start time of the event
End time field: A text field, where respondents can enter the end time of the event

I have no issues getting the the Create Event (V4) action to create the event from the submitted form, and it also provides a Subject line and Body corresponding to the name and description fields.

My problem is the Start time and End time fields in Create Event (V4): How do I get these fields to fetch information from both the Date Field and the Start/End time field in the form?

Using dynamic content, I can either:

fetch the data from the Start/End time field in the Form, causing the flow to generate the event at the right time of day but the wrong date (by default it is placed on the day of the Form submission)
fetch the data from the Date Field in the Form causing the flow to generate an event at the right date but the wrong time of day (by default the time is set to 00:00)

Adding both pieces of dynamic content causes the flow to fail.

Do anyone know of a way to fix this issue, so I can get my events to be generated at both the right date and time? I'm definitely a noob in Power Automate and can't write code to save my life, so I'm hoping someone might point me in the right direction 🙂

Thanks a lot in advance!

Categories:

Building flows

flow problemer .png

I have the same question (0)

All responses (6)

Answers (1)

David_MA 12,980 Super User 2025 Season 2 on at

Like (0)

Report

Just use expressions to generate the correct format of data for the start and end time as illustrated in the action from the values in your form. If you are getting all of data from your form, you shouldn't have any trouble combining it with an expression. For example:

And here is the end result:

The key is to make sure you format the start and end values exactly as shown in the examples in the fields ('2017-08-29T04:00:00). Note, the time values need to be in 24-hour format. If you want 4:00 p.m. for the start or end time, your form response needs to return 16:00.

Was this reply helpful? Yes No
Emil_Stenz 4 on at

Like (1)

Report

Thanks a lot for the reply 🙂

I don't have any issues with time formatting however. Inserting the Date field from my Form via dynamic content works just fine, as does the Start/End time fields. My problem has been getting both pieces of data in without the flow failing.

Just found the (annoyingly simple) solution however. Seems I just needed to add a T between the two pieces of dynamic content to separate them. Now it reads both things just fine.

Was this reply helpful? Yes No
Verified answer

mk7514 7 on at

Like (0)

Report

hello,
i had I think the same issue and I was able to make it work doing this steps :
1- initiate a variable where you store your start date from the form
2- use compose action (under data operations) : use addhours function in the expression

addHours(outputs('Obtenir_les_détails_de_la_réponse')?['body/r15ed436d54ae4bbaa78b3223e4295d13'],9)

it will change the format of the date into the right format for outlook event and add hours for start and finish time.

it this example : start date = 2023-09-13, i want my start date to start at 9am so I add 9hours using the function addHours
for the compose box :
entry : 2023-09-13T09:00:00.0000000
output : 2023-09-13T09:00:00.0000000

for the end date I do the same but I add 17h to finish the day at 5pm.

hope it will helps

Was this reply helpful? Yes No
tdq 4 on at

Like (0)

Report

Thanks for the explanation it's taken me weeks to get this far!! I'm a super novice here, please could you even detail exactly what I need to write in the expression please?

tdq_createevent_a...

Was this reply helpful? Yes No
David_MA 12,980 Super User 2025 Season 2 on at

Like (1)

Report

For the date from your form, you would use this expression: formatDateTime(utcNow(), 'yyyy-MM-dd'). Replade utcNow() with the dynamic dateTime from your form response. I am not sure what you'll use for the time portion, as the date field in MS Forms doesn't include the time if I remember. So I don't know how you are getting that. But you need to enter it in hh:mm format using the 24-hour clock. In other words 6 p.m. would be 18:00. Be sure to hard code the seconds as well, so 18:00:00 in my example.

Was this reply helpful? Yes No
tdq 4 on at

Like (0)

Report

Thank you for the method!

But you were right in saying Forms do not allow you to enter specific times, meaning outlook calendar has no hh:mm to input.

Also, it turned out that I didn't need to format the date of my form responses for it to work in outlook calendar

In the end, after much trial and error, doing the below worked. (Basically what mk7514 said):

My form responses: name - T D. start date - 6.3.25. end date -13.3.25

For Start time:

use expression:

addHours(outputs('Get_response_details')?['body/rc17ae6624b33463fbab541e01674338f'],0)

* the grey info came when I inserted dynamic start date from my form response

For End time:

use expression:

addHours(outputs('Get_response_details')?['body/r35328e408897424ca18643aed46f49e9'],23)

Result:

the highlighted is a bit odd to me - its says 13th 23:00 and also 13th 00:00, but i may have to leave it like this

Was this reply helpful? Yes No