Manage your connections in PowerApps

In powerapps.com, create a connection from PowerApps to one or more data sources, delete a connection, or update its credentials.

Your app's data connection can connect to SharePoint, SQL Server, Office 365, OneDrive for Business, Salesforce, Excel, and many other data sources.

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

  • Connect to OneDrive for Business, and manage data in an Excel workbook in your app.
  • Update a list on a SharePoint site.
  • Connect to SQL Server, and update a table from your app.
  • Send email in Office 365.
  • Send a tweet.
  • Connect to Twilio, and send an SMS message from your app.

Prerequisites

  1. Sign up for PowerApps.
  2. Sign in to powerapps.com using 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 Connections.

The commonest type of data source is the table, which you can use to retrieve and store information. You can use connections 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 like OneDrive for Business, DropBox, SQL Server, etc.

There are other kinds of data sources that are not tables, such as email, calendars, twitter, and (coming soon) notifications.

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

In addition to creating and managing connections in powerapps.com, you also create connections when you do these tasks:

Note

If you want to use PowerApps Studio instead, open the File menu, and then click or tap Connections, powerapps.com opens so that you can create and manage connections there.

Create a new connection

  1. If you have not already done so, log in to powerapps.com.
  2. In the left navigation bar, click or tap Connections.

    Connections Manage

  3. In the upper-right corner, click or tap New connection.

    Connections Add

  4. Click or tap a connector in the list that appears, and then follow the prompts.

    Connections Add

  5. Click or tap the Create button.

    Connections Add

  6. Follow the prompts. Some connectors prompt you to provide credentials, specify a particular set of data, or perform other steps. Others such as Microsoft Translator, do not.

    For example, these connectors require additional information before you can use them.

The new connector appears under Connections, and you can add it to an app.

Update or delete a connection

In the list of connections, find the connection that you want to update or delete, and then click or tap the ellipsis (3-dots-symbol) on the right of the connection.

Update connection

  • To update the credentials for a connection, click or tap the key icon, and then provide credentials for that connection.
  • To delete the connection, click or tap the trash-can icon.