Connecting to data sources
Power Apps lets you build business applications that use data from line-of-business applications. Using Power Apps, you can build apps that work with local as well as connected data sources.
Connected data sources are external to Power Apps such as Excel spreadsheets, SharePoint lists, OneDrive for Business, Dropbox, and SQL Server.
Local data sources save the data in data tables within Power Apps. Collections are one such data source that gets stored within the Power App when the Power App is saved and published.
We will see how you can connect to data sources in this recipe.
Getting ready
You need Power Apps plan included in your Microsoft 365 subscription in order to build a Power App. Download the Cars.xlsx file from Chapter 14 folder in the GitHub repository of this book here https://m365book.page.link/github and save the file in your OneDrive for Business.
How to do it ...
To connect to a data source, do the following steps:
- Open the Power Apps designer...
