WEBVTT NOTE duration:"00:20:21.6770000" NOTE language:en-us NOTE Confidence: 0.927913904190063 00:00:03.200 --> 00:00:33.210 Hey everybody, thank you for coming. We were trying to get the speed a little higher. 'cause I had a demo earlier and it wasn't moving fast enough so we figured we work that out. My name is Audrey. I'm from the citizen application platform at Microsoft and I work with the Microsoft flow team and today I'm gonna tell you a little bit about what we've doing we've been doing with teams and Bots and see if you'd be interested. Now, more important than who I am is who you are. NOTE Confidence: 0.967062771320343 00:00:33.260 --> 00:00:38.600 I'd love to know what you're doing? How many of you are currently using Microsoft flow. NOTE Confidence: 0.883355021476746 00:00:40.720 --> 00:00:48.980 So about 50% of you OK those of you left how many of you have all of you? How many are you using power apps. NOTE Confidence: 0.917930781841278 00:00:50.800 --> 00:01:02.110 Oh, you guys are pretty new so I might have to slow to, I might have to slow down here OK. So no problem. Let's talk a little bit about Bots? Who knows what a bot is. NOTE Confidence: 0.701728761196136 00:01:03.530 --> 00:01:04.120 OK. NOTE Confidence: 0.107510432600975 00:01:05.050 --> 00:01:05.290 It. NOTE Confidence: 0.883132696151733 00:01:06.220 --> 00:01:37.230 Yep, that's right So what he said, was you can do a bot in teams. You can post as a bot and the bot can be respond or another person can respond right so bots are ways to automate responses. So if you could think of it that simply and I'm going to show you how you can create your own bot like this one, so this happens to be a flow bot that posted this message. NOTE Confidence: 0.929309070110321 00:01:37.640 --> 00:02:08.310 And just to give you the business scenario. I'm working in a company that there are people outside checking houses so a developer is building houses and people outside checking those houses to make sure they're good and they have to take a photo of what they've expected and classify it as post paint, which means paint just done punch list, which means something needs to be fixed or pre visit. NOTE Confidence: 0.928357005119324 00:02:08.400 --> 00:02:20.460 Which means that whatever I say hurry up because we waiting for people to visit and I'm going to show you the scenario that I built using flow and then I'll show you how I made it does, that work for everybody. NOTE Confidence: 0.95791620016098 00:02:21.920 --> 00:02:24.000 I'm going to start with my phone. NOTE Confidence: 0.930100798606873 00:02:25.420 --> 00:02:56.530 And if you download Microsoft flow onto your phone. You can do this at anytime so you just go to your store. Whatever your phone. Store is look for Microsoft flow, which is 2 words and you're going to be up and running using flow right away from the mobile device in other words, you can even build apps directly from the mobile device and that's what I've done here. I have created a button flow that acts very much like a nap so I'm just going to press that digital button with my finger. NOTE Confidence: 0.916415512561798 00:02:56.620 --> 00:03:04.030 And it's going to ask me for a question, which site Woodhouse. Are you inspecting and I'm going to just select 1:15. NOTE Confidence: 0.929659843444824 00:03:04.600 --> 00:03:09.790 And then it says What Category Is It. I'm going to go ahead and put this in as a punch list item. NOTE Confidence: 0.920246303081512 00:03:10.420 --> 00:03:15.980 And then the 3rd question is what are your notes and I'm just going to say door? NOTE Confidence: 0.844972491264343 00:03:16.940 --> 00:03:17.740 Cracked. NOTE Confidence: 0.944414436817169 00:03:18.320 --> 00:03:21.530 Right now, I don't have a door. NOTE Confidence: 0.84029883146286 00:03:22.520 --> 00:03:24.690 To go get to fix. NOTE Confidence: 0.928208589553833 00:03:25.220 --> 00:03:26.830 So I was going to take your picture. NOTE Confidence: 0.910576224327087 00:03:28.550 --> 00:03:57.350 So I did was click on camera. Yes, smile for me. Please yes and take that picture and you might have noticed that my prompt was in French, sorry about that. I forgot to change it back to English, but you have 2 choices. You can pick your camera or you can pick a photo you've already taken now. Once I'm finished now. I'm going to click end or terminate in French and this all is going to go run do something. So let's switch and see back in teams. NOTE Confidence: 0.95930278301239 00:03:58.180 --> 00:03:59.360 What happened here? NOTE Confidence: 0.185828000307083 00:04:01.790 --> 00:04:02.530 Uh. NOTE Confidence: 0.922705590724945 00:04:04.470 --> 00:04:08.730 I forgot which teams I'm in here, I believe it's this one. NOTE Confidence: 0.789949774742126 00:04:09.320 --> 00:04:10.030 And. NOTE Confidence: 0.920158565044403 00:04:12.210 --> 00:04:14.810 Is that you guys looks like you guys to me? NOTE Confidence: 0.953787088394165 00:04:15.470 --> 00:04:19.720 I've got a little bit of a delay on my screen here, so I'm just going to refresh the page. NOTE Confidence: 0.91798323392868 00:04:23.710 --> 00:04:36.060 So you can see that better, so this is where we're posting our inspections. And so after I press that button. The bot posted it now, the but did even more than that, if we go to share point. NOTE Confidence: 0.940767168998718 00:04:36.730 --> 00:04:45.540 You'll notice that I have a document library just a regular library and if I put this library in tile mode. NOTE Confidence: 0.951299905776978 00:04:48.950 --> 00:04:52.840 You'll see that your photo has been uploaded here as well. NOTE Confidence: 0.915073931217194 00:04:53.520 --> 00:05:05.760 Here it is a minute ago, OK now In addition to adding the photo to the library, the flow. Also, it wasn't done yet. It also added it to a list. NOTE Confidence: 0.94341641664505 00:05:06.440 --> 00:05:09.800 So that the inspection itself can be recorded. NOTE Confidence: 0.901480913162231 00:05:10.800 --> 00:05:13.770 Which is this one here I spell door cracked wrong? NOTE Confidence: 0.928613007068634 00:05:14.440 --> 00:05:26.130 And you'll notice it registered everything I did, but it also referred it to item 16 in the library and this is because now because of the work that flows done. NOTE Confidence: 0.909820914268494 00:05:26.890 --> 00:05:33.340 I am able to leverage this, this is bad, and get this to refresh real quick. NOTE Confidence: 0.947316706180573 00:05:36.280 --> 00:05:39.750 We are having some delays for some reason this week. NOTE Confidence: 0.918940007686615 00:05:40.570 --> 00:05:42.680 And then I'm going to click that edit button. NOTE Confidence: 0.929538369178772 00:05:45.050 --> 00:06:04.850 Anne what I have done on the right side of this list. As I have customized a form using powerups and this form is not only letting people go ahead and type what they want to type in here, but it also looks up. The photo from the other library to show it in the app. NOTE Confidence: 0.935719668865204 00:06:05.510 --> 00:06:13.160 Now this is really cool. So I don't know if you caught all that so that little button that took me 15 minutes to make. NOTE Confidence: 0.922003507614136 00:06:14.470 --> 00:06:28.920 Actually let me tag this photos, it uploaded the photo put it in a library. It created a list item and refer back to that photo for me and I have the capability now to refer to that in a power app. NOTE Confidence: 0.927690207958221 00:06:29.530 --> 00:06:34.080 In addition to that, but here's a little limitation that people have noticed. NOTE Confidence: 0.937103450298309 00:06:36.510 --> 00:06:41.040 When you do adaptive cards anybody ever done, adaptive cards before. NOTE Confidence: 0.938945233821869 00:06:41.640 --> 00:07:05.330 Oh, good OK, so the first complaint people have when they do this when they use this method is that the buttons that come by default don't work, but I'm going to show you how to get around that first. Let me show you how I built this whole scenario and again. It took me a total of 15 minutes to create the entire solution. NOTE Confidence: 0.924440622329712 00:07:05.860 --> 00:07:17.760 At the end I'll point out how I did these buttons, which actually do 2 new things. You haven't seen yet so I'm going to start by going to flow and letting you see the flow. NOTE Confidence: 0.920548319816589 00:07:18.330 --> 00:07:20.500 So notice when you build flows. NOTE Confidence: 0.912394523620605 00:07:21.080 --> 00:07:33.180 In flow so basically you go to flow.microsoft.com and you're off and running one thing. I love about it just before I go into this scenario should show you a few things since so many of you were new. NOTE Confidence: 0.924302995204926 00:07:34.360 --> 00:08:06.540 Whenever you go to create a new flow. You basically pick from either a template a Vizio an automated instant or schedule and just to explain the difference, so a scheduled flow is like OK. I want you to happen. Once a week. Once a year. Once a month and basically you pick your frequency and you pick when you wanted to occur in this case. Whatever is dark blue is when this flow will occur and I can read it on the bottom now when I build this scheduled flow. NOTE Confidence: 0.948356926441193 00:08:06.710 --> 00:08:09.360 Everything that happens in the flow that I built. NOTE Confidence: 0.91363137960434 00:08:10.010 --> 00:08:33.210 Will only happen on those days and at that time right and I can change the time of course, as well right and we did this to help in configuring scheduled flows because some people said it was a little challenging so we wanted to make it a lot easier and then you're just name it and it builds your flow now when you remember that I'm just going to name this as new. NOTE Confidence: 0.88958340883255 00:08:33.890 --> 00:08:35.120 Scheduled flow. NOTE Confidence: 0.928688883781433 00:08:38.870 --> 00:09:01.130 And you can see that it drops the trigger at the top of the flow because every flow starts with a trigger and that means the same thing as it says it means it means? What triggers this flow. What makes it happen in this case? What makes it happen is this schedule that you have face. NOTE Confidence: 0.925442099571228 00:09:02.050 --> 00:09:07.840 And now, what happens after this first trigger these are called actions. NOTE Confidence: 0.930011808872223 00:09:08.530 --> 00:09:40.620 And you could have any number of actions that you want so if I go in here, I can look for any number of actions that I want like send an email. Maybe I want every month, an email to go out. So I need to send an email. So I have? What I've done right. There is made a search and now I have all my connectors for those that you don't know we have over 230 connectors that you can just plug and play in this case send an email only applies to these shown here. NOTE Confidence: 0.921287655830383 00:09:40.860 --> 00:10:06.090 But then I can add an action and I can add multiple actions. That's where flow got its name. It kind of from laterally. It starts at the top in it flows right on down and every time you add a new action, the previous actions. Data is available, so I just want to show you that, so I have added send an email and I've also send in mobile notification, but when I click in this guy. NOTE Confidence: 0.912320494651794 00:10:06.880 --> 00:10:11.080 I get these dynamic tags that come from what was above. NOTE Confidence: 0.921245813369751 00:10:11.750 --> 00:10:21.180 Alright and that's where we get the name flow because the data from each action, flows down. It's available in the next action again if I were to choose the? NOTE Confidence: 0.875712990760803 00:10:22.240 --> 00:10:23.510 Condition action. NOTE Confidence: 0.927232563495636 00:10:24.110 --> 00:10:28.600 Now I will have data from both of the 2:00 actions above. NOTE Confidence: 0.93362295627594 00:10:29.360 --> 00:10:44.460 And I think for those of you that are brand new to flow. One of the biggest challenges that new flow. Users have is basically recognizing these headers here because when you're looking for data. You want to look for it in the right action. NOTE Confidence: 0.920146048069 00:10:45.080 --> 00:10:48.950 OK, now I know I have a limited demo so I'm going to keep going. NOTE Confidence: 0.961625456809998 00:10:49.530 --> 00:10:52.170 And I'm going to show you. NOTE Confidence: 0.0530863739550114 00:10:53.640 --> 00:10:54.350 Um. NOTE Confidence: 0.877150356769562 00:10:55.040 --> 00:10:56.270 The new home. NOTE Confidence: 0.915827393531799 00:11:01.600 --> 00:11:06.860 So basically I did an instant instances, like manual it's a button. NOTE Confidence: 0.923559606075287 00:11:07.400 --> 00:11:09.280 I chose the manual trigger. NOTE Confidence: 0.922966480255127 00:11:09.780 --> 00:11:17.670 And notice that I can add dropdowns right, so basically you just over here, you can choose to add. NOTE Confidence: 0.916214287281036 00:11:18.270 --> 00:11:45.040 A drop down list of options or not so in this case you can remove them. But you can add them, and then you could put as many as you want. Now we don't have a direct way to connect these two data. So I just typed in these data for the button and then it asks for inspection category. An I put in the options for that and then finally it has the inspector notes and the photo now the photo. NOTE Confidence: 0.940093874931335 00:11:45.540 --> 00:11:49.520 It's just one of the many field types that you can add to this button. NOTE Confidence: 0.918667435646057 00:11:50.340 --> 00:12:21.880 And I chose file because they can upload a picture or a file so think of that button in scenarios where you need a file. Perhaps you want people to submit an expense report. You can have that buttons and they could select the file on their device and then it would upload it to share point and then we can have another flow that says when you upload it to share point. I want to submit it to the manager. You can get all that automated so after I got the file and those that metadata, then I created a file. NOTE Confidence: 0.92151266336441 00:12:21.880 --> 00:12:33.330 And this will be in the deck that you'll get so don't worry about writing notes. But this creates the file in the SharePoint site in the folder that I want now. I did have to get a unique name. NOTE Confidence: 0.921472787857056 00:12:34.270 --> 00:12:57.630 So I chose to take from the button. The home site name plus the timestamp notice that would buttons you get a lot of data that you don't even ask them for you automatically get their full name and email address their location, longitude latitude. Their photo there Postal code. I mean, not their photo. There are posted called their state their St there times that you get all that for free. NOTE Confidence: 0.90869814157486 00:12:58.180 --> 00:13:25.460 So you never have to ask a person in a button who they are 'cause you got that right. You just need the data. After I made that file, though I put that file and share point in this action. I needed to get the ID of it because which file is it. We need to refer to that later. So I got that ID just by adding the git file properties and it gave me the ID from the file I created you can see on the right here. NOTE Confidence: 0.942071199417114 00:13:26.170 --> 00:13:31.570 Then I created the item in the SharePoint list where all the inspections are kept. NOTE Confidence: 0.914558231830597 00:13:32.080 --> 00:13:42.750 And if you notice again. I just use the dynamic fields for each of those data points and for the ref ID of the photo. I use the item ID. NOTE Confidence: 0.91251814365387 00:13:43.960 --> 00:14:11.520 Now I have everything I need to make my bot and the first 2 things my bought wants to know is what is the T man? What is the channel now? I cheated you can cheat to adaptive cards if you go to adaptive cards dot IO has a whole bunch of prevent samples right so there's a whole bunch of sample formats for this bot I'm going to go ahead and pick the activity update. NOTE Confidence: 0.901541471481323 00:14:12.020 --> 00:14:13.810 And click try it myself. NOTE Confidence: 0.92407351732254 00:14:14.470 --> 00:14:23.000 Basically, right now, this is a designer to help me design my bot. The only thing I want to change you I'm going to click this. NOTE Confidence: 0.932665586471558 00:14:23.620 --> 00:14:28.690 I'm going to get rid of assigned to an due date. And I'm just going to make this one home site. NOTE Confidence: 0.932785928249359 00:14:29.510 --> 00:15:03.420 No, it's interesting is we're working to make this designer more integrated so you will see that. But right now. All I'm doing when I'm building. This design is setting up placeholders right. I don't want these because right now. One of the limitations. We have is we cannot pick up the outcome of button presses. But we can. Most definitely use these open URLs to do other things, which I'm going to show you and I just put placeholder URLs in here, so that I can remember to fill them in. NOTE Confidence: 0.911958456039429 00:15:06.690 --> 00:15:24.410 And that's it, so everything that I did is basically recorded in Jason down here. So basically I just click the copy. JSON tag right here or I can control C from down here and then I paste that in the message area of my flow. NOTE Confidence: 0.937389433383942 00:15:25.120 --> 00:15:27.500 So I'm just going to try and zoom into this. NOTE Confidence: 0.916408777236938 00:15:28.300 --> 00:15:58.580 OK, so basically everything you store that I did in that designer I just copied it to here now. I'm going to revise it using my dynamic tags so first of all. It said adaptive cards or something like that at the top like publish adaptive cards schema so the first thing I did was change that to model repair order because that's where my scenarios about that. Static all of my cards will say that however. I don't want an image of Matt? NOTE Confidence: 0.930349409580231 00:15:58.580 --> 00:16:09.220 On the top of this car. I want the picture that they took so I can actually use the dynamic tag for the link to the SharePoint item. NOTE Confidence: 0.924673855304718 00:16:09.800 --> 00:16:41.910 To get the link to the file very easy, then if you move down. I can also say who create when it was who created it using the tags from SharePoint and format. The created date. So what I did with the formatting of the date. I am using the create date of the SharePoint item. But I'm actually using a formula and this is probably the hardest thing in this whole exercise and it will be in the deck how to do this. But for the most part at the end of this formula. NOTE Confidence: 0.924493312835693 00:16:41.910 --> 00:17:13.860 There is a why, why why month month day day and it's just something you might have seen in Excel already and it kind of helps that date format to look better. The hardest thing to remember is when you're working in that JSON area. You have to click where you want. The thing to go. The dynamic tag to go and then you have to scroll over to the right and go down because this is so long that you won't see the tag on the right like you normally do so. Just scroll down and try not to move your mouse. NOTE Confidence: 0.916771829128265 00:17:13.860 --> 00:17:42.390 That's the hardest part about this right. Finally, the 2 things I'm going to talk to you. Next is although we don't have button outputs you can use URLs to make button activities so in this case. I have 2 the first one, is basically just a link to the SharePoint item so that they can open the SharePoint item. From there, they can. Edit it or they can read it. The second one is for those of you that haven't done power apps. NOTE Confidence: 0.888844132423401 00:17:43.010 --> 00:17:56.000 I'll show you this is so if you made an app that has this data. In it now, I can deep link into that app so in this case. I'm deep linking into this app where the ref ID here equals the ref ID. NOTE Confidence: 0.928384780883789 00:17:56.520 --> 00:18:21.100 And so now they can deep link into the app now. This is probably the coolest thing that I have to show you because if you can deep link into an app. You can do anything because your arm start your on visible. You can have it launch another flow. You could have it send an email. You could have it do any number of things. So I'm just going to click on the complete task here so you can see what it does. NOTE Confidence: 0.958832859992981 00:18:22.840 --> 00:18:24.720 It should open up a new tab. NOTE Confidence: 0.926529705524445 00:18:27.460 --> 00:18:30.570 There we go and this one is opening up. NOTE Confidence: 0.940911710262299 00:18:31.370 --> 00:18:36.830 The SharePoint list form so that basically I could mark it complete. NOTE Confidence: 0.867015957832336 00:18:37.620 --> 00:18:41.040 Right I could edit all an market complete. NOTE Confidence: 0.886553287506104 00:18:41.710 --> 00:18:43.170 Simple as that right. NOTE Confidence: 0.92468249797821 00:18:43.730 --> 00:18:45.980 The other one is a? NOTE Confidence: 0.903024971485138 00:18:46.480 --> 00:18:56.520 Deep link into a mobile app. So I also have created and by the way the 2 apps were really quick to create too. I just generated them from the list. NOTE Confidence: 0.907491564750671 00:18:57.070 --> 00:19:28.290 And now I'm deep linked into the app on to that era and to that page and now I can edit that further. I can put in more data. I can do whatever I want but remember because I deep linked into an app. I could also launch another flow in my on load or my on visible on my on start statement. I could also send an email directly when that app opens there's any number of things that I could handle an opening that up, I could even create a custom menu. NOTE Confidence: 0.914499223232269 00:19:28.290 --> 00:19:40.390 In my app and just let them use that custom menu. For the buttons and again. This is temporary until we finish the work where we will actually let you have outputs on the buttons. NOTE Confidence: 0.892937898635864 00:19:41.080 --> 00:19:42.890 Does Adderall makes sense to everyone? NOTE Confidence: 0.964627504348755 00:19:44.470 --> 00:19:45.900 Is there any questions? NOTE Confidence: 0.923851668834686 00:19:47.090 --> 00:19:50.160 This is 20 minutes, I have to go fast any questions. NOTE Confidence: 0.93452787399292 00:19:50.780 --> 00:19:56.860 I'd like to ask a question real quick? How many people think they'll try adaptive cards. NOTE Confidence: 0.913479745388031 00:19:57.890 --> 00:20:16.820 OK first hand that went up please. I'd like you to try it out. Go to the to the flow.microsoft.com community. Try it out. Give me a link to what you did. Tell me a little bit about it and I'll get you. Some sweat OK. I want to hear about it. It was a really great to meet you enjoy the rest of the conference. NOTE Confidence: 0.918597877025604 00:20:18.130 --> 00:20:19.180 Thank you.