Introduction to Microsoft Forms - No more Survey Monkey

[@PowerThingsWithWes]

bruh, you did a video with stones? you deserve everything. Thanks for all of it, and thanks for making PowerApps easier than it should be.

[@ShanesCows]

Truth be told video was already done. I just hit publish while I was dieing 😁

[@b0rme]

A neat way of avoiding the need to set up Power Automate is to go to OneDrive, click new and then Microsoft Form. It creates an Excel file that populates responses automatically.

[@xxxHarakirixxx]

Same goes for SharePoint document libaries in modern experience. There you got also the option to create a Excel file with Forms integration. (Only shown when your user got a Forms licence)

[@ShanesCows]

Thanks for sharing

[@toanuk]

It is a great for a first lesson. Shane. Look forward for next lesson. You are great ideal tutorial. Good work. Thanks

[@ShanesCows]

Thanks 😊

[@dr.wardsonlinelessons]

Fantastic introduction to Forms. Thank you, Shane!

[@ShanesCows]

Glad you liked it!

[@RD-gp1mu]

Hi Shane, is there a way to create Forms using PowerShell? I've have thousands to create for each service a charity runs for things like daily notes of people they're caring about to equipment fault reports. They have been paper-based for several years; transitioning that data for now to Excel via MS Forms. This is until they get a care management system in place. So instead of going to manually create a bunch of Forms per service Team site, I want to be able to leverage PShell. Any ideas please ?

[@erictsang789]

Shane Is there any way in Forms, I can limit respondents , for example, Q1 - Order of cakes, limited the max respondents to take this as 10 persons, after that the choice of order will be closed Eric

[@ShanesCows]

Not that I know of. You would need to build a Power Apps app most likely

[@zaidkashour]

Now waiting for a complex connection with Power Apps. What I usually do, export results to SP online and view them in a Power App gallery.

[@ShanesCows]

Hopefully soon. Hope you are subscribed to get notified.

[@f.k.b.16]

I am trying to pull info from a MS Forms that has a long answer and email it using Power Automate but it is removing the line breaks when the user hits enter on the form. A few weeks ago I was successful doing this by using Initialize variable", hitting enter, and then creating a formula inside the email body. It was super easy and I am sure I saw how to do this on your channel but I can't find it anywhere and I forgot how to do it. If anyone know what I am talking about, can you send over the link to this video?

[@cvkealey]

In question 3 of the Power Apps quiz, I think you mean "Naboo", not "Nabu". But, seriously, a great video. I'm finding more uses for Forms in places where Power Apps would be overkill, but there are a few features I wish it had. In particular, being able to populate choices in a question dynamically (e.g.: from a list of events in SharePoint, show those occurring in the future) and accepting dynamic data (e.g.: through a query string parameter) would be huge. A couple of our departments are using Forms as the means for people to register for events, so right now they need to go into the form to remove events that are full or after they occur. One of those functions would prevent that need. We will probably replace those Forms with custom Apps at some point, but don't have the bandwidth to deal with that now.

[@ShanesCows]

Thanks for sharing and nerd fail. 😯🤓

[@malikaouenza945]

Nice video. I will like to send the form every week to a group of people. Can the form be pre populated with the previous week answers if they are the same. Thanks for your answer

[@ShanesCows]

Not in Microsoft Forma that I know of b

[@malikaouenza945]

@@ShanesCows Thanks. what about adding a calculated date function in the body of email to be sent to responders of as survey

[@fellowapeman]

How do you do data validation in the form? In your last example of creating a user account, how do you ensure the user inputs are valid for AAD to ingest? Another example is validating an email address.

[@ShanesCows]

You cannot. That is why I have the approval step to make sure nothing bad goes in.

[@HowToExcelBlog]

check out cognito forms instead. Also works with power automate.

[@andrewcondon2492]

Hi Shane, Can you add a customer signature option once the form is filled out?

[@ShanesCows]

Not with Forms. You would need Power Apps or a 3rd party type of solution for a signature best I know.

[@DestinyRowSH]

Awesome video!!!! So helpful. Thank you.

[@ShanesCows]

Happy to help 😀

[@galihmarzuki5920]

Hi Shane, I've question. Is it possible to add comments if the respondent rated 3 points on a scale of 5? Please add this features, this will help people be automatically encouraged to give context, instead of us having to add extra "anything you want to add" Looking forward for your kind feedback. Thanks and Regards Galih Marzuki

[@ShanesCows]

You could add a conditional rule to do so I thnk

[@wesleyvanderblom]

Hi Shane, good video. I am going to add the link to this video in our Teams channel for onboarding reasons! 😉

[@ShanesCows]

Awesome! Thanks

[@HPTeguh]

Hi, Shane. I'm trying to create a survey that can allow users to upload an image. But this survey should also be shared to anyone outside of my organization. Is there any workaround about this quite bizzare request?

[@ShanesCows]

I don’t think anonymous surveys allow files. 😑

[@BullsBadri]

Hi, have a query. In Google forms we have option to create predefined link. I checked ms forms don't have one. Is there any alternate way or options to generate predefined link ? as my project is QR code based n I'm looking to have a predefined link. Any help will be much appreciated. Thanks

[@ShanesCows]

I have never done that. Sorry

[@BullsBadri]

@@ShanesCows thanks, did some research in MS Forms Pro has a variable option.

[@pennyp5822]

Thanks a lot Shane. Awesome

[@ShanesCows]

Happy to help

[@karenrose7264]

Great tutorial Shane! How do I add a statement at the end of my survey without it being a question. Can I add something after they click Submit? or before?

[@ShanesCows]

You can’t that I know of. 😑

[@davidgruby1704]

Use power automate to reply to the sender and send as an attachment?

[@RD-gp1mu]

in Settings

[@jdany77]

Hello, Thanks for sharing. One question at the end, Can Forms make an average of the Survey? As example questions with value (1,2,3) in total 10 answers and forms give me the average of this (ex. 2.75)

[@ShanesCows]

Not that I know of. But flow could 😀

[@AMERICACOLCHOES]

Where is the link to the article comparing both Forms (Pro and no Pro)?

[@ShanesCows]

meganvwalker.com/forms-vs-forms-pro-what-is-the-difference/

[@TheLdiddy32]

Video stopped working for me as well. Can you repost, or provide a different link? Love your stuff Shane!

[@ShanesCows]

Kirk if it is still not working please email me so we can get to the bottom of it Shane at PowerApps911.com

[@The-Medlow]

Late to the party, but same here - watching on a mobile device and it halted with “Something went wrong”

[@tombongers6865]

Is it possible to add a summary for the form user before they send their answers?

[@ShanesCows]

I don’t think so.

[@BullsBadri]

Hi, what is the maximum response a form can handle.

[@ShanesCows]

I am not sure. Aorry

[@noorsyyed]

is there any next part of this series ?

[@ShanesCows]

There is another video here kzbin.info/www/bejne/ameVnWuAqq9srq8

[@noorsyyed]

Shane Young thanks 🙏

[@philipmarno4989]

3:00 video stops working.

[@ShanesCows]

Weird it is working for me and others. Sorry

[@SitiHajar-nf4qz]

Hi how do I embed first question of the form into outlook email?

[@ShanesCows]

In your Flow you would add an action and then use the dynamic content to do so.

[@ibrahimdkj]

Thanks, is it possible connect with a Sharepoint list?

[@ShanesCows]

Yes check the other comments they have ideas or my next video will be doing so with Flow

[@HowToExcelBlog]

Check out cognito forms. Free plan is wayyyy better than MS forms with features like data validation (user can only input an email address in an email field) and it works with Power Automate.

[@ShanesCows]

Interesting. Thanks for sharing

[@Prtrcn]

Anyone figure out how to add a comment box to a choice question using forms?

[@ShanesCows]

I haven't

[@TheDistractionStudio]

Thank you! Very useful

[@ShanesCows]

Glad to help. 😀

[@surfhippy]

I think this is blocked in Australia. I can’t view it.

[@Lethal83]

surfhippy I’m also in Australia and getting the something went wrong message but other videos are working?

[@ShanesCows]

Really weird. Did it get better?

[@Lethal83]

Shane Young I watched it today in full and worked fine. Must have been an Aussie thing.

[@dnoha1]

Microsoft Forms is quite fast and simple to setup comparing to powerapps. There is one option which I'm missing - give users option to reopen their inputs to review or edit responses. At least until I lock reposnse list (move to some other list like "responses_done"). Is there such option for MS Forms which I don't see? Maybe some kind of combination of PowerApps for list overview and forms for creating input/edit forms? I'm aware of kzbin.info/www/bejne/bYm7oGytn9N9rMU, but probably I'm looking for more elegant way for creating of CRUD app inside MS platform.

[@andrewadams8601]

According to Microsoft's FAQ about Forms, it is free to anyone with a number of O365 licenses and to anyone with a Microsoft personal account including Hotmail, Live, and Outlook.com. Link: support.office.com/en-us/article/Frequently-asked-questions-about-Microsoft-Forms-495c4242-6102-40a0-add8-df05ed6af61c

[@ShanesCows]

Thanks for the link 😍

[@matthewgoldring]

Te gusta Chewy? Siii

[@ShanesCows]

Gracias 😀

[@yobanamariscal2876]

No entiendo :,v

[@ShanesCows]

Lo siento

[@SS-cd1dl]

Video definitely stops working

[@ShanesCows]

I am watching it right now without issue. :( Where are you located? Are you in Australia also? Wondering if KZbin messed up the copy of it for that region. If you drag the slider to the 10 minute mark does it work?

[@SS-cd1dl]

Shane Young UK

[@SS-cd1dl]

Oops something went wrong displayed 0.00/0.00 so not able to move slider any distance. But what is bizarre is I did send slider forward before video got to 3.00 min point to 7min point and it played ok from that point onwards. I will slide past 3.00 min point , 10 second intervals and see how much of the video is not available.

[@SS-cd1dl]

Ok slide to 3mins 10 seconds and all is ok.

[@yobanamariscal2876]

NO ABLO INGLES WEY :,V

[@ShanesCows]

No hablo espanol

[@yobanamariscal2876]

@@ShanesCows ya pero poro por que me ablas en español :v

[@pensink100]

Yep, it could be an easy useful tool, but no repeating tables possible -> not useful tool.

[@ShanesCows]

It isn’t perfect that is for sure.

[@HowToExcelBlog]

check out cognito forms, they have repeating tables among other things all in the free plan.