1
00:00:00,450 --> 00:00:00,650
All right.

2
00:00:00,660 --> 00:00:01,140
Welcome back.

3
00:00:01,200 --> 00:00:09,000
So in this video where I talk about data collection so all data collection you can do a couple of things

4
00:00:09,000 --> 00:00:15,210
here we have record form responses in SharePoint send form responses for approval form processing into

5
00:00:15,210 --> 00:00:20,730
email and SharePoint track Microsoft forms responses and excel online business spreadsheet.

6
00:00:21,240 --> 00:00:22,160
OK.

7
00:00:22,290 --> 00:00:24,930
Notify the team when a new response is submitted.

8
00:00:25,230 --> 00:00:28,660
Send a notification when Microsoft forms responses are received.

9
00:00:28,680 --> 00:00:33,330
Create a task and planner from Microsoft forums and post message in teams.

10
00:00:33,330 --> 00:00:34,110
OK.

11
00:00:34,560 --> 00:00:37,450
Insert a row in an Excel spreadsheet when.

12
00:00:37,650 --> 00:00:41,150
Microsoft forms is submitted.

13
00:00:41,250 --> 00:00:44,010
So let's look at this one real quick.

14
00:00:44,010 --> 00:00:44,640
OK so

15
00:00:48,490 --> 00:00:57,500
so let's click on OK the flow will connect to Microsoft forms.

16
00:00:57,500 --> 00:00:58,440
So let's sign in.

17
00:00:58,460 --> 00:00:59,810
Let's create an excel Doc

18
00:01:03,770 --> 00:01:10,730
and let's use an existing connection or create a new connection and we'll use one drive for business.

19
00:01:10,730 --> 00:01:11,860
So we'll sign onto that.

20
00:01:14,380 --> 00:01:14,780
OK.

21
00:01:14,780 --> 00:01:16,040
And we're gonna use

22
00:01:22,860 --> 00:01:23,160
yes.

23
00:01:23,220 --> 00:01:24,450
So we'll remain signed in.

24
00:01:25,170 --> 00:01:25,700
OK.

25
00:01:25,710 --> 00:01:33,260
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

26
00:01:33,270 --> 00:01:35,400
learn tech plus.

27
00:01:35,400 --> 00:01:35,750
OK.

28
00:01:35,880 --> 00:01:36,470
So that.

29
00:01:36,570 --> 00:01:36,810
OK.

30
00:01:36,810 --> 00:01:39,480
So I created the Excel Doc so we'll have continue

31
00:01:43,310 --> 00:01:43,590
ok.

32
00:01:43,590 --> 00:01:46,140
So we're gonna pick a form.

33
00:01:46,650 --> 00:01:47,910
So we haven't created a form.

34
00:01:47,910 --> 00:01:53,010
So what we need to do is let's go to the app launcher here and I'm going to go.

35
00:01:53,080 --> 00:01:54,580
I mean right click on.

36
00:01:54,900 --> 00:02:00,500
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

37
00:02:00,510 --> 00:02:02,230
open the new tab.

38
00:02:02,850 --> 00:02:04,620
And what we'll do is we'll create a new form.

39
00:02:05,160 --> 00:02:05,770
OK.

40
00:02:05,910 --> 00:02:12,070
So let's go to New Form.

41
00:02:12,070 --> 00:02:12,470
OK.

42
00:02:15,070 --> 00:02:20,950
Call test form K and then we'll add a new choice.

43
00:02:20,970 --> 00:02:21,620
OK.

44
00:02:21,700 --> 00:02:26,210
So what is two plus two.

45
00:02:26,520 --> 00:02:26,750
OK.

46
00:02:26,770 --> 00:02:28,990
And our options are going to be for eight

47
00:02:32,200 --> 00:02:37,850
three all new and then we'll do another one and we'll do five plus five

48
00:02:40,560 --> 00:02:42,100
is 20.

49
00:02:42,330 --> 00:02:44,740
Or is it 10.

50
00:02:44,790 --> 00:02:45,150
OK.

51
00:02:46,530 --> 00:02:46,950
So I'll click.

52
00:02:46,950 --> 00:02:47,980
Got it.

53
00:02:48,060 --> 00:02:51,490
And then you can see right here that's where the responses will be.

54
00:02:51,630 --> 00:02:51,900
OK.

55
00:02:51,960 --> 00:03:00,250
So we created a form hero quick with this one let's do what is five plus five.

56
00:03:00,250 --> 00:03:00,600
OK.

57
00:03:01,710 --> 00:03:02,670
So that'll save it.

58
00:03:02,670 --> 00:03:06,000
And now when we go back to create our flow when I click on this

59
00:03:08,740 --> 00:03:14,050
if I refresh it's going gonna make us leave the page which is fine.

60
00:03:14,230 --> 00:03:18,410
And then when I pick a form we'll do test form.

61
00:03:18,410 --> 00:03:18,800
OK.

62
00:03:18,820 --> 00:03:29,320
And then unique identifier of the form where we use test form and then the excel file name and we'll

63
00:03:29,320 --> 00:03:30,070
go to root.

64
00:03:32,290 --> 00:03:34,150
And this is another document that we need to create.

65
00:03:34,150 --> 00:03:42,690
So let's go to one drive all right click on that open in the new tab and let's just create a file.

66
00:03:43,320 --> 00:03:45,790
Let's make a new folder so we'll call these forms

67
00:03:51,870 --> 00:03:54,890
Roy.

68
00:03:55,290 --> 00:03:56,410
Let me refresh that.

69
00:03:57,960 --> 00:03:58,290
OK.

70
00:03:58,320 --> 00:03:59,790
So this must be like a

71
00:04:02,960 --> 00:04:05,520
let's go here.

72
00:04:06,110 --> 00:04:06,810
OK.

73
00:04:06,920 --> 00:04:07,460
That's bizarre.

74
00:04:07,550 --> 00:04:12,450
So here's what we'll do we'll create a folder called sample OK.

75
00:04:12,740 --> 00:04:28,810
And then inside of sample I'm going to create an excel back and we'll call this form response.

76
00:04:29,220 --> 00:04:33,510
Now when I go back here and I add this OK.

77
00:04:33,600 --> 00:04:35,080
We have.

78
00:04:36,090 --> 00:04:37,140
If I refresh this

79
00:04:40,470 --> 00:04:46,350
case we're going to pick a form so the test form the identifier is going to be test form the excel file

80
00:04:46,380 --> 00:04:49,840
is gonna be in the root under sample.

81
00:04:51,470 --> 00:04:52,020
OK.

82
00:05:01,960 --> 00:05:10,600
So the table name so let's edit this and we'll add a table name so we'll call this responses.

83
00:05:11,390 --> 00:05:12,150
OK.

84
00:05:12,340 --> 00:05:28,340
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.

85
00:05:28,440 --> 00:05:29,890
So just two responses

86
00:05:38,270 --> 00:05:39,110
he'll save it.

87
00:05:40,080 --> 00:05:40,560
OK.

88
00:05:40,590 --> 00:05:44,690
So we got in there here choose an Excel table to choose.

89
00:05:45,300 --> 00:05:48,990
Select a range go to insert table or insert tab and shoes table

90
00:05:52,200 --> 00:05:53,460
OK.

91
00:05:53,950 --> 00:05:54,470
So

92
00:06:08,140 --> 00:06:12,400
what we'll do is we'll go in here we're going to sample

93
00:06:19,310 --> 00:06:21,740
OK and then we'll go to the table name

94
00:06:24,430 --> 00:06:25,830
so.

95
00:06:26,030 --> 00:06:29,680
To enter custom value.

96
00:06:31,850 --> 00:06:32,850
And then we'll do save

97
00:06:38,720 --> 00:06:39,740
the table name

98
00:06:48,970 --> 00:06:51,490
OK so table name is column 1.

99
00:06:51,540 --> 00:06:54,670
OK so I just added that that way this would work.

100
00:06:59,070 --> 00:07:00,360
OK so that should add up.

101
00:07:02,080 --> 00:07:03,220
And now head save

102
00:07:07,820 --> 00:07:10,040
if that doesn't work we'll just refresh here

103
00:07:13,120 --> 00:07:14,880
OK so let's try that again.

104
00:07:14,920 --> 00:07:22,230
So we'll go to route and we'll grab sample we'll grab form response and then we'll go to the.

105
00:07:22,240 --> 00:07:22,690
There you are.

106
00:07:22,690 --> 00:07:23,540
Table 1.

107
00:07:23,620 --> 00:07:24,070
Beautiful.

108
00:07:24,610 --> 00:07:25,000
All right.

109
00:07:25,000 --> 00:07:31,870
Now we'll hit save format is required.

110
00:07:31,890 --> 00:07:32,220
OK

111
00:07:35,150 --> 00:07:36,470
so column 1

112
00:07:40,120 --> 00:07:45,020
and then what we're going to do is we're going to do responses.

113
00:07:45,180 --> 00:07:46,090
OK.

114
00:07:46,540 --> 00:07:48,160
So now when I hit save

115
00:07:50,910 --> 00:07:51,630
I'll pick a form.

116
00:07:51,640 --> 00:07:51,890
OK.

117
00:07:51,890 --> 00:07:53,560
It does form.

118
00:07:53,970 --> 00:07:59,880
Mario I'd save now and now it's tell me.

119
00:07:59,880 --> 00:08:00,100
OK.

120
00:08:00,120 --> 00:08:01,290
You forgot this one too.

121
00:08:01,320 --> 00:08:03,880
So there we go.

122
00:08:03,900 --> 00:08:08,740
That's the great thing about the flow checker is that it can say hey you forgot something.

123
00:08:08,820 --> 00:08:11,460
So I'll say you got it.

124
00:08:11,850 --> 00:08:13,050
Let's check the flow checker.

125
00:08:13,050 --> 00:08:20,860
No we have no warnings or errors and I'll click on Test caps or save and test

126
00:08:25,000 --> 00:08:28,150
so to see her work now perform the start in action.

127
00:08:28,150 --> 00:08:28,720
OK.

128
00:08:28,810 --> 00:08:30,270
This may take a few moments

129
00:08:33,220 --> 00:08:39,010
all right so I go here and I go to the form.

130
00:08:39,010 --> 00:08:40,420
Let's preview the form real quick.

131
00:08:40,420 --> 00:08:43,750
So if I do eight and 20 and submit this

132
00:08:46,930 --> 00:08:49,010
I should get a response.

133
00:08:49,470 --> 00:08:51,900
OK so I'll have one right there.

134
00:08:52,450 --> 00:08:54,160
And when I go here

135
00:08:58,770 --> 00:09:00,030
I don't get a response is there.

136
00:09:00,030 --> 00:09:03,530
But there is an Excel dock that's already created with this.

137
00:09:03,810 --> 00:09:05,020
That will show this data.

138
00:09:05,200 --> 00:09:05,480
OK.

139
00:09:05,520 --> 00:09:09,510
But I want to look in the flow and see if it worked there.

140
00:09:09,510 --> 00:09:18,900
Even if it doesn't work that's OK because again it worked right here when we opened it up in excel.

141
00:09:18,990 --> 00:09:27,480
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

142
00:09:27,480 --> 00:09:30,380
start time the completion time email name.

143
00:09:30,450 --> 00:09:36,470
What is two plus two is eight and then what is five plus five it's 20.

144
00:09:36,480 --> 00:09:39,170
So and then the average time to complete three seconds.

145
00:09:39,300 --> 00:09:42,360
So it'll show the results are here

146
00:09:45,120 --> 00:09:47,420
and we can go through each responder.

147
00:09:47,510 --> 00:09:48,300
I only have one.

148
00:09:48,300 --> 00:09:52,590
So it's only a short one but we can delete or print out and then go back.

149
00:09:53,070 --> 00:10:00,600
So this is a great way to keep track of your forms if you want people to enter information and then

150
00:10:00,600 --> 00:10:03,980
you can kind of track what they're doing.

151
00:10:04,630 --> 00:10:06,430
So.

152
00:10:06,880 --> 00:10:09,510
So this is still run and that's fine.

153
00:10:09,510 --> 00:10:11,820
We'll let this run I'll see in the next video.

154
00:10:11,820 --> 00:10:12,090
All right.

155
00:10:12,090 --> 00:10:12,770
Thanks for watching.