Using Excel as a data source
Excel can be a popular choice as a data source for your app due to its widespread use and familiarity. When creating a new app, creating one based on an existing Excel file is easy and there are various ways to go about this. The first and simplest approach is to create a new app by uploading an Excel file. This approach allows you to create an app with minimal to no coding or design as Power Apps does most of the work for you. Another approach is to start with a blank canvas app and then connect to Excel. We’ll cover both approaches in this section.
Creating a new Power App by uploading an Excel file
If you have an existing Excel file, Power Apps makes it very easy to quickly create a Power App with minimal coding. In this example, we will use an Excel file entitled Events Planning Data - Chapter 5.xlsx. This file is available on this book’s GitHub repository if you would like to download and follow along. A subset of the data is shown...
