Unanswered

Power Automation to Create a Calendar Invite When Form is Submitted. Start time 30 min before form start time.

(0) Share

Report

Posted on by Nyd

Hello,

I am new to forms and power automation, so hoping someone can help. I have a form that people fill out when they need food/coffee/tea set-up for one of their meetings. Some fields in the form are meeting date (calendar drops down and requestor picks a date) and start time and end time (drop down with choices in 30 min increments from 8:00am-5:00pm). Once the form is submitted, I want power automation to create an outlook calendar invite that will start 30 min before the meeting start time and will end at meeting start time. Hope that makes sense and your help is greatly appreciated.

I have the same question (0)

All responses (3)

Answers (0)

David_MA 12,515 Super User 2025 Season 2 on at

Like (0)

Report
Re: Power Automation to Create a Calendar Invite When Form is Submitted. Start time 30 min before form start time.

You can use the Create event (4) action to create the calendar event. Then just use an expression to subtract 30 minutes from the time in the Start time field. In the expression below, replaced utcNow() with your DateTime field.
addMinutes(utcNow(),-30)

Was this reply helpful? Yes No
Nyd 2 on at

Like (0)

Report

Re: Power Automation to Create a Calendar Invite When Form is Submitted. Start time 30 min before form start time.

Here are my fields, so I would put addminutes (Start of Meeting Time (), -30) and still keep the Date of meeting field?

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

Like (0)

Report
Re: Power Automation to Create a Calendar Invite When Form is Submitted. Start time 30 min before form start time.

Your date/time field must be in ISO8601 format to work. What you show would not be correct since you have two fields populated in the Start and End time fields. If you look at this action, it shows what is required for it to work:
In order to subtract 30 minutes from the initial start time in your form, you need to use the expression I posted earlier, substituting utcNow() with the field in your form (provided that is in the appropriate date format to begin with.
addMinutes(utcNow(),-30)
You may want to test it out by using the above expression in your start time and use the expression addMinutes(utcNow(),30) in the End time.

Was this reply helpful? Yes No