Office 365 business apps (SharePoint PowerApps Flow forms): What's new and what's - BRK2105
Hey. Chris, hang. On, everyone. Is here I. Was. Talking about the project we were looking at last week remember what. Do you hang on. Actually. Really hang on. Okay. Well. Hopefully Chris can't remember the project they was talking about. And. Now he's drinking water. Chris. It's very crucial we house so good so. Good. Cuz. That project, is my life where is the project. Okay. Well. We gotta wait - Chris drink, his water, this. Is really thirsty ah yes. You're saying hang on. Chris. That's your second water bottle what's happening, I, mean. I'm so sorry, had a long flight here and the, drink heart was broken on my flight I did not get a chance to have anything to drink that's exactly, over here oh not even any water that's exactly my project I'd told you to build a system that, can find these defective. Cards, oh I, know, I know I'm, sorry it just must be the thirst it's overwhelming, let me show you what we have okay. Okay. So. You haven't been we do have it let's take a look. So. Thanks, to the miracles, of power apps. We're. Still not seeing. Let's. Get to ball. Or apps instead of looking on it go on eat. Great. Also. Letting everyone see my super. Secret demo yes we're not seeing it. Six. Great. Excellent. Are we seeing it. Nope. Tada. Yeah. I really appreciate people plugging, for a grown man clapping. For a grown man who's able to plug a cable in so that's so. Here's the app that we have so we. Built a power app this is designed for any flight attendant, to be able to check. Their schedule, being able to see who the key contacts, are sourced, from a SharePoint, list that felt good does it do what I asked it absolutely does what we asked so we're able to come in here be, able to take a photo, of a device, will. Say what it is oh this. Is it this is a picture of a. Drink cart and. So what someone can do is they can take the picture. Select. It send, it to the cloud okay. And so, when it sends it to the cloud is gonna log what the issue is and in. Just a couple seconds, it should be able to identify does, the kind of device it seen does it go to a SharePoint. List it, writes to a SharePoint library excellent, and it. Says, here we go problems been identified, we get a message it comes back to us and it, says I've identified a problem with a cart see. Link for advice excellent. Click. The link hang on so that was Flo that was Flo, yeah and now I am in SharePoint, app yeah. The flow connects, everything we start with the power app we connect to a cognitive, service identify. The image save, the changes back to SharePoint, and then open up a SharePoint page with, the troubleshooting, advice recognizing, that this is a cart being. Able to say here's what the potential problems are what, to do in a flight of two hours or less so if I had actually finished. This app on time I could have given it to the flight attendant to help them figure out what to do but regardless, I think you're a great consultant, well thank you very much I think. You're a wonderful person to work with as well so. Let's get back to. So. Thank. You for coming my. Name is Chris McNulty I am a senior product manager on the SharePoint, and onedrive team. Hi. Everyone I'm Chuck, really people know me as Chuck's and one of the senior program, managers, in SharePoint, team and so. Just, to let everyone know what to expect for today today's. Session, is a whirlwind. Tour of power, apps flow, forms. Lists. The core capabilities. For, business apps as part of office 365 we'll, start by taking a look at some of our latest innovations, and lists then, we'll turn to workflow, we'll, spend some time looking at how applications, get built we'll spend some time looking at how we can weave in extra, services from the cloud to enrich what we're doing and then wrap up with next steps. So. This. Full. Disclosure is a Microsoft. Marketing, slide. The. World is changing, which. Is changing, how we work how. Do we feel about this okay. I, hate. This slide I, hate. This slide. How. Do we feel about fear-based, marketing. Because. That's what this is supposed to be the, world is already, changing you're, behind you have to run to catch up you better do it or you'll be left out of the out of the race that's what Chris did and go build up our app basically for all the cop. Stuff so. I prefer flipping. This the other way around, about. Two years ago I was doing a presentation in New York my. Sister is a. Stem teacher on the Upper West Side and, she asked me what we were talking about and I said digital. Transformation, blah blah blah blah blah blah and she said stop. What. Are you talking about in words that a seventh-grade class would understand. So. We talked a little bit about how. She gets, technical. Projects, done at her school they, typically put, them on a list and they wait for the, guy who. Happens to in this case actually be a guy who, comes out from the district once a month to deal with technology problems.
I, Think. What's fundamental, is thinking, about giving. People the tools to. Work in the style that they are accustomed to, so, I asked my sister about, how, she. Communicate. And work on projects, with teachers, and parents she. Said well we might like to be able to do it through our portal but, they, haven't really given us a way to do it so we typically, register. It as a project they never get to it and so, we still, go back to paper, and pencil. Digital. Transformation. Is not about, a massive. Change, that sweeps the world that you need to catch up with digital. Transformation. Is about changing. The way each. Of you in this room and the folks that you work with do. Their jobs giving. People the tools to, mix, and match to, be able to deliver solutions, that work for them and it, is step by step day, by day week. By week that. The world slowly becomes, changed, not top-down but. Because each of us is getting the tools that we need to, be able to transform, our own digital lives. And. In. That regards it's. About the tools that you have in your hands right so with SharePoint, we believe that's the tool that, is the centerpiece of managing, your content, when. It comes to content it's about creating. All those beautiful pages and all, those beautiful composite, apps that you have along. With all the data that you store in lists and libraries in, SharePoint, and along with that you provide, all of the you, know Microsoft 365, provides all of the necessary integrations. That you want to, augment, that data whether it be it from exchange, or rather be it from your planner or whether, it be it you know looking at teams and embedding SharePoint, in teams and back and forth all of those is possible, and through. This it's, not about you know as Chris said this. Is you know something is big is happening it's about how we work and how we adopt, these tools to, how. We bring. The work to us so that we can be productive in what we do so that's. What we think about content, collaboration with, SharePoint, and every other tools that we have in Microsoft, 365. When. We think about the tool set that we have I'm gonna come behind you here. This. Is a little bit of a guide to how we're gonna walk through things today we, think businesses. Are changing, at a faster, pace than ever and each of us is getting more and more tools to, help with that transition for. Us that journey starts with SharePoint, as chalks was mentioning being able to bring data. And content together, through SharePoint lists and libraries as, a foundational, element for, how business. Transformation, happens secondly. Being able to use the power of flow to, reach across Microsoft. And beyond to, help integrate over 200, apps and services with, more and more coming, in every month third. Being able to use, Microsoft. Flow we've, taken a big bet across, SharePoint, and onedrive about. Using flow is our principal, automation. Engine for all sorts of things like proven, and paid joins which chalks is going to be talking about in just a few minutes here as well as being able to give you templates, and actions that you can use as building, blocks to combine, in. New, and exciting ways for, the ways that we processes, get transformed.
Forth. Being able to bring things together with power apps power, apps is a great place to build applications that I can distribute to mobile devices to the web and. Be able to build custom forums that I can use inside SharePoint, and coming, soon to teams finally. Being able to bind, all of this together and enrich it with cloud, services, like power bi, Microsoft. Graph and cognitive, services to, be able to do things which would beyond the realm of computer scientists, just a couple of decades ago. And. You. Don't have to just take it from us we. Have a growing, arsenal of customers, who have been tremendously, successful, building. Business applications, on top of SharePoint using, the tools that we're gonna be talking about today, so. This is good list but. Someone is missing someone, I really really love like, being a kid myself at heart you. Know I love that customer yeah there's an. Essential building block that I think is missing yeah so I, think it's about time we should introduce, Camilla. Friedreich's in from Lego Camilla. Come on out. Welcome. To ignite thank you for joining us thank you for having me so can, you tell me a little bit about Lego because, we all understand. Lego. Is the kids toy company, right yes it, is. But. Lego is so much more also its yeah. Imagining. Creating. Fantastic. Experience, for kids mm-hmm, yeah and, I. Am. Working in a team called continuum perceived quality and we are actually looking into you. Can say the crank it, so, whenever a kid, is getting a box and they are missing a brick mm-hmm. They will call consumer service and the consumer service will put in you know the pendous you know they will see about a replacement, pad but. All this data is locked into a database and we, the team I mean we are looking into these data's to. Find. Trend so we can solve quality, issues because, that is also what Lego is about is knowledge, sharing we made a mistake how, can we share it between us, I mean, Lego is fantastic. I love when they have the display, is set up at the mall like you know I you. Know I still, get a little confused with more than three or four blocks but people who build you, know the 10-foot, high Taj Mahal and the master, builders and the specialists it's really amazing so. Can. We talk a little bit about kind, of how you were, dealing, with some of these quality issues now you were using Excel, originally, yes, we were I love Excel as you saw I am like, 20.
Years In Excel mm-hmm, and, I we, started out making the lists in Excel but when we are having, 400 plus potential. Quality cases, going through the. Team every year somehow. Excel. Is good but when you're searching for the case you, it's. Hard to find it and, also to safeguard, it because this excel, sheet was our backbone in our reporting, so we were only two people in the team that was actually, allowed. To add and put, in data so, you've got hundreds and hundreds of cases but trying to flow through to people yes. How. Long were you working that way -. Yes - years yes. But. Definitely some roadblocks. So how did you. Figure. Out there. Was a better way to do it actually. We wanted to safeguard. The data so we wanted to move away from the excel sheet because everybody, was afraid of deleting, something or altering, something, so, we were talking about okay let's go into Access database. And. That, is also a great solution, but I we. Would also like to share the information with our stakeholders, and you. Know I I, don't like double locking okay, so. SharePoint. Was actually, first. And, with the perhaps, on top of it so. The solution that you have that you you have the data it's sourced, in a SharePoint list yes. And. Power. Apps on top of it yeah, we are yeah it's actually a canvas, blank canvas and then the the, SharePoint. Is connected. To it so we didn't start from SharePoint I started in power apps got, it and. How. Many dozens of people did it take for you to build a solution I. Don't. Know it took a few months because we were back and forth you know Lego, is all about quality so yeah it took some, iterations. And the team before we got this look but. Here, you can actually also see that we are working with more. Visual, recognition, so, because, we have these cases through, our hands. We. Know, the box we know the elements so you are preset, when you see that. How. I a pew. Ah this. Is the case we're working with actually and so this is used by mr.. Salford. There's a we, had team of nine, people for now and then we will have the stakeholders, with, another power app so they will get. The. Data in, a slightly different way so, if, you, were to look at this application. And, notice. There was something in a drop-down that needed to be changed so. You go, back to IT or you come to Microsoft to make changes like that or how does that work no actually, I just make it and then I push publish, excellent. Yeah. And. You. Are principally, an IT or not no. I am just yeah, working in quality with. Anyone. Fantastic. I love hearing about stories about how we're able to make people, more. Productive about, being able to transform, the way that you work and. You know hopefully we can continue to build more and more things for. You so you can build more and more building blocks for my kids. Well. Anyway thank you very much for joining us. So. Now I know a power, app is going to be behind all. Of those lego, quality, control issues that people submit and make sure that by getting fixed. So. Let's. Continue on. So. With those building blocks today, we. Have done a lot of stuff with these building blocks right so these are essentially the things that we have given you so far for the past year or two and we're.
You. Know customers. Like Lego are able to build awesome stuff and being, more productive so, with lists we did column, formatting last year, or may I say I guess which. You can format the column in the way how you want to show data and then, we have. Modern. Experiences. That everywhere that list is powered by along. With lots of column. Resizing, updates, that we just released a few months back the, filters pane the predictive, indexing, which is really a very. Cool thing if you really have working with large lists and finally. With flow we have lots of you know growing connections lists so it's 200, plus I think it's probably 250, plus right now we. Have lots of useful templates, and actions, for SharePoint connector as well as every other connector, that you could think about in this in the service world we, integrated, flows into, SharePoint. UX so, that it's deeply, involved in all of the things that we do in SharePoint, with, power apps you saw as you know Lego talking about doing the integration with SharePoint lists we, also have integration, with custom forms and webparts if you want to ember your power app on a SharePoint page and forms. Microsoft, forms it's a very simple solution if you want to quickly start a survey or you, know get some feedback from a group of people or you know any, other scenario. You have its. No group connector so. It's easily embedded. In a SharePoint page and uses libraries, behind the scenes to use, all of the other functionalities, we get and let's, not about let's, not forget about power bi the. The powerful dashboard, that's able to help. You visualize all, of the analytics that's happening, with all the data that you have and. Similarly, we have webparts, and other clients, updated, in, that power. Bi product. As well so, this is most of the stuff we're not going to be talking about today yeah these, are the core tools that we've already shipped if. You follow the tech community blog, this. Is a quick, example of, some of the things that we're gonna be talking about today some, of the announcements that we made on the tech community blog, yesterday and it's really going to inform, everything. That we have and if for those of you who are taking pictures in the front row there. Is a much prettier version of this roadmap slide, coming later in the presentation so, I just want to consider make sure people know hey. It's at least I can do market ok maybe.
They're Doing some cognitive AI stuff, that I don't know they absolutely could be exactly, so, what starts with lists and let's jump straight into demo. Fantastic. So. Here we are. In. A modern SharePoint, team site and. As. We were on the stage yesterday talking about many, of the things that I can do it's a communication, site level for being able to engage people with news but, today we really want to look at those practical, business. Data situations, so, if I'm looking at the contents, of my site I. Can. Come directly here, to the new widget on the command bar and say that I want to create a new list and now, I have a new list creation, experience, I can, create a list from, an existing list and it's. Going to allow me to browse, all. Sorts, of things that are out there, and. So. I can say here's, one from fly taps troubleshooting, I can, look at. Structures. That I've used in all of the team sites that I've been engaged with but, let's go you know we can go grab this events list and. Add. An events list here. And. SharePoint's gonna copy the structure and give me a new list here in my site just, as soon as this finishes processing and here, we have an events list. So. Remember. Last week I sent you a axilla. Tashman t' about. Some of the locations, and you know, we. Were going to look, next week you're gonna go tour around all of our locations right yes, can we bring them in sharepoint miss i don't want it to be in Excel I mean no, offense guys Excel is a great product but I want to be in SharePoint, so if you send something for to me from Excel we can come right to. The. Site contents page again. Choosing. A Moute Excel, and then I come to new list I can say I want to create a new list from, Excel. So. This one is going to ask me for a list of. Call. This an office's list so. I have an excel file with a list of locations so. You Ivan, remind. Me did you put that attachment in onedrive, this. Is attacking saved in onedrive yeah because you know I send it as an attachment and, Chris was like why. Are you sending in attachment what happened to onedrive was, like okay. Fine do what you want to do so he put it in onedrive so any of the table structures inside, of the excel file I can, reach out to I can see here's a list of Microsoft Store locations. You. Sent me and I can if I have different data types here, I can turn to multi-line. Or choice if I want to. Create. The list. Because. We want to make it easier for people to get started if there's a pattern that's worked on one site we know that it's much easier to extend, that to another site and being, able to quickly stand, up something right here and I can start working with this offices list now. Some of the same capabilities, that we were adding fundamentally. For. Lists. Extend, to libraries, as well so. When I'm looking here at my document library I can add a new column type here on the fly for, location so let's do that and. So, if, I put. Let's. Call this one office and it. Says there's a type location. And I can add extra columns here. To. Keep track of address. City state country postal, coordinates. And name. Let's put all of those things in so. Now we have a location column now. We haven't put any data in it yet but. Let's, say that this flight ops excel. File if that, relates to one of our offices out there let's bring. This up in the info panel. And. So. When I enter the office location, I can, do a search and, so. Let's, do a search, for. So. This is actually, searching the locations, right. So. We can do a search here, we. Can find a location back in Massachusetts. And. When I save this. It's. Going to automatically, populate the. Rest of the information in the list by, decomposing, the actual, location, which we searched for through Bing and being, able to say here's a street address city state zip the. Geo coordinates in the name of what you can find at that location so, we're able to do much, more transformative. Things here inside of libraries. And lists than we could do before if you, were with us at the SharePoint, conference, in May we. Started showing lots of the things about the future of lists and we're, really excited about being able to start shipping these things this fall, excellent. That that was really cool I like, the excellent stuff that you get. Switchback. So. Where we are in our, rollout of lists fundamentally. SharePoint, lists are a great, home for your business data they're secure, they're easier to create than ever you, can put up to 30 million items in them and we've, introduced, capabilities. For predictive indexing, to automatically, help managing, the, volume, of data as these things scale to get bigger and bigger we, can easily, use full-text search against it and use the filters pane to drill in and find, just the selective items that you're interested in we. Can customize, those views with formatters, and with SharePoint framework.
Everything. In a list is a live update so as people are working in real time I can, see those changes, happening without having to refresh the screen and we, give you a list web part to be able to take those lists, and be able to mash them up on pages for, easy integration with other things on the page, as. We said before lists, can be built directly from Excel or from existing lists and as, I have them built I can generate, side actions around them and incorporate, those into, site designs as part of site scripting. Location. Columns we showed you again being able to plug, in landmarks. Street addresses or even office even, office, conference room locations, that show up in your directory and thanks, to being for business all of these things can be interpreted and added, to enrich the data that you have inside of your list with location, information. Something. Else that we have the capability, of is now we can easily add lists, into teams, so. SharePoint. Sits as the center of all that business data inside office 365, and, we know more and more people are using teams, to, help change the way work gets done at the team level by. Being able to take those chat centric workspaces with channels you can easily add, any lists without, cutting and pasting by, browsing for, what's available for pages and lists and directly add them as a list to any channel in any team that way we can have a unified, place inside SharePoint, to be able to centralize data pages, and applications, and simply, distribute, it to the rest of office 365. We. Mentioned predictive indexing just a quick update on where we are it's predictive indexing. Predictive. Indexing, was, introduced, last year as capability, to automatically, administer, large lists, as they grow by, activating, indexing, between, 2,000. And 20,000, items one. Of the things that we've done recently. And we'll, be rolling out this fall is the ability to add an index to any list of any size across. Any field types so, that there really are no constraints - to. Prevent you from putting, the largest, data sizes into SharePoint, up to 30 million items in a list there's. Still some more work we need to do to get that API, level, support to, not run into some of those legacy, throttles that are out there but we feel very good about what's. Coming up with that. Conditional. Formatting this, is something I want to spend just a little bit of time talking about before I show you so in conditional, formatting, is based. On the same frameworks we introduced last year, for, column formatting, column. Formatting, is based on the idea of using JSON, scripts, to be able to add. Interactivity. Little. Mini charts, conditional. Display of values and it's, great for people who are familiar with JSON, and. It's great for people who can navigate our github repository where, we in the community contribute. To scripts that you can download and use to add visual. Richness, to. Your list experiences, but, we know that it's not for everyone so we've introduced, conditional. Formatting to help bring some of that interactivity. To life so let's take a quick look at what conditional, formatting means. Thank. You. So, just very quickly sorry, let's get to equipment. Defects. So. This, is the SharePoint, library that's caching the data that we were using earlier as part, of the opening power apps demonstration. I've. Already taken advantage of some of that new formatting, right here on the, modified date so. What, I can do is any time I want to format this column I can, do it directly here and. It. Is going to look for some make. Some suggestions, about what, to do here and I can change these dates and say, if the modified date was before, the 18th pick.
A Different color. And. Say. If it's after the present day. Let's. Make it gray. Of. Course a modified date would never be after the present day unless we're working on a time machine project but, this, is the way that we're introducing column formatting, to make it easier than ever for you to be able to. Build. These kinds, of experiences, without having to resort to scripting. And. Lastly. View formatting, so, view formatting, is a capability, we just, started rolling out it takes the same idea, being able to use scripting. Formats, for columns and extend it to an entire view, some. Of the reasons why we might be able to work on this are being able to do conditional, formatting or being, able to add, multi-line. Displays, to break through some of those single, line constraints, we've all grown accustomed, to we. Can add interactivity. In the form of buttons it's definitely chalks. I know you're gonna be showing that here in exactly a little bit and, the. End result can be a completely, immersive single. Page experience, that, takes you into realms, where people look at it and say I didn't, know this was sharepoint anymore and to. Be clear whatever. You have in the column formatter is pretty, much extending. That scenario, to. Map to a row levels if you are looking at formatting, a field, in that row it's nothing, other. Than a column formatter already so whatever you have learnt on or whatever. You have expert the JSON expertise, that you got through the column formatting it applies, to the view formatting, as well great. Yep. So let's go to the next section. I guess, my time wasn't gonna be cooler than yours Chris is. It you. Think so I think so. So. As. As. We have you, know gone. Through this before we. Use flow extensively, in SharePoint, and we. Are using it to automate, everything inside. SharePoint, use it as the automation tool for Microsoft. And for users as well what. That means is we are able to give you several. Solutions, and business processes built, using flow as well, as enable, you to build, your own stuff using flow to automate, the things. So. I'm gonna start off with something, called hub sites how many of you use hub sites. Yep. Chris Lau's outside, love hub sites yeah so we. Have a hub site called, research. And development. And Chris. And I are part of another, team called research and Finance along. With that airline site that you saw we, are part of different teams and, we. Want this site, to be associated, with the research and development but. With, the recent update that we release Patti just set up something up with that hub site she. Was fed up with all the, sites, that are joining and polluting, her heart like she's like no, everybody, sees this hub everybody is able to join I need, some tool from Microsoft, to help me manage. That so, we worked, with paddy and we came up with this thing called hub join approvals, so, now. Here's paddy. So. This is the hub she's the hub site owner and if, you look at her hub site settings now, she has, configured, an, approval. Workflow, for. This, particular hub site so you can see here so, it requires, an approval, whenever, someone. Is trying, to join the site so. What, this behind-the-scenes. Let's, go a little bit later but, now you, know I want to join the hub site so let me go into my site information. So. I should be able to see the option oh there it is I'm. Going to choose research, and development that's the hub site and, immediately, get a message saying, that an approval, is. Before. Your site gets connected so now. It's not going. To happen until, patty. Goes, and confirms, that request, so, I'm gonna click Save let's see what happens. And. I'm gonna get a flow. Panel, which is basically it's running the flow. And. Probably. I'm gonna just refresh and do it again. Here's. Research, and development, click. Save. And. That's going to come up with the flow, and. Then it's gonna ask me a message so I'm gonna say, this. Is the. R&D. Side for. Research and, then. I'm going to submit so this is going to submit a request to, the hub, site owner or the hub site approvers for where the flow is set up to and if.
I Go to Patty. And wait. For a, few. Seconds. I'm. Gonna see an email. Come, up. Hopefully. Sooner. There. It is, there. It is so, that's the email that says here's, an approval to connect the research, finance to research and development so. Patti. Knows the site oh yeah I know the site I know you know Nestor it's all fine so, I'm just going to click, approve and submit, so. That's pretty much did. The magic so no paddy, was able to do that in her email, you know she also can interact, with flow just to be fair on, a mobile device on, Apple watch on, an Apple watch or through, the flow approval Center yes right so, she's got every. Possible, way to interact with this approval and manage, what to do with that so, now when I go refresh, the side you. Should see the new hub site team and hub side navigation applied, to this particular, site that got connection so if I had if paddy had rejected my request, then. I wouldn't see this now. So, this is the hub Jain approval, we're, showing it to you today will be we'll. Be releasing it soon to, targeted, release and first release tenants but, if you go behind-the-scenes. Over. Here. There. Was the flow right so if I click this it actually is going to take me to the flow side and then. I can edit this flow so as a hub. Site owner and someone. That knows in and out about the business process, in my organization. I can. Edit this flow at all, the necessary business process, I want to this element and make, it my organization. Specific, so you're not limited to just, what, we give you if you want to change this to a parallel, approval, or multistage, approval, or do, some automation based, on the manager, you know you want to change approvers, you can do those things as well so all, the tools is basically. Here for you to go do it we know that approvals, is a hot topic when. I speak to customers about this they, ask well what happens if no one approves this after seven days and their choice is entirely up to yours you, can put a taught injector timer here and say after seven days routed.
To Someone else after, seven days consider, it automatically, approved after, seven days consider, it automatically, rejected. We're. Not making a prescription, around that but obviously in your different business, governance around this you may have different reasons why one thing should be automatically. Enabled or something should be automatically, rejected, right and, Thursday. 12:30. I'm doing a talk and we're, going deep to you know how you do all of the approval options that Chris was talking about so if you're interested and then do, come to my session to know more about how, to work with all of these flows so. That's pretty cool so now our site is connected, up to the hub side and then. Remember. About the content. Approvals, and the. Stuff that we were talking about last absolutely, yeah so I worked, around that for some few. Things with flow and I was able to achieve a really good scenario. That, I'm gonna demo here today so, we have this proposals, library, where you. Know every, the content approval is enabled, in this library that means that there's a document life cycle and, document, goes into draft and then it goes to pending and then it goes to approve so there is someone that can, approve, the changes that you put in the document library and, make sure that the. Documents, are approved for whatever the business process, you have so, here you can see I have something called document, status and I have like few. Active. And then archived. And then, pending, for archive right. So, and you can see here I've applied the column formatter so. In the approval status column I actually see some it for approval and sent. To archive I see not ready and you can see that similarly. Some documents, are approved and they're ready to go to archive and here. There's archive, document, and it's a URL pointing. To a document, and then, there are some documents pending, archive. Right, so, this is the, scenario. I have here where people come and submit their proposals, it needs to go through a life cycle and then everything. Happens there so. What I'm gonna do here is I'm. Done with this ad slogans, proposal. So. I'm just going to go fresh again to make sure that things are not broken and I'm, gonna click the submit for approval so.
Automatically, It brings up the flow menu so, that's the power of the. Column for matters we have integrated, action. To. Execute a flow for. The element, that you put in the column for matter, so this can be applied in the view formatter I'll quickly, show you that when we go there but, it also applies, to the column format I here so, I'm gonna say. Absolute. And. Already. And. Then. I'm going to run the approval so. This is going to go and basically. Kickstart an approval process you. Should be able to see if, i refresh the page you. Should be able to see now the document, changes from. Approval. Summit for approval to pending. Right. So. Now if I go to my email that, you just saw in. This case Nestor, submitted, it so Nestor is getting it because. He's an approver and. I, have the approval, for proposal, ad slogan that I just submitted so. Here again I get the benefit of, approving. The, approval. Request right in my email or, in my mobile or, I can click the document, have a look at it and then, now I click Submit. It's. Going to go and execute. The flow and then. Within minutes or within seconds, you're going to see the. Document, is approved, here. And apparently, someone had enabled that, this document, is ready for archive so you. Saw now I have the buttons into archive so previously I did not have it and this, is the power of column, formatters you could have all this expressions, type together in how, you represent the data to, the user and that's, very powerful right that drives the process that you want to give to your users so. Now I'm, gonna say yep sent to archive let me do that and that's, basically, is going to run another flow, that's. Going to send this document to, the archive so, let's see what happens, so I'm gonna run the flow and that's. It right, so, in. Few in few minutes you're gonna see now. What's. Gonna happen this ad slogan is gone. Right. So, there's no ad slogan and then. Hopefully, it. Comes up here in the. Archive. Section, and, what's. Happening behind the scenes is this. Document is moved to, a protected, library, called, with archives. In this particular. Site. That only few people have accessed you not everybody, and then, so, it moves the file and then it creates a shareable, link for, that file and then puts, the shareable, link over.
Here In this library so that. Even. Though I, don't. Have access to that library, I still have access to that file so here you can see it's in the pending so. If I go back I should have an approval for the. Archival. For the ad slogans, so. I'm, going to click, Submit and. Soon. This is going to move from here to. That archive section. So. It's still doing. And. So. Let's look at that particular flow I think hopefully, I can show you, if. It if it's taking longer. It's. Still running, right. This, is pretty cool so if you click on the run in flow it, actually, shows you the, current status of the flow so, here you can see it's actually working, on moving, the file right, that's pretty cool if you are working with flows to see that and. So, you can use this capability to. Help troubleshoot a flow, so. If you see that a flow has failed for whatever reason I'll show you what step exactly yep you can go in edit the flow and then resubmit, the flow against. New data or against test data to make sure that it's working exactly so it's not just for reporting but it's also for troubleshooting it's not for reporting it's for troubleshooting and you can see all my steps got executed, and now, if I go here I don't see the document, in the pending for archive I see, that here, in the archive location. With the URL, which, means that this, is now is a shareable, link that's, available to your organization, and it's. Not basically, pointing, the list item but the shared link, for that list document. Item in that library and if, you see in the flow what. We're doing here for this particular flow is that we are using the new move, file. Action. That we just released last week and that's, using the same move file and the, copy file actions, that you have in the UX in a SharePoint library to, move a file from a library, in one particular site which, you either in the same library or to a different SharePoint, site different libraries so you can use all of those so it uses that it, also uses, the content approval set, content approval status action, that we have released, last. Year to. Manage, the approval, status and. Finally. It, uses a new action called. Create, shareable. Links for a particular, file in a library so, after I move the file I create, a shareable link for, that particular, file so, that I know, the link that I need to give to my users, and then. Finally, it updates the, document. And creates a new item. In the list and, the proposal, list so people get access to that particular document. So they can again edit it right they can only see it, so. That's the. Archive. And the approval scenario. That we, just saw on the demo approval, is a separate, flow. As you, saw so that's a submit for approval it's. A very simple flow used as a Content approval status actions, to, move a document, from bending, and then start an approval process and, then if it's approved you, set the content. Approval status to approve and then basically send an email so, as you, saw flows really powerful, you can you.
Know Change it the way you want you can include all of your business process, this, was basically you, know what I showed you is how you know if you remember a record Center and archival, right worked in SharePoint, long back how many of you use record center. Yeah. So you guys are familiar with the scenario that I'm showing yep it so that's how we are using now flow to do that you can do that right, away out of the book out of the box. Let's. Get back to five. So. You. Know make, use of flow try to see the, different scenarios that you can come up with it has all of the tools you need all of the connections, you need it's, a growing list of connections flow, team was really good at you know making sure customers. Get the connections, they want to build their flows and automate things in their enterprise, so. You saw a lot of things here, basically. The ability for me to launch a flow from a list so if you go to the flow command on the command bar you could do the same thing but. You have to select a file then you go to flow so, but things like integration, into the column. Format and view formatter, you actually, get to do the things in context, you don't have to click anything you just have to go click Submit for approval and. Send you archive whatever you want to do a very powerful solution. And. Flow. Obviously, is connecting, to lots and lots and lots of services, we're. Scrolling through over 200, and since we've gotten to the end this probably should be your timer exactly. And, we have lots of templates, so if you go to Florida, Microsoft comm or go. To a SharePoint list and say create a flow you will see all of these templates available to, you that you can use to start building your flow if you're new or you know something that's a phases your needs from, the template so, along with that we also are, announcing today set, a reminder, flow so if you have a dead column, and you want to get reminded, on that, particular date column say you have documents, and the. Document, is a contract, and it has a, so you can quickly now set a reminder to say remind, me before. Three days for this particular date. Column so any, contracts, that are doing three dates you'll get an email and it'll take care of making sure that it reminds you so it's a very cool feature we'll, be releasing it out soon - after. The ignite - first. Release and worldwide, very soon, then. We have record sign-off we released in May, in shape and conference correct and this, is a real. Simple. Approval. System not going through the content approval, process, you know content approval is for governance, and you know very strict library, and file, documents. But, here request sign-off we just want to quickly send a feedback and get feedback and get approval on something you can use out-of-the-box, feature that we have called request sign-off. Content. Approvals is what we saw so now you can. With. Recent. Update you can now enable this request sign-off or the using content approval, in, your list our library so, that you can configure the things that you want to do based on your governance, process. Page. Approvals, we announced in May in SharePoint, Conference this, ties, in with enabling, approvals. For authoring. And publishing a page so whenever an author submits. This page for approval, it goes through an approval process just, like you saw the hub join and it. Basically, allows people to say, yep I want to publish this page you, know and then it publishes so we did a walkthrough of this at the ECI ECM, pre. Day session on Sunday yeah we're also going to be doing a demo of this in my, content, services session with Dan Cogan tomorrow, morning at 9:00 a.m. so if that's the topic of interest to you hope we can see you there exactly. Shameless. Plug yep. We, all do that Chris yes hub. China approvals so that's another big thing that we are announcing today and you saw the demo, we.
Are Still doing some legal polish, and then we will be releasing it soon but, it's pretty cool this actually works you know both of these scenarios all, of the things you're seeing here is tightly, integrated into the SharePoint UX, so we want to give you that seamless experience, if you're in SharePoint, you get everything in SharePoint go, to go, do the things you want to do and, finally, this is something really cool. Permissions. If you how, many of you have created a flow. Pretty. Good, how, many have tried sharing the floor with others so they get to use, that flow. Okay. How. Do you guys do it did you guys go to flow website and added. People and you, know users to that so, many. People that's a hard thing to do if you know flow and all of those stuff yeah sure you know I can go do that but we wanted to make it simple especially, for flows associated, with lists and libraries so, now you can go to the flow side and what. We have enabled is the SharePoint, permission, so if we go to the SharePoint, tab if it's you know managing, your owners or managing, the randomly users you, get a tab called SharePoint, and in there it gives, you the SharePoint, sites that are available in, your flow so, you can select that and then, choose the list or library that, you want that flow to be able. To use, us to be able to use that flow so. You, can see here I have a site and then a library and as soon as I add that and save it everybody. Else will, get that ability, for, were part of the SharePoint list so it's a pretty easy way to do that today, you have to go still go to the flow site very soon we, are working to make sure that this applies when you create a flow from. The list or library and. This. Is just a recap we have seen a lot so. Basically what. Here, the story is that we are doing a lot of integration. Into the SharePoint so. That we can automate things not, for just us but also for help organizations. Automate, all of the business processes you have so. Set a reminder record, sign of content approvals, they're all good but, what about none, of these works for you and you want scratch, we. Do have all of the ability for you to go to flow site and create, your own, flow. By template, or from scratch so, with that so. And now if you're going to build stuff from scratch, you. Need to be able to take advantage of, custom, actions exactly. So SharePoint, connectors, if you go to flow and say I want to connect the SharePoint we have lots of actions, like create item create file upload, file we, showed you about few, other things so, what. Are the new things coming up for, this ignite is. Support. For multi value columns, in the actions if we have a owner. Field or any, other field that actually, supports. Multi value in SharePoint we. Now bring that back and you're able to use that in the flow in that specific action. If that field supports, multi value hub. Join action, so with, the hub join approval feature you also get the hub join actions and this is where you, know we. Talk about what, Microsoft, uses is what customers get right so we want to use it and you get the action so you can go use it whether, with the approvals, or without the approvals, so. That's the hub join actions, we, also have new and improved file copy actions so we got feedback many. Customers wanted the ability to copy and move files in their flow especially for scenarios that you saw so, we are we are releasing those actions, they're already available in the in. Your flow side if you want to go use it today create. Shareable, links for files so you can do that today and then.
If, You haven't noticed a few months back we also released the ability for you to bring back the columns, based on the view so. If you have hundred, columns and your view only has five why, do you want to bring all of those hundred columns you can limit the columns. That you bring back in flow by, telling. What view it should focus on to get the items back so that's pretty cool update if you're working, with large lists and you know really, large columns. List in the SharePoint, and. Of course we. Know that you. Know we. Have to release a lot of actions, you know customers, give us requests, all the time and, you. Know truth, is we can't be as fast as we want to be because there's always things, that come up so in, that regard we released, an action. Called send HTTP, request. To SharePoint, it's a very powerful. Action. It, enables, you as a flow, owner. To. Use REST. API in, SharePoint, and directly. Talk, with the SharePoint site that you're using in your flow this, has enabled a lot of scenarios. Chris was asking about the item level permissions that he wanted to do on these proposals yes, I didn't, do it. Even, though he did the power app app, for me yes card, I didn't do it I. Didn't, get time really so, basically I could have done, in a way that once the document, is approved I could have said item level permissions on that to say well, this document, now should be available, to these specific users, no other user can read or sorry, edit or change anything so, I could use this synergy, TP request action and the. Item level permission, rest api is to do that so that's one of the option if you want to check in check out. We, don't have it yet we, have it in a backlog we understand that but, you can use the risk api's today to do that so this action enables you to unblock, yourself, and. Do all the things you want to do and flow back to. Chris yes. So. Flow. Gives us tremendous, ability to, tap into the power of the cloud for, automation and SharePoint, and beyond sometimes. We need to create something that's even more immersive and so, the application. Journey for us begins. With Microsoft, Forms Microsoft. For ones was released over two years ago originally. As a tool for the education, market to deal with quizzes, and tests, and it's, a great tool in the commercial, realm as well for, being able to build surveys, or data gathering at Microsoft, we use Microsoft, forums a lot for, things like event registration. Forms. Allows me to take to, build a quick. Survey. Or form someone's gonna fill out for, registrations, and I can share it with my organization I, can, also share it anonymously, so, thinking. Back to the example, I was mentioning earlier today. About my sister it gives her the ability or the ability to be able to gather information.
Send. A link out to parents. In her class they can fill it out it is stored securely in a cloud service where, the data can be analyzed, with Excel you. Can also attach forums, to, office 365 groups, and so, I can. Automatically. Use webparts. To be able to add that form view to any SharePoint, site that I have I can, add the web part to either allow me to gather data or to give me a chart about what responses, have come back and coming soon we'll be adding the ability for you to upload files for. Named users and then for anonymous users through, Microsoft forums back, to my SharePoint libraries, and onedrive sites. Power. Apps is our essential tool for being able to quickly build, applications. That plug into all of the, data sources we mentioned with flow of or we. Can build processes, without code we can build forms inside SharePoint, we, can take advantage of the ease of introducing, them to SharePoint pages, by being able to extend those, applications. Into places like Microsoft, teams. Since. This is principally, a SharePoint session one, of the biggest places where we bring the forms forward is by tying them to lists. This. Is something that Kareem and I were. Upstairs, last year demonstrating. Being able to build custom forms against the SharePoint list it's, a built-in way to be able to take a browser form and come. Up with something either like a simple, edit or a completely, immersive experience, that can bring in other data as part, of the of, the SharePoint landscape it. Allows me to bring data in from other data sources into SharePoint, without having to run through a data migration and coming. Soon for custom forms we're gonna be adding support for document, libraries later this fall and. Also giving you the ability to have custom forums be displayed, from inside the SharePoint, mobile application, as you're browsing lists and libraries there, I. Also. Have a power apps web part at my disposal so, I may build an app like the one that we used at the outset of today's session and be able to directly embed it into any SharePoint. Page without, needing to move the underlying data source if. My data is already in SharePoint, it's simple, but in many cases people, are building applications, that. Tie to data sources that live outside of office 365, and by, being able to use the power apps web part I can, embed, those experiences. Directly, into, someone's office 365. Productivity. Session without, having to deal with moving the data from, a back-end system whether it's in dynamics, or Salesforce or Twilio or any of the other dozens of things that, we connect to um. A. Session. That we'll be doing later this week with Kathy do is talking, about our new ability, to be able to set up dynamic, data connections, between, different, webparts, on the same page. We, know that this allows us to be able to do things like filter. A file, viewer with, the contents of a library or lists and being. Able to embed. Those things in pages, that can then use throughout, all of office 365 a, little. Quick, journey about apps I want to actually, save, a little bit of time for, demo so we can talk about some of the things that I showed at the beginning taking, advantage of some of the cloud cognitive, services so.
Let Me jump back to my machine here. Okay. So. A couple of quick tips first. How, many of you consider yourselves, not. C-sharp. Developers. Not. C-sharp, developers, I see a lot of hands great, I'm gonna be able to give you something that you can put on your resume to, claim that you're a c-sharp, developer, I'm not trying to see just as what Chris did just, like I did I'm not saying you're going to be a great developer, but, you'll be able to work with it so there, are two tricks that we used inside, of the power app one, is how do I convert. The, power, apps file, format, into something that SharePoint, can use as, you can see this is the library where the image that I dropped in about, an hour ago landed, on power. Apps uses a slightly different file, format. The, way that this gets ditched off is is inside, of flow. So, if I'm looking at the per at the flows there there. Is an ability inside power apps to automatically, send a file or data that lives inside of power apps to, a SharePoint environment. This. Comes from template, the first action, here is set up for me automatically, the, create file is. Set up it asks me to browse for where it's going to go in the path but, there's a little bit of a challenge as to how do I get the file out, power. Apps in SharePoint use slightly different file. Conversions, so to do this I added, a custom HTTP. Action here it's based on Azure functions. When. You take a look at the deck and I'll have a slide here on this in just a couple seconds, gianlu. Who's the SharePoint MVP has. Published, a guide to exactly, what you need to paste into that. Capability. Essentially. Behind the scenes I have, a custom Azure function and, I. Can come here and take a look and see at, exactly what's happening inside my app service. And. If. I go to portal, - or com you. Can sign up for a free account. And the. Amount of credits you get with those free trial accounts, is plenty, to be able to handle these image conversions, it's, a matter of coming here and saying that there's a wizard to help me set up what, my new Azure function, is going to be and. Essentially. All you need to do to be your to write your first c-sharp. Function, is take. The example, that we provide in the deck and cut, and paste it in here that's all you have to do it will handle the conversion, and return. From that function something, I can then consume, into SharePoint, so that's the first tip for, how this information, came together. Okay. The second piece of flow that I'm using so once the file let me leave, this I don't know if I made any changes. So. Once, the file lands in this library we, then want to pass it into a custom, cloud service, and so. Being able to build a custom cloud service, is taking. Advantage of a. Website, that we run that's connected to Azure called custom vision AI so. If I'm looking at what's available here. Custom. Vision AI again. You can sign up for a free trial account and you, can set up up to two projects, and so, I built a classification, project. Here, building. A cloud cognitive. Model is a relatively. Simple action, for, this to be able to work I need to be able to add images and tag. Them and you can see I have already built. Uploaded. Images, of, drink. Carts of. Overhead. Bins and. Seats. So. What I can do with this is I can do a quick test I can. Say I want to browse for a local file. And so I can find a picture of an airline car that I already have and it's. Going to process it and it's going to say it is 98%, certain, based on what I already have. Take an image that is. Brand new this is an image I took a couple days ago arriving in Orlando so I'm going to test.
An Image here right now so. Let, me come back here. So. It is pulling file - in onedrive. Files on demand I guess onedrive files in demand and. I'm, being very demanding it's a one gig file a one Meg file. Being. In the Wi-Fi. Wow. There. We go and thinks. About it and it's not too sure, in. The real world once we build a model we need to be able to go back in and train, it over time so, I know the. Human interaction, with the cloud model this, obviously, has a baggage cart in it and I want to teach since, the model, doesn't know how to recognize this, I want, to make the model smarter so I'm able to come in here right now and say I want to add a new image to this. So. Here I'm gonna grab the image that I just have it's, going to tag it it's going to upload it it's going to ask me what tag do I want to put on it and say, it's a baggage cart we, upload it. So. Now we have a new image of baggage. Carts. We. Click train and. Cognitive. Services is going to think, about all of the images that I've uploaded in, there it's going to spend a little while. Probably, 30, to 45 seconds, looking, at all of the things that are there and it comes back and it's it. Thinks that it's got about 94%, accuracy, a quick, tip about building image recognition cognitive. Services models, first, and foremost we, out of the box give you inside, of SharePoint and, onedrive libraries. Some, native, object recognition capabilities. And there's some of the most commonly, recognized things that are out there things. Like receipts, or whiteboards, is this outdoors, is it a city or they're people in it or their science there's, about 35 items we will automatically, recognize and, tag, at a custom, column that lives inside of inside of the library so, you can use it to enrich search this. Is when there's something that you want to teach the cloud to recognize, that it is already doing so. To. Be able to build. A really good model is based on your understanding of what is normal, shocks, what is what does it mean for something to be normal, that. Works well. That's. True but also statistically you. Want to make sure you have at least 30 to 35 examples, of each obviously. The more images, we put into the cloud and more as we put into the model the more refined it's going to be and so the more precise it's gonna be it may just still that work yes, so, if you're trained if you upload a card right, sorry if you upload something else and clean it to be a card, right. It, would train. That way right right so the flow that I'm using behind the scenes for this we should take a look at it. For. Processing, new image. So. Happening. Behind the scenes to flow that Ryan asommus you send the image from the app right, so. The the file lens. Is converted, in lands in SharePoint which, automatically, triggers this flow when a file is created get, get properties, of the file get. The content of the file which means getting the handle to the identifier, and there's. A custom action that we supply called predict tags from image it, requires me to be able to go in and look up the project, ID. That. Is. This. Thingy here this project, ID. We. Plug it in I have. Set up two variables, to be able to walk through and figure, out because, it may recognize, lots of things in the model so it's going to put a score for each and, it's gonna walk through all of the tags that it sees and I'm interested in anything that's greater than 60% likelihood, if, the best tag I have is greater than 60 percent likelihood, I'm, gonna update the file properties and. I build a simple switch statement, here to. Decide how do I route someone to a different web page based on what we saw in the model right on a practical, basis I also overtime want, to come back in here and take, a look at.
What's. Coming in so, you can see I'm writing properties, back to the file in addition in, addition to sending a live, feed through, the alert I'm, writing back what tag it was found and what the confidence interval was that was out there. That's, really important to take a look at from time to time because if you see lots of things that aren't detected. You have an opportunity, to refine your models so, quick. Tip about how to bring some of those best cognitive, services forward, for you, so. I sort of a tube flows involved one is to. Convert. The image, that you get in power to. The image format, that we want in the SharePoint, library, right and the, second flow was once an item is added to that library, from. The power app yep, with the right file content, correct, and then, we can grab that and, send it to cognitive, services to, go find out whether it's a card or it's a baggage or whatever, that we have trained the system right excellent. And then and the results. Are only as good as the model we put in there full. Disclosure when I was built this if you were at ronmark aids which is keynote. Session yesterday this is essentially. The same demo that we built for in there I was. Having an awful lot of fun I'm setting the confidence interval down to 5% so. My girlfriend's dog was a baggage cart and my shoe is a baggage car and my car was a baggage cart, obviously. You'll. Have to do some experimentation, to get to the right data intervals, based on what your business my photo is said Nunda dick tips so that the, system knows me then yeah he doesn't know me yes yeah, yes, your, name is not sure exactly. Okay a little. Idiocracy reference, there um. So. We give you lots of cognitive services from the cloud to, be able to do more and more things with business process, I'm. Briefly. Mentioned before the things that we do for you. Automatically. We, are able to look inside of images and look for OCR we look for location, codes and pictures and if we if we recognize objects, in it we tagged them you can also add your own we're, also now with files being able to do key points extraction. Something, that we showed yesterday in, the keynote something. That we'll, touch on in the ECM session tomorrow morning on being, able to use, text, analytics to figure out what's happening inside of those files. For. Things for text data that are automatically, wired up inside flow for cognitive services sentiment. Translation. Moderation. So-called, nasty or bad words and key, phrases that you may see a document, finally. Auto transcription. And this has been a big investment area and a big announcement area for us over the past month stream. Already has the ability to do automatic, transcription, but as we introduced, several weeks ago the. Onedrive blog we're now adding the ability for you to be able to do transcription. Against. Audio, and video files when they're uploaded, to onedrive and SharePoint and of course in the same way that we're looking at image tagging, you can go in and edit those transcripts, over time to, help the cloud get smarter. Other. Services, that are, really. Helpful to bring down from the cloud power bi, there. Are some great sessions happening later in the week about power bi. You. Can integrate power bi directly, to your SharePoint sites with. The power bi web part we've, all we've been rolling out the ability for you to be able to build power bi reports, directly, against, excel files or CSV, files when, they're stored inside SharePoint, libraries, and we're.
Working Soon at giving you the ability to do those directly against SharePoint lists as well um. For. Those of you keeping score at home this, is the c-sharp, that, you need to paste into a custom function to, turn yourselves into a c-sharp developer, so a little, gift from us to help you polish your resumes and say, that you know yes I did learn something at ignite this week what, probably ten lines. It's. Cut and paste I didn't write any of it I could have you. Know good. Artists borrow great, artists steal and terrible artist