Microsoft Power Automate Tutorial - Microsoft Forms Connector

[@shoaibahmedkhan9676]

Super amazing. Feel like crying. Hahaha.

[@JonJLevesque]

Haha crying?! Hopefully with tears of joy! Lol

[@shoaibahmedkhan9676]

@@JonJLevesque yes tears of joy

[@GabiBorbaWilson]

I felt the same 😂😂😂

[@GabiBorbaWilson]

@@JonJLevesque DEFINITELY

[@bawlsackinharry5855]

Probably one of the best sample intros I’ve seen yet. Thanks so much for putting this together.

[@JonJLevesque]

You are very welcome!

[@dharmeshchauhan3838]

Hey Jon ... this is fantastic. We've had flow available to us for some time but not much use until this video. I want to thank you so much as we have a feedback form just sitting there and then have done nothing to it. In one video you have changed everything and we now have multiple forms that are now visible to the business through Power BI. You've turned me into a superhero. Thank you so much.

[@JonJLevesque]

Woohoo! You are so welcome!!

[@raquelnavarro879]

You are an awesome teacher - straight to the point but super CLEAR on HOW TO - thank you soooo much - my flow worked :) (did a time off request approval flow)

[@JonJLevesque]

Wooot! Thank you for letting me know! I love hearing that people made flows successfully from watching me! What’s your next one now?!

[@catsalive9572]

Jon. You are awesome! I came here for a different question but got 2 amazing answers to things I didn't know where possible and I didn't know I needed but I totally do. I'll be trying this!

[@JonJLevesque]

Yesssss! So excited to hear it!

[@markmoscosa2371]

Awesome video Jon, definitely worth it. Was looking at it on the phone, and came to the lap, connected and made this Flow. Thanks dude, legit!

[@JonJLevesque]

Yesssss! So stoked you made it work! :)

[@salvn]

I watched your video and took action! Awesome tutorial! Thanks a bunch Jon Levesque, Levesque

[@jefflee5113]

Jon, this rocks. I haven't tried it but I think I am able to get this done. Well done and let's hope our IT department lets Flow work like this.

[@EihabFitness]

Mate did you just make an MS tutorial video look cool?! well done to you

[@officesuperhero9611]

Hi Jon, I am late to the party, but I created a flow based on your video for a large school district. Your video explanation is amazing! Thank you!!

[@JonJLevesque]

Richard, yes!! That’s amazing! Thank you for letting me know

[@GabiBorbaWilson]

OMG simply loved it. Will watch all of your videos for sure. Thank you so much for sharing it with us. Good bless you

[@MarciusMGSouza]

I liked your simple and clear way to teach...keep doing like that. Marcius from a city called Goiania, Brazil. Search on the Maps!!!

[@JonJLevesque]

+Marcius M G Souza thanks so much my friend!

[@roccoc1690]

Thanks Jon. I've been using your flow (oh umm.... Power Automate) videos for a bit and seen you at Ignite. Thanks for continuing to be a great resource to us all.

[@JonJLevesque]

Rocco! My pleasure pal. Thanks for taking a second to leave such a nice comment :)

[@olsenia3731]

Im new to MS flow and I find your content, so easy to follow. Thank you.

[@aT0000my]

I'm enjoying your videos! I did the form one. My next challenge is to build a Flow that interacts with a Sharepoint List (gets items), then sends a scheduled email followed by updating a dashboard. Wish me luck.

[@JonJLevesque]

Thanks!! and Good luck Allan!

[@LTDAN-B4]

For some reason I don’t get the apply to each in the get response details. Do you know what would cause this?

[@rkchamberlin5]

This happened to me when I tried my first form

[@susanaquadros9732]

@@rkchamberlin5 Me too.. any solution to this?

[@saraht7646]

I also had this problem, using Power Automate. However, my form seems to work without the "apply to each" item. I am only sending an email response to each submission and have not trialled this with any other processes, but the email response is working.

[@johnharville8007]

Great info thanks very much. If you haven't already, you should consider getting a better microphone as the sound is rather poor. Oddly enough, at 10:59, the sound improves, so not sure what was going on there.

[@kirstenjury5551]

This is fantastic. Loving the simple explanation of what is needed and made whole process easy to understand. Now i need to transfer the knowledge to connecting to CRM Dynamics 365

[@mickqwerty1967]

Hi Jon Great Video and so informative, I've subscribed. Wondered if it's possible to use flow to create an email with the results of a Form embedded in that email rather than having to view results in forms itself. Thanks.

[@JonJLevesque]

Mick that is very possible! You’ll add the first two forms steps then add the action “send an email v2” and voila! Customize to your hearts content!

[@mickqwerty1967]

@@JonJLevesque so Trigger and action and then another action as email? What's v2?

[@cheriemenke9454]

Awesome video! Thank you so much for all the detail and step-by-step!!

[@fklatecki]

Just reviewed your video, in my way back time machine...genius. FYI, as a Canadian, I have no issues with your surname. One of the main streets when I drive through Montreal, QC.

[@nukd30]

Thanks Mate, what a way to create the tutorial from a learner's perspective for a better understanding :-)

[@JonJLevesque]

You’re very welcome! :)

[@Dwik02]

Super tutorial. Just seen your great channel and not yet see through all video. Right now, I only have basic subscription of MS account on my desk. To run Power automate like this or at least for someone who have worked as self-employed with some clients, what type of MA account should I have so I can work like you did? Thanks Jon

[@ramsgehlot]

Super video.. love the way you defined. i have a question. 1. How do i get the summary of responses submitted through email or as a pdf attachment on submission 2. How do i get email alert if rating goes below 3 out of 10 (so and so person submitted down rating) Thanks in advance

[@matthewsyoung3832]

Just what I need. I'm looking forward to unlocking the secrets!

[@eugeneagyarko-kotoko1533]

Hi Jon..... I just watched your tutorial is a very good material, I really love it. please, I want to know more about Microsoft flow.

[@haueproduction]

Thank you the well explained content, I have a question though, is it possible to pre-fill the form using previous data entry by a user ? If so please can you create a video for it . Thank you !!!

[@JonJLevesque]

It is not possible :(

[@haueproduction]

True, I've done several research on this and seen that Microsoft forms has not included this functionality yet. But thanks though, really appreciate the good work you're doing

[@haueproduction]

True, I've done several research on this and seen that Microsoft forms has not included this functionality yet. But thanks though, really appreciate the good work you're doing

[@belindachappell9875]

Great video, so well explained. Thank you! Is there a way you can collect response results and send in batches?

[@cahleslewis2927]

Awesome video! I'm trying to use the same method but instead of Power bi, I'm using excel with tables. How do i put an condition on a response answer so that if the answer doesn't meet the condition it won't run or add to any tables. a simple example of this is on forms user picks "Site A" or "Site B" if they pick "Site A" that flow will run but not the flow for "Site B"

[@eduardoldasilva]

Great Jon!!!! But can I use all data (or partial ones) to calculate them and give an answer to the user? And, I'd like to register all together, data and results. What do you think? ;-) Cheers from Brazil.

[@andreaschunzel4672]

This was a really good explanation, thanks a lot!

[@JonJLevesque]

You are very welcome! Thanks for watching! :)

[@hamjad4277]

Thank you - this worked very well and my Form - flow with Power BI was a success. I am creating a small ticketing form and the issue I have is that I need to send an email to IT help desk with all the Form field data? - This was great

[@arxaelha8187]

I've created a form flow to capture policy acknowledgements by populating a SharePoint List but is there a way to dynamically populate information about the form itself? Specifically I would like the list item to include the name of the form through dynamic selection rather than a static entry in the flow.

[@arjunmurali3058]

Hey. Had a quick question. If we use a branching form and a field is left blank, the FLOW fails. What is to be done in such a scenario ?

[@mwaltercpa]

Hi Jon, great information. Can you tell me what the options are to blend this power automate data with an existing on prem dataset I work with in power Bi? I.e. we want to count customer visits by sales rep by month, then show that results along with applicable sales totals..

[@xarain]

Hey Jon, thanks for sharing. I was thinking of setting up a flow with ms forms-quiz such that when a person gets full marks for the quiz he gets an email sayings congrats else it would be "try harder next time" However the tricky part is the "points" option does not seem to be available for selection within flow which is a stumbling block. any alternatives? Thanks!

[@JonJLevesque]

+Sean you would need to create an answer key somewhere, Move the quiz answers there, compare and then calculate, then respond. This isn’t an easy thing unfortunately - but it is possible

[@xarain]

@@JonJLevesque Yeah understood. If only Forms has exposed the "Points" field (since Respondent Time, Name, Email are available) that surely make this MS Forms-Quiz very very useful. Would you know if perhaps Forms Pro would have this? Tia

[@niitajay6]

Hey John, Excellent Video for learning just wanted to know what about POWER BI Data you have not show how data is reflecting in Power BI.

[@meicyu]

Great great great training video! Awesome job done Jon!

[@mutualtrustit3918]

Hi Jon - thank you for your video. Its really good and clear what are you doing and why. I am trying to set up Flow for meeting room booking. I would like to set up Flow which will do following: 1. Organiser send meeting request to the meeting room. Skype for Business meeting for instance. 2. Meeting is tentative at this stage; 3. Specific people in our organisation approve this request; 4. As part of approval from specific people email was sent back to organiser to fill up the form about catering requirement, for instance; 5. Organiser reply's back with specific catering (if any) requirement. Is that even possible with Power Automated / Flow?

[@mutualtrustit3918]

Sorry - name is Boyan :-)

[@abhinavjee]

Jon, this is a great tutorial fro a beginner like me. I think you mentioned about looking at some run-time visualisations in powerbi after completing the flows and forms. Would you be able to demo that as well?

[@JonJLevesque]

Yeah, i could make one of those in a future video for sure!

[@abhijeetchavan1338]

Can we convert SharePoint List data into XML using Flow?

[@pankajsingh-ou9wr]

Can you please make the video for Check- In project and publish if the projects are checked-out using power automation ?

[@gozza40]

Great clip Jon! can;t wait to visualize this in Power BI

[@matthewshuff5922]

Thank you very helpful. Does anyone know how to keep a flow running? Mine stops running after the form is filled out everytime.

[@alexmcleod3614]

Super Cool Jon! Really enjoy your vids :) Sharing with students :)

[@selenec3744]

Jon thanks you so much! I tried on my own and work it out on my first flow

[@dusansavkovic9745]

Jon awesome presentation. I have a question, is there a plan to add more Forms triggers and actions into Flow? Thank you

[@JonJLevesque]

Hey Dusan, what actions and triggers would you suggest? You can also add ideas to aka.ms/flowideas

[@dusansavkovic9745]

@@JonJLevesque I have one idea currently, "once the form is submitted, start a new specific form". Ill put in the forum also. Another question, maybe this is for other Forms team, is there plans to add more functionality to forms? Functions like "if this then that"? Thank you

[@maxwendorff8826]

Is there a way to auto populate the fields for a calendar event using the data from the form?

[@Teach_Serve]

Thank you so much for this video! I was able to create my first Flow from a Microsoft Form conference registration to automated email thanking attendees for registering, providing the details of the conference, and asking them to email if they have to cancel. One thing is the email went to my junk email. Any way to avoid that? Next...I am going to try to have a flow from a specific question on the form (do they want to pre-order a t-shirt) to an email that provides them the payment information. Thanks again!! So helpful!

[@JonJLevesque]

You’re so welcome! Woo hoo so excited for you :)

[@Teach_Serve]

@@JonJLevesque I was trying to take it a step further...but can't get it to work. See below comments. :)

[@zaidumer1]

Hi i wanna cross chexk a sharepoint list where i need to match the user’s department (from profile) and matxh it with the department’s manager from the sharepoint list , and use his email in the email connector to send the approval email. Which sharepoint connector do i use get items or item ? Also how do i cross check and select from the list , which condition do i use

[@juancarlosvelazquez6434]

Great video, very well explained! Thank you

[@DemekeDeboch]

Awesome ! I loved it. You explained in great flow! Keep up it.Cool

[@brajendrakumar7269]

Beautifully explained concept of flow in Microsoft. Can we able to connect data of two Microsoft forms with the help of flow..? I yes please make a video of same...

[@guneetkaur8085]

How to get data from multiple MS forms and create one live stream for a power BI dashboard? Can we use SharePoint alongwith flow to create the live data stream and then connect it to Power BI?

[@timhoover9723]

Thank You so much! I have been trying to figure this out for about a month how to get form data to flow into powerBI and to a dashboard in an automated fashion! I created a survey for one of my workflows that has been manual in the past, and this will definitely put us on the path to streamlining! Could you also show how to create the data visualization in Power BI with the collected information in another video? maybe I will check out that bonus link you shared in your email to see if you already shared that :) Thanks Again for showing us how to use this powerful tool!

[@dimitridelizee3555]

great video. I have a question. I see a lot of videos where "surveys" are used as an example. I created a quiz, it works well but I can't get the same result when I export it with the option in the Form response tab of my quiz (open with Excel) and my flux. I have my answers but I don't have the right answer like the file. Can you help me. I can send you a screen or a link to show you. Thank you in advance.

[@aikidoshi007]

Hi Jon, that was a great intro, I knew nothing, now I know lots. I have a website that collects client data input by staff, and the business wants to send a partially filled Form to a client to fill all the remaining details, which I would store in the appropriate SQL Server record. Is this the best technology for that purpose (i.e., not a survey as such)? How would a 'Send' button on my website connect to Forms and actually send the form please?

[@MrFelipe899]

Excellent Jon! Thanks for sharing it!

[@myusrn]

Can you enable a trigger for case where user goes back into their form submission and makes an edit?

[@robertmerritt5245]

This is awesome as usual, but what happened to the PowerBI portion of the demo?

[@JonJLevesque]

Hmm.. i guess i skipped over that huh?! Sorry!

[@Bruce56555]

Great video. Could you show us how to display responses in the email.

[@ibrahime3194]

Hey Jon. I have layered audits set up for my organization and people are grouped up in teams. I used forms but I'm trying to build a flow to send out automatic responses to the individuals team to where they can view the responses for that form that was submitted? Please help.

[@JonJLevesque]

I’m not sure what your question is?

[@ibrahime3194]

@@JonJLevesque ok so, I have a form created. There are 20 teams that fill out the form but only one person from each team completes the form. I'd like to set up a flow to where when a team member submits their form, an automatic response in an email "view responses" is sent to the rest of that persons team. Everyone has the same company email address. How do I get the flow to work where when a response is submitted, an email with the results is sent to only that team?

[@JonJLevesque]

Abraham, you should ask this in the Flow community - aka.ms/flowcomm - try to build it and post where you get stuck and they will help!

[@setsch90]

Just did it. Great idea, Works amazingly Thanks!

[@JonJLevesque]

Woot woot! Now you have a working flow! What’s the next one you want to build?

[@ArturoIbarra]

Hi Jon. Great video. I wonder if this works with forms or is it just quizzes. Thanks!

[@JonJLevesque]

This definitely works with forms!

[@pramod.merwani3244]

Hey Jon, thanks for this! Could you help me to know if the following thing is possible or not ? I have 3 difft forms to be filled by each employee of my company 5,5,5 which means on 5th Day one form,5week,5month. I want to make this automatic, if one employee fills it on day 5 will get form link of 5th week and for 5th month without any manual or minimal manual intervention? Possible ?

[@nawal7721]

Can you have the form response sent as a message to a channel in Microsoft Teams?

[@JonJLevesque]

Yeah absolutely can! Easy as changing a step in the flow!

[@niroshthota5819]

Hello Jon ,Hope you doing well can you please fix this for me when we submit the form it will post into yammer needs to be that of the submitter ?how?

[@ViperwavStudio]

Can you explain how to just send the responses from the form* into an email? Im trying to create a Ticket* creation process by using forms to gather the information going into an IT Ticket. Trying to get it to go from Form->(flow) to send all responses into the email*

[@JonJLevesque]

Hey cory, if you do the first two form steps, and then use the "send an email" action - you should be able to drop all the dynamic content right into the email from the form

[@dianericherlefebre9499]

Thank you for sharing your knowledge, much appreciated!

[@JonJLevesque]

You are very welcome!

[@gviacava]

Thank you! great video. One question. Why I cant see these connectors in my options "outlook send an approval email" or "office 365 outlook send an approval email". I want users be able to approve from outlook.... Again thank you the material uploaded.

[@philtroy1207]

How did you get your audio to sound like it does? I am wearing headphones but it sounds like your voice is coming out of my monitor (but it isn't).

[@JonJLevesque]

Haha i was in an echoey room

[@samindajayasinghe2896]

Nice one great video, but I am new to this and then I get a good start, keep up the good work, thanks

[@JonJLevesque]

Thanks!!

[@darkroomstudios4839]

I have built a form to use as a sign up sheet. Is there a way to limit how many people can sign up for a certain date? I have tried so many different things to get this to work I can do it in google forms. But prefer the way that the Microsoft for looks and feels just need a way to do this.

[@JonJLevesque]

You’ll want to have a list of “available” dates somewhere else and have the flow check against that list when setting a date

[@mattcaffey3000]

How can i pull from one of my group form surveys?

[@alexandremartins3962]

Hey! Thanks for the video. Congratulations!

[@nicolaswift2648]

Great video. But i didn't get the 'apply to each' box. I therefore don't see the response from my test run. How can I fix this?

[@m.j.8527]

It was very interesting. Thanks. How can I automatically add the person's line manager name and line manager's email address in the organization into the email for example?

[@ngalavie]

How do I create a flow from Team’s form? I only see personal form from list?

[@batman4life203]

I was wondering the same thing

[@JonJLevesque]

unfortunately a team form isnt supported at the moment.

[@johng5295]

Thanks in a million. Second to none!

[@JonJLevesque]

So glad you enjoyed it!

[@ivordavies1438]

Jon - Is there a video that details connecting via Flow a Microsoft Form and a SharePoint Online List?

[@JonJLevesque]

This one does - kzbin.info/www/bejne/d4DTnpKii8-ao80

[@jean1801]

I watched your video and made a similar one at the same time step by step, and I got stuck when adding dynamic data and table. Around minute 21. the expansion you speak about doesn't happen and I am unable to finalize the process.

[@dimitririesen]

Hey John great job.

[@JonJLevesque]

Thanks Dimitri! I appreciate you saying so!

[@alexmcleod3614]

Nice One Mate, Love Your Work. Will pass this on to my students :) Keep it up :)

[@datukawangaliktksukp7314]

Hi Jon,thanks for your nice contain video, but I don't see your table chart. The result from survey.

[@jasrasr]

What's the advantage of sending the data to power BI dataset instead of just processing/sending it to excel or email?

[@JonJLevesque]

It’s really for if you want to build reports and visualizations of the data

[@jasrasr]

@@JonJLevesque do you have an example video of this or another resource I can check out? BTW, awesome videos. I just started this weekend with Flow with hesitation but after watching your videos, a few others, and tons of googling I am really excited to show my coworkers tomorrow. I have a whole slew of forms, excel, and flow already built from this weekend really just geeking out and trying new things...so thank you! And also for your quick reply!

[@nchimunyamuyuni7920]

This connector doesn't seem to work on my 365 family subscription despite it being a standard connector. It tells me invalid connection when I connect my personal account to forms when I try to sign in forms. Any idea how I can get it to work?

[@vladturcanu906]

Great video! I tried to implement it but I would like to attach in the email the response submitted in the form. Could you please send me a reply on how to do it?

[@ianhays2256]

Hi Jon. I have been watching your video and that have been really good! However, I am still relatively new to Forms and Flow and I am trying to figure out something within Flow. I am trying to figure out a way to send an email where the FROM field is actually the user's email address. I have a specific business case where I need this to happen and I don't want the from email address to by my email address. I tried using the From (Send as) field with the Responders' Email selected for that field, but I receive an error in my email saying "You don’t have permissions to send emails on behalf of [user email address]. Contact [user email address] to check shared mailbox permissions and gain access." Do you know if there is a way to do this within Flow at all? Thanks!

[@JonJLevesque]

Unfortunately you can’t make a Flow to send on behalf of others. That would be a huge security flaw :( You can use the flow mail service though or a sendgrid account if you want to not send from you

[@ianhays2256]

@@JonJLevesque Thanks for the feedback. I really appreciate it!

[@marianaalmeida7922]

HI Jon, Can I do a flow to come back to the form page when the form is submitted?

[@betsyk.9780]

Hey Jon, I have happily made so many forms but today, sadly wanted a time picker for my new project with ms Form Pro.. I do not want time.. any help :)

[@JonJLevesque]

Hmm care to explain more?

[@betsyk.9780]

@@JonJLevesque I want a ms Form which can allow staff to pick the hours they work per week. Like a time attendance sheet. It will contain start to finish time and lunch breaks during the 7 days.(I hope this is clearer)

[@kuladeepreddy2885]

Can you help me with Excel Online connection instead of Power BI please?

[@heatherfeather2621]

I didn't get your survey....I have an answer for "What do you dislike about Flow"....I need to export the starttime to my SPO list. I can only get that returned in excel!?!..

[@michaellarge438]

I keep getting an Error (400) when I try to test my Flow. The Power BI function doesn't let me map the fields one to one as Jon does in the video. Instead after I define my workspace/dataset Ect. it asks me to add dynamic content to the "Payload". This is where the error occurs every time. Thoughts?

[@Daguetti2011]

If I put Multiple Choice option when it gets to my email it writes something like this: "[op.1","op.2","op.3"] but i want something prettier like: - op.1; - op.2; - op.3. Is there a way i can make it? I already did a connection with a sharepoint list and it made no difference.

[@zacharyrobertson3261]

I created a form and was able to embed it as a web part to a SharePoint modern site which was my intent. I set my flow up and when the form is submitted i receive the email notification like i was wanting but can't figure out how to get the email to display the responses from the form. I would think this is possible. Can you help me out here?

[@JonJLevesque]

+zachary robertson did you add dynamic content from the form into the email Body?

[@cryto-alex5869]

Hi Jon, After creating a form, how do I transfer ownership to a new user? Everything is working in my flow and emails, but the responder's email shows the owner of the form who originally created it. I know I have to transfer the form, but what do I do? Thanks

[@dianadeonanan8708]

Getting an error at "Apply to each" step....No Dynamic Content shows up. Do you know a way around this?

[@JonJLevesque]

In the apply to each? Or outside of it?

[@JonJLevesque]

Can you be more specific?

[@norwildulay8359]

Jon, in your video after selecting the response id in the dynamic content. The flow automatically added Apply to each control it is not happening to me.

[@djmrox2298]

Hi, I want to put the data from RespondEmail in the footer without @ ...... (replace: "[e-mail]" with "xyz") how to do it in flow ".

[@jampimonpongpanlarp2891]

Love it! This is exactly what I've been looking for! By the way, it's been a year since you made your video, do you have any easier way so far?

[@garrettross1540]

Jon, When I run a test in the flow. I want to have the respondents email in the body of the email. Essentially I'm sending an email with the responses to an email so that person can go in input the data to create a proposal after they see the data. But I want the respondents email in the body so that the person interpreting the responses can then draft the proposal and send it to the email they provided in the form. But every time I do the test the email shows up as "anonymous" any tips on how to fix this would be great!

[@izzijohnny6209]

Can you make a video on some of the functions for excel online in flow. Maybe even combining it with answers from forms

[@AltheaMaela]

What if what I want is for the respondent to get a copy of the questionaire with their answers

[@JonJLevesque]

Then make sure the email is directed at them :)