From the course: Microsoft Power Apps Essential Training: Beyond the Basics

Create the app - PowerApps Tutorial

From the course: Microsoft Power Apps Essential Training: Beyond the Basics

Start my 1-month free trial

Create the app

- [Lecturer] Today, we're going to create an app that will connect to three different lists in SharePoint. With our app, we will be able to edit one of those lists in SharePoint. The other two lists will be more informational. Let's take a look. We're going to go to SharePoint and we're going to open up our sales site. And these are the three lists we're going to use, leads, contacts, and accounts. If we click on accounts, we see account information for our customers, the account name, status sales, all the usual information you would expect. Contacts, same thing, contact information for people at those companies. And lastly leads in this was the one we're going to work with. We're going to be able to edit leads in our app. Now let's go ahead. Let's open up a quick edit here in SharePoint, because I want you to see this column, lead strength. Notice when I click here, there is a dropdown and we can choose if this lead strength is hot, warm or cool. Now, because that dropdown is here in SharePoint, it will also carry over and will show up in our app as well. The leads list also has revenue, contact, name, phone number, email, and address information as well. All right, let's go ahead and let's go back and open up power apps and let's create our app. We're here on our power apps homepage, and we see start from data in a big button for SharePoint. We're going to click there and it's going to show us the connections that we already have. And we already have one to the SharePoint site. If you don't know how to create a connection between power apps and SharePoint, we have another movie elsewhere in this course that can help you. So we've got this connection. We see our sites, our SharePoint sites, and the one we want is sales. We're going to click there. And now we see a list of our SharePoint lists and the one we want is leads. Now, at this point, we can only connect to one list. Eventually we have to come back and connect to the other two, but we're going to select leads now because this is the one we want to edit. So we have to choose that first we click on leads and come down to the lower right and click on connect and power apps will begin to create our app. It shouldn't take too long. And there it is, there is our app. Let's go ahead and let's zoom in and it looks like it's giving us all of the information that we want. We've got the company name, the status and the revenue. And if we go ahead and preview our app, we can go the details screen. We need to do a little bit of work on this, but I'll do that offline and we can edit. But on the edit screen, notice we do indeed have our dropdown list. Just the way we saw in SharePoint. All right, give me a minute. I am going to go ahead and reorder these fields and I'll be right back. I have returned and let's go ahead and let's take a look. Let's preview our app. And if I go to our detailed screen, you'll see, I reordered the fields and I added a couple more in, and I've also added some columns and the same thing here on the edit screen, edit in a couple more fields, reordered them. And we still have our dropdown here. Now, if you don't know how to do those things, reorder this fields or add or delete them or create columns. I have movies elsewhere in this course that will show you how to do that. But now you know how to create that app that connects to a SharePoint list.

Contents