Data Connections
In this chapter, we are going to cover different data connections that you can use when connecting to your Power App. Power Apps allows you to create a seamless connection to a wide array of data sources. Whether it’s a simple task-tracking app leveraging data from Excel stored in OneDrive, a customer engagement app drawing on Dynamics 365, or a complex project management tool integrated with SQL Server, data connections are the lifelines that infuse apps with power and purpose.
This chapter will explore three of the more popular data sources that Power Apps can connect to – Excel, SharePoint, and Dataverse. We’ll cover the details of each connection type, offering insights into their unique characteristics, advantages, and considerations. We will also touch on other data connections.
Specifically, we are going to cover the following topics:
- Using Excel as a data source
- Using SharePoint Lists as a data source
- Using Dataverse...