In PowerApps, add a connection in an existing app or an app that you're building from scratch. Connect to SharePoint, Salesforce, OneDrive, or another data source, and then display and manage data in that source from 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 SQL Server, and update a table from your app.

You can add a connection in PowerApps, as this topic describes, or on powerapps.com, as Manage connections describes.

Prerequisites

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

Add a connection

  1. Click or tap New on the File menu (near the left edge).

    New option on the File menu

  2. On the Blank app tile, click or tap Phone layout .

    Create an app from scratch

  3. Near the lower-right corner, click or tap Data sources to open the Data sources tab of the right-hand pane.

    Open data sources tab

    Note: If you're updating an existing app and the right-hand pane doesn't show the Data sources tab, select any screen by clicking or tapping it in the left navigation bar.

  4. In the Data sources tab, click or tap Add data source.

    Add data source

  5. To use an existing connection, click or tap it to add it to the app.

    You can use that connection without performing additional steps.

  6. To create a connection, follow these steps:

    1. Click or tap Add connection to display a list of connectors.

      Add connection

    2. Scroll through the list of connectors until the type of connection that you want to create appears (for example, Office 365 Outlook), and then click or tap it.

      Choose connection

    3. Click or tap Connect to both create the connection and add it to your app.

      Connect button

    Some connectors, such as Microsoft Translator, 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.

Next steps