In PowerApps, add a data connection to an existing app or to an app that you're building from scratch. In this topic, you use PowerApps Studio, but you can also use powerapps.com, as the Manage connections topic describes.

Your app's data connection can connect to SharePoint, Salesforce, OneDrive, or one of 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 SQL Server, and update a table from your app.

Prerequisites

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

Background on data connections

Most PowerApps apps use external information called Data Sources that is stored in cloud services. A common example is a table in an Excel file stored in OneDrive for Business. Apps are able to access these data sources by using Connectors.

The most common data sources are tables, which you can use to retrieve and store information. You can use connectors to data sources to read and write data in Microsoft Excel workbooks, SharePoint lists, SQL tables, and many other formats, which can be stored in cloud services such as OneDrive for Business, DropBox, SQL Server, etc.

Data sources other than tables include email, calendars, Twitter, and notifications.

Using the Gallery, Display form, and Edit form controls, it's easy to create an app that reads and writes data from a data source. To get started, read the article Understand data forms.

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. In the right-hand pane, click or tap Add data source.

    Note: If you're updating an existing app and Add data source doesn't appear in the right-hand pane, click or tap any screen in the left navigation bar.

  4. If the list of connections includes the one that you want, click or tap it to add it to the app. Otherwise, skip to the next step.

    Add data source

  5. Click or tap New connection to display a list of connectors.

    Add connection

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

  7. Click or tap Create 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