Using Email Flow in Microsoft Forms

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
- [Narrator] Hi, and welcome back to myexcelonline.com. Today, we are going to go over how to integrate a form with Microsoft Forms and a flow which is created in Power Automate. If you want to learn more about Microsoft Excel and Office join our academy online course and access more than a 1,000 video training tutorials so that you can advance your level and get the promotions, pay raises or new jobs. The link to join our academy online course is in the description. So what exactly is a flow and Power Automate? Well, a flow is a series of steps that are automatically run based on a lot of different variables but one of those variables can be user input. So in this case, when a user submits a response to the form that we've created we want a series of actions to happen. In this case, we are going to have a Contact Us form and we are going to redirect emails based on what department the user wishes to contact. So let's get started creating that. Here I am on office.com and what I would like to do first is create a form. So if I go over here to the app launcher I might see forms in here if I've recently used it but if forms does not appear in this list go down to all apps and scroll down to forms. So in our case, we're just gonna go right here to new form. In my form, I'm gonna call it, contact us. And I would like to ask the user first, which department they would like to contact. And I'm going to do that using the choice option right here. Which department would you like to contact? So let's say option one be sales, option two be support and let's add a third option for customer service for all types of other inquiries. And we are going to require this field right here because if we don't require it we're not going to know who to send the email to. And so let's go down here to add new and this time add text and say, what is your primary question, issue, concern? And this one should also be required so that there's somebody for the email. And we can make this a long answer if you would like in case you wanna let your user type in more information then the small amount of space and the not long answer. So there's our form. So basically the flow that we are going to create is going to go like this. The user's going to come in and indicate which department they would like to contact, on the back end we'll know the email for each of those contacts and then we will send that department whatever the user puts in here as their concern. If you are liking this video, please give us a thumbs up and subscribe to our channel and hit the bell button to get notified when we release our weekly videos. Okay so now that we have the form side of this let's go to the Power Automate side of this. I can close out this tab but I am going to go back to Office. And again, just like forms, I'm going to go up to the app launcher. If Power Automate is here, you can click on it or you can go to all apps and scroll down to the P's and select Power Automate here. So we are going to create this from scratch. So we're gonna go over here to the Create option on the menu. And if I scroll up to the top I can create an automated cloud flow and you can see that this is triggered by a designated event. And so when I click on that our designated event is listed right here in the list when a new response is submitted. So I'm going to select that. And then I'm going to call this flow, redirect emails and then I'm going to hit Create. Now this is my trigger, when a new response is submitted but what form do I want that new response to come from? If I click down on these options I can see a few contact us forms that I created in error but I know the latest one is going to be at the top. So I'm going to select that one. And if you can't get to this and you're getting a sign in button right here, that's because you need to sign in to your Microsoft account. So go ahead and do that. And then you should be able to see the forms that are available to you. So now I'm going to go to my next step. So once a response is submitted I wanna go get the details from that form. So I typed forms up here and I can see that action down here, get response details. This is going to tell me what the user entered. I know it looks like two steps but the first one is what forms submitted an answer. The second one is what are the responses on that form. So I'm going to go over here and I'm going to go back to the Contact Us form. And then my response ID is going to be the ID of the form from right here. And when I click on that you can see that this window appears and this window is called dynamic content. That means that this information is coming from somewhere earlier in the flow. And in this case, the response ID here is the unique ID of the form that I want to work with. So I'm going to click that and now my next step is going to be something called a control and I'm going to select a condition. So this is where Power Automate gets really interesting. If I click in here, I can choose a value and you can see the dynamic content is coming from my form. So I would like to go to who would you like to contact? And I want this condition to be when a user selects who would you like to contact and it is equal to sales. And when someone has selected sales, you see the yes right here? Yes, someone has selected sales. I'm going to add an action. And that action is I'm going to send an email. So if I select Outlook right here I can see what my email options are. So I'm going to click, Send an Email and who am I going to send it to? Well, I'm going to send it to my sales department but right now I need to send it to my email so we can do a test and we can see that it works. But when you're doing this scenario just make sure it's going to your sales department email. So in my case, I'm just gonna type in my test account. So in my subject I'm going to include the option that the user picked. So I'm just going to click on who would you like to contact. And down here in the body I'm going to scroll down and go to the dynamic content for describing your question, issue, concern. So you can see, I have the first part of sales and sales will get this email. So let's keep going with our flow For the next two options that your user may want to contact. I'm going to go down here to new step and I'm going to add another condition. And this time let's pick who would you like to contact as support and go down here in the Yes category and add an action. And we're going to again, pick Outlook and send an email. And there probably is a support email, but again just to test this, I'm going to put in my email and for the subject I'm going to pick the option that the responder put in, and for the body I'm going to pick the description of the question that the user has. And so I'm going to do one more new step and do this as one more condition. And this time it's where who would you like to contact is equal to customer service. And I'm going to add the same action for the third time down here where I pick Outlook, send an email, again send it to me, have the subject be the choice that the user selected and have the body be their issue or concern. Okay so those are our steps of our flow. Let's go over it one more time. When someone submits a new response we're gonna get the details of that response. If a department they would like to select is sales we're gonna send an email to sales. If the department they would like to pick is support we're gonna send an email to support. And if the department they want to contact is customer service we'll send the email to customer service. So I'm going to save this and then I'm going to go back to Microsoft Forms. And I'm going to click this button that says Collect Responses and I'm going to copy the link to my form. Now I'm going to go up to my address bar and just paste that link. So let's fill out three of these. The first one goes to sales and hit Submit. I'm going to paste that link again in my address bar and hit Enter. This one will go to support, and I'm just going to say support in my issue. And then I'll paste that one more time here and fill out a third form for customer service and say customer service here and hit Submit. So now if I go back to office.com and I click on Outlook, one email has been sent to me for sales, one for support and one for customer service, exactly in the order that I had filled out those forms. So hopefully this gives you an introduction to some of the possibilities using Microsoft Forms alongside Power Automate. If you have any questions or comments, please leave them below and we'll get back to you. As always, thanks for watching and see you again next time. If you want to learn more about Microsoft Excel and Office join our academy online course and access more than a 1000 video training tutorials so that you can advance your level and get the promotions, pay raises or new jobs. The link to join our academy online course is in the description. - If you like his video, subscribe to our YouTube channel. And if you're really serious about advancing your Microsoft Excel skills so you can stand up from the crowd and get the jobs, promotion, and pay rises that you deserve, then click up here and join our academy online course today. (upbeat music)
Info
Channel: MyExcelOnline.com
Views: 4,269
Rating: undefined out of 5
Keywords: email flow in microsoft forms, microsoft, forms, ms forms, microsoft forms, survey monkey, google form, form, responses, email form responses, flow, microsoft flow, power automate, microsoft power automate, send forms responses, send form responses, microsoft form to email, forms to email flow, office.com, microsoft 365, office 365, feedback form, email feedback form, outlook, power, automate, power automate tutorial, microsoft flow tutorial, microsoft forms tutorial, tutorial
Id: sMn5SYO7xS4
Channel Id: undefined
Length: 10min 57sec (657 seconds)
Published: Thu Sep 22 2022
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.