Using Forms to create an Outlook event at a specific time

[Anonymous]

I'm trying to use a form that will create a calendar event and invite people to join it, but I'm not seeing any great options in Forms. 

From forms, you can select a date, but can't select a time. Is there a way around this?

[v-xida-msft]

Hi @Anonymous,

Could you please share a screenshot of your flow's configuration?

Could you please show more details about the Forms that you mentioned? Is it the Microsoft Forms?

If the Forms that you mentioned is the Microsoft Forms, I think your thought is correct, we could only select a date from Microsoft Forms. If you want to select a time from Microsoft Forms, I afraid that there is no way to achieve your needs currently.

You could consider take a try to manually type a time and concatenate it with the date that you select from your Microsoft Forms. I assume that you want to create a an Outlook event at 04/28/2018 6:00 AM, I have made a test on my side and please take a try with the following workaround:

Within Inputs field of Compose action, type the following formula:

concat(body('Get_response_details')?['rc787195479ff44329dd91fb703b380a8'],'T06:00:00Z')

Note: The body('Get_response_details')?['rc787195479ff44329dd91fb703b380a8'] expression represents the answer to the Date question in my Microsoft Forms. You could consider select the concat() expression within the expression formula box firstly, then select the Dynamic content tab and simply click the answer of Date question dynamic content of the "Get response details" action. The '06:00:00' represents time part, you could custom it on your side, for example, you want to create an event at 4:35 PM, the time part would be 16:35:00.

Within Start time field of the "Create event (V2)" action, type the output of the "Compose" action.

The flow works successfully as below:

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

Best regards,

Kris

[Anonymous]

Yes, I'm using Microsoft Forms. I've found a way to force it into the right date/time format by using the date/time converter.

I've got it set up now to create a calendar event, but I'd like to make sure an email goes out an hour before the event starts. Can I delay the delivery of a notification or email?

[v-xida-msft]

Hi @Anonymous,

Do you want to delay the delivery of a notification or email within your flow?

If you want to delay the delivery of a notification or email within your flow, I think the "Delay" action could achieve your needs. I have made a test on my side and please take a try with the following workaround:

Within Delay action, Count set to 1 and Unit set to Hour.

More details about the Delay action, please check the following article:

https://docs.microsoft.com/en-us/flow/run-scheduled-tasks

Best regards,

kris

[Komaste_2]

I want to create an event at a specific time on a specific day and end at a specific time. There is an error coming up and i cannot get passed it.

@v-xida-msft 

@Anonymous

This is the flow 

 Flow

This is the error that i am getting

Error

[Huh]

@randalloglesby

Did you have any issues with what times the events displayed on the calendar? I placed a 'Convert Time Zone' action for the start time and another one for the end time. The flow runs, but when it creates the event on the SP, it shows it 8 hours earlier than what I put in the form. It does this for both the start time and the end time. I went into the flow and tried adjusting the time zones (just to see what happened) and it still showed the events 8 hours earlier than the times I entered. 

[migby]

Hi Kris,

Your solution helped, but I want to know if there is a way to create all events at one specified date. Meaning users don;t have an option to select a date with the calendar fucntion on Forms. I choose the date and all the events created are only on that specific date, but can be at separate times.

[AliDg2]

Hi, 

Sorry trying to follow the trail. I am wanting to do something similiar once someone responds they want to attend and event. i want to make sure that when the event is created and emailed to them it has the correct date. Can i hard code the date in the formula

concat(body('Get_response_details')?['Service Date:'], 'T18:30:00Z')