Using Teams & Flow in the Government Cloud: Tracking End-User Video Training

Published Aug 05 2019 04:00 AM 3,316 Views
Microsoft

In this article I thought I'd tackle the following idea: I have a series of training videos for my end users, and I want to track whether or not they've viewed the videos, perhaps as a way to assess completion so I can make them a nice "Congratulations!" certificate. :) In this scenario, I'm trusting my users to tell the me truth (why wouldn't they?) and I don't need to integrate with any learning management systems. Just something simple.

 

Also, I'd like for the data regarding submissions to be viewed in Teams by the staff responsible for managing the content. Let's take a look at one way to put this together quickly with SharePoint, Flow and Teams:

 

I've already got my video content ready - a video in Stream that shows how to create a Search Folder in Outlook:

 

0.png

 

 

Now I'll create a new Page in my Office365 Groups SharePoint site, and use the built-in Stream webpart to embed the video into the page:

 

0 (1).png

 

 

Below the video on that same Page, I'll add another webpart - a Microsoft Forms webpart that allows the user to Rate the video, and also effectively confirm that they've viewed it:

 

0 (2).png

 

 

Now I'll go over to Flow to create a workflow that takes the Forms responses and sends them to an Excel spreadsheet. The first part of my Flow takes care of collecting the responses received by the Form into a dataset that I can use later in the Flow:

 

0 (3).png

 

 

And in the next part of the Flow, I'll take those responses and add them as new rows in an Excel spreadsheet I have stored in one of my team sites in Office 365:

 

0 (4).png

 

 

That's it! I save my Flow, and then I start watching as my users responses start pouring in...

 

0 (5).png

 

 

Meanwhile in Teams, the staff responsible for managing the content can see the results as they come in using the convenient Tab in their Team linked to the spreadsheet

 

0 (6).png

 

 

And look! They're already starting to have conversations with each other about the results...

 

0 (7).png

 

 

So, in just a short amount of time, I've put a system together for collecting end user responses from a SharePoint page, and showing the results in Teams. Now I just need to get a buddy to put a nice PowerBI bar chart together of the Ratings so I can display that in Teams as well! :) Maybe in the next post. Until then, hope this helps - enjoy!

 

2 Comments
Senior Member
What a great how-to document. I'm liking it.
Occasional Visitor

I am really looking forward to doing this, as soon as Flow and Stream becomes available in GCC-H. Both were CY19Q1 but now Stream is TBD and Flow is Q3, which is almost over. 

%3CLINGO-SUB%20id%3D%22lingo-sub-788457%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Teams%20%26amp%3B%20Flow%20in%20the%20Government%20Cloud%3A%20Tracking%20End-User%20Video%20Training%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788457%22%20slang%3D%22en-US%22%3EWhat%20a%20great%20how-to%20document.%20I'm%20liking%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-859829%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Teams%20%26amp%3B%20Flow%20in%20the%20Government%20Cloud%3A%20Tracking%20End-User%20Video%20Training%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-859829%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20really%20looking%20forward%20to%20doing%20this%2C%20as%20soon%20as%20Flow%20and%20Stream%20becomes%20available%20in%20GCC-H.%20Both%20were%20CY19Q1%20but%20now%20Stream%20is%20TBD%20and%20Flow%20is%20Q3%2C%20which%20is%20almost%20over.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-755475%22%20slang%3D%22en-US%22%3EUsing%20Teams%20%26amp%3B%20Flow%20in%20the%20Government%20Cloud%3A%20Tracking%20End-User%20Video%20Training%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-755475%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20this%20article%20I%20thought%20I'd%20tackle%20the%20following%20idea%3A%20I%20have%20a%20series%20of%20training%20videos%20for%20my%20end%20users%2C%20and%20I%20want%20to%20track%20whether%20or%20not%20they've%20viewed%20the%20videos%2C%20perhaps%20as%20a%20way%20to%20assess%20completion%20so%20I%20can%20make%20them%20a%20nice%20%22Congratulations!%22%20certificate.%20%3A)In%20this%20scenario%2C%20I'm%20trusting%20my%20users%20to%20tell%20the%20me%20truth%20(why%20wouldn't%20they%3F)%20and%20I%20don't%20need%20to%20integrate%20with%20any%20learning%20management%20systems.%20Just%20something%20simple.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlso%2C%20I'd%20like%20for%20the%20data%20regarding%20submissions%20to%20be%20viewed%20in%20Teams%20by%20the%20staff%20responsible%20for%20managing%20the%20content.%20Let's%20take%20a%20look%20at%20one%20way%20to%20put%20this%20together%20quickly%20with%20SharePoint%2C%20Flow%20and%20Teams%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI've%20already%20got%20my%20video%20content%20ready%20-%20a%20video%20in%20Stream%20that%20shows%20how%20to%20create%20a%20Search%20Folder%20in%20Outlook%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20933px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134947iFDDE19D25C64EF8F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220.png%22%20title%3D%220.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22slate-resizable-image-embed%20slate-image-embed__resize-full-width%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%20I'll%20create%20a%20new%20Page%20in%20my%20Office365%20Groups%20SharePoint%20site%2C%20and%20use%20the%20built-in%20Stream%20webpart%20to%20embed%20the%20video%20into%20the%20page%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134948i0F337CBBC19A2484%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220%20(1).png%22%20title%3D%220%20(1).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22slate-resizable-image-embed%20slate-image-embed__resize-full-width%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBelow%20the%20video%20on%20that%20same%20Page%2C%20I'll%20add%20another%20webpart%20-%20a%20Microsoft%20Forms%20webpart%20that%20allows%20the%20user%20to%20Rate%20the%20video%2C%20and%20also%20effectively%20confirm%20that%20they've%20viewed%20it%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134949i068BA5A44F3DCD41%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220%20(2).png%22%20title%3D%220%20(2).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22slate-resizable-image-embed%20slate-image-embed__resize-full-width%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%20I'll%20go%20over%20to%20Flow%20to%20create%20a%20workflow%20that%20takes%20the%20Forms%20responses%20and%20sends%20them%20to%20an%20Excel%20spreadsheet.%20The%20first%20part%20of%20my%20Flow%20takes%20care%20of%20collecting%20the%20responses%20received%20by%20the%20Form%20into%20a%20dataset%20that%20I%20can%20use%20later%20in%20the%20Flow%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20668px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134950iC720F32010791DF8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220%20(3).png%22%20title%3D%220%20(3).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22slate-resizable-image-embed%20slate-image-embed__resize-full-width%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20in%20the%20next%20part%20of%20the%20Flow%2C%20I'll%20take%20those%20responses%20and%20add%20them%20as%20new%20rows%20in%20an%20Excel%20spreadsheet%20I%20have%20stored%20in%20one%20of%20my%20team%20sites%20in%20Office%20365%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20625px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134951i34CC293E26AF0213%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220%20(4).png%22%20title%3D%220%20(4).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22slate-resizable-image-embed%20slate-image-embed__resize-full-width%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20it!%20I%20save%20my%20Flow%2C%20and%20then%20I%20start%20watching%20as%20my%20users%20responses%20start%20pouring%20in...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20560px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134952iF5B886CC79B9BD89%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220%20(5).png%22%20title%3D%220%20(5).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22slate-resizable-image-embed%20slate-image-embed__resize-full-width%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMeanwhile%20in%20Teams%2C%20the%20staff%20responsible%20for%20managing%20the%20content%20can%20see%20the%20results%20as%20they%20come%20in%20using%20the%20convenient%20Tab%20in%20their%20Team%20linked%20to%20the%20spreadsheet%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134953i15E6ECAA276AC38C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220%20(6).png%22%20title%3D%220%20(6).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22slate-resizable-image-embed%20slate-image-embed__resize-full-width%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20look!%20They're%20already%20starting%20to%20have%20conversations%20with%20each%20other%20about%20the%20results...%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20756px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134954i369D70B8955F52C1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%220%20(7).png%22%20title%3D%220%20(7).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CDIV%20class%3D%22slate-resizable-image-embed%20slate-image-embed__resize-full-width%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%2C%20in%20just%20a%20short%20amount%20of%20time%2C%20I've%20put%20a%20system%20together%20for%20collecting%20end%20user%20responses%20from%20a%20SharePoint%20page%2C%20and%20showing%20the%20results%20in%20Teams.%20Now%20I%20just%20need%20to%20get%20a%20buddy%20to%20put%20a%20nice%20PowerBI%20bar%20chart%20together%20of%20the%20Ratings%20so%20I%20can%20display%20that%20in%20Teams%20as%20well!%20%3A)Maybe%20in%20the%20next%20post.%20Until%20then%2C%20hope%20this%20helps%20-%20enjoy!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-755475%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20666px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123320i3A25E6199E456B3A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22using%20teams%20and%20flow.jpg%22%20title%3D%22using%20teams%20and%20flow.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20this%20article%20I%20thought%20I'd%20tackle%20the%20following%20idea%3A%20I%20have%20a%20series%20of%20training%20videos%20for%20my%20end%20users%2C%20and%20I%20want%20to%20track%20whether%20or%20not%20they've%20viewed%20the%20videos%2C%20perhaps%20as%20a%20way%20to%20assess%20completion%20so%20I%20can%20make%20them%20a%20nice%20%22Congratulations!%22%20certificate.%20%3A)In%20this%20scenario%2C%20I'm%20trusting%20my%20users%20to%20tell%20the%20me%20truth%20(why%20wouldn't%20they%3F)%20and%20I%20don't%20need%20to%20integrate%20with%20any%20learning%20management%20systems.%20Just%20something%20simple.%3C%2FP%3E%0A%3CP%3EAlso%2C%20I'd%20like%20for%20the%20data%20regarding%20submissions%20to%20be%20viewed%20in%20Teams%20by%20the%20staff%20responsible%20for%20managing%20the%20content.%20Let's%20take%20a%20look%20at%20one%20way%20to%20put%20this%20together%20quickly%20with%20SharePoint%2C%20Flow%20and%20Teams%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-755475%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdoption%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBest%20Practices%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Elocal%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EState%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETeamwork%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Oct 01 2019 08:48 AM
Updated by: