All right.
Welcome back.
So in this video where I talk about data collection so all data collection you can do a couple of things
here we have record form responses in SharePoint send form responses for approval form processing into
email and SharePoint track Microsoft forms responses and excel online business spreadsheet.
OK.
Notify the team when a new response is submitted.
Send a notification when Microsoft forms responses are received.
Create a task and planner from Microsoft forums and post message in teams.
OK.
Insert a row in an Excel spreadsheet when.
Microsoft forms is submitted.
So let's look at this one real quick.
OK so
so let's click on OK the flow will connect to Microsoft forms.
So let's sign in.
Let's create an excel Doc
and let's use an existing connection or create a new connection and we'll use one drive for business.
So we'll sign onto that.
OK.
And we're gonna use
yes.
So we'll remain signed in.
OK.
So what it's gonna do now is we're going to create the Excel Doc and we'll sign it with J Warner and
learn tech plus.
OK.
So that.
OK.
So I created the Excel Doc so we'll have continue
ok.
So we're gonna pick a form.
So we haven't created a form.
So what we need to do is let's go to the app launcher here and I'm going to go.
I mean right click on.
Well let's left click on all apps and then we're going to go to forms and I'll right click on that and
open the new tab.
And what we'll do is we'll create a new form.
OK.
So let's go to New Form.
OK.
Call test form K and then we'll add a new choice.
OK.
So what is two plus two.
OK.
And our options are going to be for eight
three all new and then we'll do another one and we'll do five plus five
is 20.
Or is it 10.
OK.
So I'll click.
Got it.
And then you can see right here that's where the responses will be.
OK.
So we created a form hero quick with this one let's do what is five plus five.
OK.
So that'll save it.
And now when we go back to create our flow when I click on this
if I refresh it's going gonna make us leave the page which is fine.
And then when I pick a form we'll do test form.
OK.
And then unique identifier of the form where we use test form and then the excel file name and we'll
go to root.
And this is another document that we need to create.
So let's go to one drive all right click on that open in the new tab and let's just create a file.
Let's make a new folder so we'll call these forms
Roy.
Let me refresh that.
OK.
So this must be like a
let's go here.
OK.
That's bizarre.
So here's what we'll do we'll create a folder called sample OK.
And then inside of sample I'm going to create an excel back and we'll call this form response.
Now when I go back here and I add this OK.
We have.
If I refresh this
case we're going to pick a form so the test form the identifier is going to be test form the excel file
is gonna be in the root under sample.
OK.
So the table name so let's edit this and we'll add a table name so we'll call this responses.
OK.
And we'll let that save and then we'll go back to our flow and we'll click on this will type and responses.
So just two responses
he'll save it.
OK.
So we got in there here choose an Excel table to choose.
Select a range go to insert table or insert tab and shoes table
OK.
So
what we'll do is we'll go in here we're going to sample
OK and then we'll go to the table name
so.
To enter custom value.
And then we'll do save
the table name
OK so table name is column 1.
OK so I just added that that way this would work.
OK so that should add up.
And now head save
if that doesn't work we'll just refresh here
OK so let's try that again.
So we'll go to route and we'll grab sample we'll grab form response and then we'll go to the.
There you are.
Table 1.
Beautiful.
All right.
Now we'll hit save format is required.
OK
so column 1
and then what we're going to do is we're going to do responses.
OK.
So now when I hit save
I'll pick a form.
OK.
It does form.
Mario I'd save now and now it's tell me.
OK.
You forgot this one too.
So there we go.
That's the great thing about the flow checker is that it can say hey you forgot something.
So I'll say you got it.
Let's check the flow checker.
No we have no warnings or errors and I'll click on Test caps or save and test
so to see her work now perform the start in action.
OK.
This may take a few moments
all right so I go here and I go to the form.
Let's preview the form real quick.
So if I do eight and 20 and submit this
I should get a response.
OK so I'll have one right there.
And when I go here
I don't get a response is there.
But there is an Excel dock that's already created with this.
That will show this data.
OK.
But I want to look in the flow and see if it worked there.
Even if it doesn't work that's OK because again it worked right here when we opened it up in excel.
So if I open this and excel it'll pop up the content and you can see right here the I.D. is one the
start time the completion time email name.
What is two plus two is eight and then what is five plus five it's 20.
So and then the average time to complete three seconds.
So it'll show the results are here
and we can go through each responder.
I only have one.
So it's only a short one but we can delete or print out and then go back.
So this is a great way to keep track of your forms if you want people to enter information and then
you can kind of track what they're doing.
So.
So this is still run and that's fine.
We'll let this run I'll see in the next video.
All right.
Thanks for watching.