Learn with

Integrating Data From Various Sources

Data Sources

Power Apps allows you to connect to various data sources to build custom apps and automate processes. These data sources can be cloud-based or on-premises, and they can include data from Microsoft and non-Microsoft services. Here are some common data sources in Power Apps:

  1. Common Data Service (CDS): Common Data Service is a cloud-based data storage and modeling platform that is tightly integrated with Power Apps. It provides a standardized schema for your data, making it easy to build apps that work with this data.
  2. SharePoint: You can connect Power Apps to SharePoint lists and libraries to create apps that interact with SharePoint data.
  3. Excel: Power Apps can connect to Excel files stored in OneDrive for Business or SharePoint. This allows you to work with data in Excel spreadsheets.
  4. Microsoft SQL Server: You can connect to on-premises or Azure-based SQL Server databases to access and manipulate data in your Power Apps.
  5. Dynamics 365: Power Apps is integrated with Dynamics 365 applications, such as Dynamics 365 for Sales and Dynamics 365 for Customer Service, allowing you to build custom apps that interact with these platforms.
  6. Office 365: You can connect to various Office 365 services, such as Outlook, OneDrive, and Microsoft 365 users, to incorporate data from these sources into your apps.
  7. Azure services: Power Apps can integrate with Azure services like Azure SQL Database, Azure Blob Storage, and Azure Table Storage to work with data stored in the Azure cloud.
  8. Custom APIs: You can create custom connectors in Power Apps to connect to RESTful web services, allowing you to access data from any service with an exposed API.
  9. Web data sources: Power Apps supports connecting to web services, RSS feeds, and other internet-based data sources using HTTP or HTTPS connections.
  10. On-Premises data gateways: You can use the Power Apps on-premises data gateway to securely connect to data stored in on-premises databases or other data sources behind your organization's firewall.
  11. Custom data sources: Power Apps allows you to build custom connectors for proprietary or less common data sources using the Custom Connector feature.

You can leverage Dataverse without the need for establishing a dedicated connection, whereas with other data sources, it is imperative to establish a connection before accessing their data.

To use a Dataverse table in an application:

  1. Access Dataverse and ensure you have permissions.
  2. Authenticate with the Dataverse, if required.
  3. Refer to the Dataverse API documentation.
  4. Make API requests to interact with the data.
  5. Retrieve and process the data.
  6. Display or use the data in your application as needed.

Here is an illustrative example of how to seamlessly integrate a SharePoint list into your application.

In this scenario, you have established a pre-existing connection to SharePoint, which can be seamlessly utilized within your application. To access your data source, simply click on the "Add Data" option in the top menu and select the desired data source.