In this video you prepare our Excel data to work as a data source for PowerApps.
- [Instructor] We are here in our Office 365 portal and we're ready to start creating our next Power App. But we are not gonna start here in Power Apps, we're actually going to start here in Excel because this Excel workbook is the workbook that our app is going to connect to and we have to do a few things first before we can go ahead and upload it to our Office 365 OneDrive for Business.
You'll see that our app has a header row and it says Hotel, Reviewer, Check In Date, Check Out Date, Room Type, Room, Staff, Grounds, Overall and Comments. This app is going to be a review app for shoppers, hotel shoppers who go and stay in the hotels and review them secretly. We also have a row here with some sample data. Now, what we need to do is highlight all of this data and format it as a table.
We need to do this for our Power App, so we gonna go here, we're on the Home tab and in the Style section we gonna click on Format as Table. I'm gonna choose this style here and you'll see this little window pops up and it asks where is the data for your table? It is selected, it has the range here and we see it's highlighted and we have that dashed line. Now, another important thing. You see this little checkbox here, that little checkbox needs to be checked.
My table has headers. It will let Power Apps know that the table headers are there. We gonna click OK, it has formatted our data as a table, now we have to give our table a name. We gonna go up here, we on the Design tab and in the Properties section, we will click here in Table Name and we gonna give this table the name Reviews. Now, we have a second sheet here and there are two more tables on there and we going to use these in our app as well.
We need to format both of these sets of data as tables. So, once again, I'm gonna select the first group of data, format it as a table, I'll choose the same option, again make sure that that data is selected and make sure that my table has headers is checked, click OK and I'm gonna give it a name. This is going to be Room Type. And we'll do the last one.
Format as Table, check my table has headers, choose OK and give this a name. This is simply going to be Rating. Ratings. Enter and we are good to go. Now, technically we didn't have to name the tables but it'll help us later on. We're going to save this. We can close it and we gonna go to our OneDrive for Business and we are going to upload that file.
Let's go ahead and let's click on the Upload button. Click Files, select our property reviews, choose Open. And there it is and we can open it up and take a look. Make sure it's okay, looks good, looks like the right one. So, now we are ready to go ahead and create our Power App. But now you know how to format that data as a table and upload it to OneDrive for Business.
- 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