In this video you make a data connection between PowerApps and SharePoint Online.
- We're here on our Office 365 home page and I'm very excited because we are going to begin the process of creating our very first PowerApp. You'll see here on our home page, we have this big PowerApps link. Now if it's not there don't panic. You can go up here to the upper left onto the app launcher. It kind of looks like a waffle icon there. We'll click on that and you see down here where it says all apps, we can click there. And you should find PowerApps here.
But whether you click on it here or whether you click on it here, it's gonna take you to the same place, the PowerApps home page, where we're going to see on the left more links to more places here in PowerApps. This PowerApp that we're going to create is going to connect to a SharePoint list. And I have that open here already. If you are following along and doing this exercise on your own, I have included an Excel file called Intern List, with the top 12 interns from this SharePoint list.
You're gonna have to manually add them to a new SharePoint list, or, if you know how, you can import them as a list to SharePoint. Let me scroll over here. You'll see there's a list of names. Names of college students that we have selected to be interns at our company, at Landon Hotel. If we go to the top, let's go back up here. You'll see that we have columns for their first name, last name, the school they attend, their major, their email address and phone number.
If I scroll over here to the left you'll see that I have a column for department, start date and end date. But I only have data for those three columns here in the first row. And I actually just put those there as a visual reference for us when we start working with the app. The rest of this is empty because that's what the app is for. We're gonna push this app out to all the managers and they are going to go look through the list, decide who they want to be an intern in their department, then in the app, they'll list their department, and they will select a start and end date for the intern.
Once they save it, it'll all be written back to this SharePoint list right here. So let's go ahead and let's go to PowerApps again, we'll go to our PowerApps home page because the first thing we need to do is now make a connection between PowerApps and SharePoint. And to do that we're gonna click over here on data and it opens up and gives us some more options and we're gonna click on connections. Once we do that, we see the different connections that already exist here and none of these are the ones that we want.
We don't have a connection to SharePoint. We need to go up here to the top, you'll see where it says new connection. We're gonna click that and it opens up the new connections page. And there are a lot of different types of connections in here. You can see them all and they're continuously adding more and we can scroll through here and find what we're looking for but rather than doing that, we're gonna go up to the top, the top right here and click in the search field and start to type out SharePoint.
Look at that, I don't even have to finish typing SharePoint and that connector comes up, that SharePoint connection. You'll see when I hover over it, it gets highlighted there. All I have to do is click on it and it's going to start to connect to SharePoint. Now this window tells us that we can connect to SharePoint online or to an on-premises SharePoint farm. You can see the two options there. Now we are going to connect to SharePoint online, that's what we're using.
So we're going to leave it at the default, connect directly cloud services. If we wanted to go to an on-prem, we would click there. But we're gonna go on select create. It's gonna open up this window which is going to ask us to essentially sign in, pick the account we want to use. And we are signed in today as Harold Wandaleere. There is our new connection to SharePoint. So we're ready to go. We have creates this connection between that SharePoint list and PowerApps.
The next thing we're gonna have to do is connect to that specific list and create our app.
- What can you do with PowerApps?
- Data connections for PowerApps
- Creating an app using data from a SharePoint list
- Creating an app from an Excel workbook
- Using templates to create apps
- Creating an app for Microsoft Dynamics
- Creating an app for Salesforce