There are many ways to leverage data in a Power Apps Canvas App. One of the more common scenarios is that you have some data in Excel, and you want to use that data in the app.
In this hands-on tutorial, I’ll show you how to properly set up the data in Excel and then create a new Canvas App from make.powerapps.com. Once inside the app, I’ll show you two ways to connect to the Excel data: 1) Import it from the local Excel file and 2) Upload the file to OneDrive for business so you can keep the data in sync.
If you want to learn more about Power Apps Canvas Apps, I’ve partnered with the good folks at Pluralsight to do a 3-hour course. During the course, we’ll build an app from scratch, leveraging data from Dataverse. Check it out! https://pluralsight.pxf.io/LP12Jo
00:00 – Overviewing the Excel file and the completed Canvas App
00:10 – Creating the data table in Excel
01:16 – Creating a new Canvas App from make.powerapps.com
01:47 – Excel Option 1: Import Excel file from your local computer
02:36 – Adding a new List screen and gallery control to display the data from Excel
03:18 – Syncing data from an imported Excel file – it doesn’t work!
04:15 – Excel Option 2: Connect to an Excel file in the cloud (OneDrive for Business example)
05:43 – Adding a new List screen and gallery control to display the data from Excel in OneDrive for Business
06:05 – Syncing data from an Excel file in OneDrive for Business– it works!
If you want to set up a free 30-day trial of Power Apps, check out another one of my videos: https://youtu.be/9attR2JnQnU.