A workflow is an organizational process that has a clear beginning, some sequential steps, and then an end. And a workflow might sit at the very core of your business, like an order entry process or a shipping process to send products to customers, or could serve more of a supporting role, like a process that allows employees to submit a time sheet or request time off for a vacation. This workflow is a small simple workflow. It was designed to allow an employee to apply to be part of a management training program. This is one of those supporting workflows. In this workflow, the employee has an idea that they'd like to apply. And they fill out a form and submit that form to their immediate supervisor.

This is a really interesting time to be creating workflows and forms for SharePoint because we have a number of tools that have been available and then we have some new tools. Let's take a look at the world of development tools for Microsoft SharePoint. 

PowerApps Plan Two also includes support for the Common Data Service. So, if you need to have access to Plan Two, you have the ability also to do a free trial simply of Plan Two. For now, we will be working largely with the features that are included in both Plan One, and Plan Two. Finally, if you're using Office365, and you can't log in to PowerApps at all, it may be then that your organization has turned off individual sign up for Microsoft PowerApps, and if that's the case talk to your IT department, and ask for licensing for Microsoft PowerApps. You'll sign up for Flow in exactly the same way. Rather than going to powerapps.microsoft.com, you'll go to flow.microsoft.com, and you'll end up on a page like this, and it will also have a link at the top that will allow you to sign up. Notice that I'm already signed up for Microsoft Flow. This is how it works then, when you log in when you're already signed up. After you have signed up for your accounts for Flow and for PowerApps,

I've created a site just for the work that I'm doing in this course, I'm working in SharePoint Online, so this is what my site looks like. Your site might look a little bit different, but find yourself in the site that you want to use for the work that we'll be doing together. If you're already familiar with this, this is a little bit of a review, if you're not familiar with this, this is one of my favorite techniques to work with Excel and SharePoint together, because anything I can model in Excel, as a list, as a table, I can then import into SharePoint and this allows me to, very quickly, create apps where users can enter information, whether that app is going to allow them to enter in SharePoint or to enter it, in this case, in a PowerApp that we're going to create from this custom list.

 Microsoft PowerApps is a suite of Cloud-based software services that can be used to connect to many data sources, including SharePoint, which is our focus in this course. But to other services as well, all of the different types of connectors that we have for Power BI, for example, and Flow, they're all a common set of connections. Using the PowerApps services, we can create, build, publish and share applications in web settings and for mobile and it's mobile where PowerApps really shine because we can leverage the capabilities of our mobile devices, the GPS, the camera, and so on, in our PowerApps. The PowerApp components include web.powerapps.com, which we saw in the last movie.

Let's create a new PowerApp right here from the SharePoint online list. Notice that at the top in the command bar we can click PowerApps and choose Create an app. Build a custom app based on your SharePoint list using PowerApps. We are going to name our app to get started, and we're going to simply call this west inventory, and click Create. This will take a couple moments to build my app. Notice that what has opened is the web version of PowerApps studio. Which is all displayed in this second tab here in my browser. The app is being saved to my PowerApps collection and here is the first screen of my PowerApp. This is great. A quick tour to help us get started. We'll take this tour because it's a quick way to be able to understand how this interface works for the studio. First on the left we have thumbnails for the screens, and when we create a new PowerApp, by default we get three separate screens. We get a screen that's used for browsing. We see that one here. 

basics of managing and working with your apps that you've created. First, based on your organizational role and how PowerApps is set up, you might find that every app that you create is created for you privately until you share it. In my case, the PowerApps that I create are being shared automatically, and if I want them not to be shared, then I need to make them private. There's actually two different and parallel things happening here. I have a view which is, really, you could think of it as PowerApp in the browser. But the PowerApp itself is not here. The PowerApp itself lives in web.powerapps.com. 

Some additional customization we might be interested in. This is called BrowseScreen1. We have DetailScreen1 and so on. If you'd like to change the name from BrowseScreen1, you can do that. Simply on the Screen tab or on the Home tab with the screen selected, choose BrowseScreen. We could say BrowseInventory, for example. That's an internal name. It's the title here actually that bothers me because it gets cut off. It says West Region Inventory but there really isn't enough room for that in the label. I'm just going to say West Inventory, delete this. Change its name and notice, much better. I'm going to go to File and Save just to save the work I've done so far because that seems to be a good way to work in PowerApps. While I'm here though, let's take a look at the app settings. This is the West Inventory.

The choices that were made by PowerApps about what fields, what columns of data were most important was a little different than the choices that I would make because my users aren't as focused on whether something is back ordered as they are in being able to find it in order. The same problem exists here on my details screen and on my edit screen. I'd like to be able to rearrange, to reorder, the information on this screen so that name is at the top, very first. That's the most important thing. Second then, is we have information about availability and not necessarily in stock or not in stock but the quantity that are available. How do we modify this particular screen? Well, it's super easy. 

The inventory that's maintained in this list in SharePoint is calculated based on items that are removed from inventory, purchases that are added to inventory, but there is not a visual inspection of these items most of the year. However, twice a year, we take a physical count of all of the items in our inventories so that we can reconcile the number of units available with the actual number of units that are in stock. And we'd like to make it easy, we want to create a mobile app that will do that, a PowerApp. First though, we need to modify our list by adding another column to the list. Let's go to settings, list settings, and in our set of columns, there's units available, which is number. We want to create another column, in addition to units available and that column is going to be unit count or actual count or verified count or whatever we'd like that would describe it. And it's a number, semi-annual audited count.

I'd like to add the new column, then, to my details screen and to the edit screen. Let's do that then. Here are the units that are available, and what I'd like to do is I'd like to actually add another card. Simply click on any of the existing cards, scroll down to actually count. On hide it, and here it is. I'd like this right after units available. So I'm going to drag it up here. Sometimes you can catch this and drag the actual card, but I normally found it easier to drag the field here in the right pane. Now we need to allow our user to enter the actual count. Let's go here, and notice that we haven't really modified this to be in the same order, I also didn't change the name here, I should probably do that. Drop down to our details screen. 

Here's the last spiffy little thing we're going to do to this power app, and that's to apply some conditional formatting to a control. This is the type of thing that makes an app much easier for our users. I'm going to select in the gallery, the very first item, and choose the availability, because what I'd like to do is flag if these items have been back-ordered. Now, generally, the color that we have applied here to this text is orange, and I'm going to switch it back to something a little bit duller, like a dark brown, and now they are all dark brown. Now, it's hard to make red stand out from orange. What I'm going to do is choose a color, and say if, this is going to seem really familiar, almost like Excel. If availability equals back-ordered, make sense? Comma, and they're telling about the color here.

The flow is assigned to the list, and our SharePoint list doesn't really care how we add a new record, so let's add it using our PoweApp. Better yet, let's begin using PowerApps Mobile, which I've downloaded using Itunes and I'm now logging in for the first time. So I'm going to sign in with my work or school email account, the same account I used when I logged in to PowerApps. And in a moment I'll be prompted for a password. I'll sign in. I will allow notifications from PowerApps. And even though that screen came back for login, we shouldn't worry about it because here we are.

"transcript": " - [Instructor] When we added the new item to this list flow automatically ran a workflow. First let's make sure that we can find the item in this list. We can Search and 24-volt is going to find something for us. There's our K-Eco2 24-volt backup battery in stock three, that looks good. And what about that email? Well remember that the email was sent not just to Rodney but also to me, so if we switch to my inbox in Microsoft Outlook. Notice, new inventory item added. K-Eco2 24-volt backup battery, a new item was added at date and time by Gini Courter. Details item name, quantity. 

If you are using the Term Store to manage metadata, I am sure you are wondering if there are certain best practices to follow when it comes to taxonomy/metadata structure.   In this lecture I want to focus on the best practices and tips on how to make sure your Term Store does not become the Wild West of metadata. So let’s go over some tips on how to organize Metadata in the SharePoint Term Store!