Add data connections to canvas apps

In Power Apps, add a data connection to an existing canvas app or to an app that you're building from scratch. Your app can connect to SharePoint, Microsoft Dataverse, Salesforce, OneDrive, or many other data sources.

Your next step after this article is to display and manage data from that data source in your app, as in these examples:

  • Connect to OneDrive, and manage data in an Excel workbook in your app.
  • Connect to Twilio, and send an SMS message from your app.
  • Connect to Dataverse, and update a table from your app.
  • Connect to SQL Server, and update a table from your app.

Prerequisites

Sign up for Power Apps, and then sign in by providing the same credentials that you used to sign up.

Add data source

  1. Create a blank canvas app.

  2. From the app authoring menu in Power Apps Stuido, select Data > Add data.

  3. Expand Connectors, and if the list of connections includes the one that you want, select it to add it to the app. Otherwise, skip to the next step. To connect to a table in Microsoft Dataverse instead, choose a table from the list of tables.

  4. To create a new connection, search for or select a connector such as SharePoint.

  5. Select Add a connection to both create the connection and add it to your app.

    Some connectors, such as Office 365 Outlook, require no additional steps, and you can show data from them immediately. Other connectors prompt you to provide credentials, specify a particular set of data, or perform other steps. For example, SharePoint and SQL Server require additional information before you can use them. With Dataverse, you can change the environment before you select a table.

Identify or change a data source

If you're updating an app, you might need to identify or change the source of data that appears in a gallery, a form, or another control. For example, you might need to identify a data source as you update an app that someone else created or that you created long ago.

  1. Select the control, such as a gallery, for which you want to identify or change the data source.

    The name of the data source appears on the Properties tab of the right-hand pane.

  2. To show more information about the data source or to change it, select the down arrow next to its name.

    More information about the current data source appears, and you can select or create another source.

Next steps