Add a data connection to a canvas app in PowerApps

In PowerApps, 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, Common Data Service, 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 Common Data Service, and update an entity from your app.
  • Connect to SQL Server, and update a table from your app.

Prerequisites

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

Open a blank app

  1. On the Home tab, select Canvas app from blank.

  2. Specify a name for your app, and then select Create.

  3. If the Welcome to PowerApps Studio dialog box appears, select Skip.

Add data source

  1. In the center pane, select connect to data to open the Data pane.

    If this were an existing app and the screen already contained a control, select View > Data sources to open the same pane.

  2. Select Add data source.

  3. 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.

    Choose an existing connection

  4. Select New connection to display a list of connections.

    Add connection

  5. In the search bar, type or paste the first few letters of the connection you want, and then select the connection when it appears.

    Search for a connection

  6. Select Create 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 Common Data Service, you can change the environment before you select an entity.

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.

    Identify a connection

  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.

    Change a connection

Next steps