cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nafiye
Regular Visitor

Pull date from Microsoft form and create event in calendar

Hi, 

 

I have created a form which I features a date field for the user to fill in. I need this date to be pulled from the form and entered into my calendar as an event. 

 

Can anyone help please?

 

Thanks!

10 REPLIES 10
ScottShearer
Super User
Super User

@Nafiye :

Have you tried using the Office 365 Outlook Create Event action?

Your Flow may look something like what you see below.  You can reference the data from Forms in Dynamic properties to fill in the start date/time, etc..

 

(image has been updated)

 

CreateEvent1.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Hi @ScottShearer - thanks for your reply. 

 

I have tried that but instead of pulling the date from the form it is creating an event for today. I can't find the option to select the date entered into the field on the form. 

 

Thanks 

Nafiye

@Nafiye :

 

My apologies - I posted too soon.....

I negelected to add a Get response detailas action.  Doing so allows you to reference data returned from Forms.

 

CreateEvent1.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Hi Scott, 

 

I have tried that but to no avail. I will have another stab at it this morning and keep you posted. 

 

Thanks, 

Nafiye

Nafiye
Regular Visitor

Hi, 

 

Apologies for the late reply - have been on annual leave. 

 

That seems to have worked so thank you. What I am trying to do now is add an approval before adding the item into the calendar but I am having some more trouble. 

 

Can you help? 

@Nafiye :

Below is an example of how you can incorporate an approval into your Flow.  Additional information on Approvals can be found here.

FormAppr1.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Anonymous
Not applicable

What if I have created a form which I features a date field for the user to fill in. I need this date to be pulled from the form and entered into the responder’s calendar as an event instead.

@Anonymous 

Unfortunately you won't be able to insert an event into anyone's calendar except your own unless they have given you permissions to do so.  For this to work, everyone who would submit a Form would need to grant you permissions to their calendar - not practical.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Anonymous
Not applicable

How come? It is just like filling out a form and submiiting his own schedule or appointment?

@Anonymous 

The reason is that every action in Flow runs AS the user who is used for the connection for that action.  So, if I create the Flow, my credentials will be used by default for the action.  Unless I have been granted permission by the user who submitted the Form to create entries in their calendar, the Flow will fail.  The only time the Flow would succeed is when I, as the Flow author, submit the Form myself and the entry is created in my calendar.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (4,029)