Using Microsoft Flow with Outlook and Forms | Tech Riffs by Worksighted

(rock music) – Hey everyone, Killian
from Worksighted here with another episode of Tech Riffs. This month, we’ve talked
about a lot of different Microsoft products pretty in depth. It’s been very, very informative. We’d like to put a little
bit of a bow on top of it by going ahead and using
Forms to create a survey and then using Flow to send
that information to Outlook to notify us when somebody
fills out our survey. Let’s go ahead and get started. So, we’re going to get started by going into It’s going to bring us to this section, just like we’ve been to a few times. Now, we’ve been using Forms and Flow pretty frequently lately, so, it’s already showing up in our apps. If it’s not there, you
just want to go ahead and go to explore all your apps, it’ll show you a list. First thing we wanna
do is jump into Forms, it’s gonna load up what we have. Staff Meeting Food Order. So, one of the people that
I want to send this to, we’re actually having a guest come in, so we got to send it to somebody outside of our organization. A gentleman named Ben is going
to be giving a presentation, I want to be able to buy him lunch. So, we have this. And we click Share. And I want to email this to him so I know what I have to get for him. Now, it’s very important, up here, that you click the link. Anyone with the link can respond. The default is only people in
our organization can respond, and this would force Ben to sign in. He’s not within my organization and he, in fact, his
organization uses Google. So, they don’t even use Office 365. But that’s okay, we can still
collect information from him. So, we’re going to go ahead
and email this his way. And we’re going to wait for his response. Now, because this is kind
of a last minute order, I want to know exactly when
he’s gonna fill it out. So, one of the things that I gotta do, is I gotta create a Flow because I need to be emailed
exactly when he fills this out. So, what we’re gonna do is we’re gonna come into Flow. This template, I want to search if there’s already been a template created cause I don’t wanna do too much work, so, let’s go, we’re gonna
come up to templates and we’re going to search email forms. And we see one right here at the top, email notification for survey responses. So, we’re gonna click this guy. It’s gonna auto-log me in because I have already signed
in with both of these things and it knows it’s my Office 365 account. So, we’re gonna click continue here, and we’re gonna pick a form. Staff Meeting Food Order. Select an output is a list of responses, and the Form ID, again, is
Staff Meeting Food Order. We want to send it specifically to me. Subject, Food Order Processed. And we’re gonna say, see forms to see orders. And that’s going to be
the body of the email, we’re going to save that Flow. Once created, click done and we are going to
wait for Ben to go ahead and fill that out. And email will let us know when he’s done. We see the email come through. See forms to see the orders, exactly that I said to
tell myself, perfect. We’ll go over to Microsoft Forms and we can actually see, normally, you’re on this if
you come over to responses, we can see that Ben has
in fact put something in. One of the things that I like to do is I like to say open in Excel. Because it’s gonna put everything
out really nice for us, especially if you have a
bunch of people already that have put their orders in. And so basically what we can see, now again, Ben’s outside
of our organization, so, it’s not gonna tell us his email, it’s just going to show up as anonymous, but because we asked for his name, we know that this is Ben, he wants a ham sandwich and also lets us know that
he’s allergic to peanuts, which is good to know. And that’s it. A bunch of great ways to be more efficient and save you some time when
you’re using Forms and Flow. You can learn more about this and other cool IT tips and tricks by going to and subscribing.


Add a Comment

Your email address will not be published. Required fields are marked *