Create a connection to SharePoint from PowerApps

Create a connection to either SharePoint Online or on-premises SharePoint so that you can generate an app automatically or build one from scratch.

If you're unfamiliar with PowerApps, see Introduction to PowerApps.

As of this writing, PowerApps supports custom lists but not libraries. In addition, you can show data in some types of columns, such as Choice and Picture, but you can't update that data. For more information, see Known issues.

Specify a SharePoint connection

  1. If you haven't already signed up, sign up for PowerApps.

  2. Sign in to using the same credentials that you used to sign up.

  3. In the left navigation bar, click or tap Manage, and then click or tap Connections.

    New option on the File menu

  4. Near the upper-right corner, click or tap New connection.

    New connection button

  5. In the list of connections, click or tap SharePoint.

    Add SharePoint connection

  6. Follow the steps in either of these procedures, which appear later in this topic:

Connect to a SharePoint Online site

  1. Click or tap Connect directly (cloud services), and then click or tap Add connection.

    Choose SharePoint Online

  2. Go to Next steps at the end of this topic.

Connect to an on-premises SharePoint site

  1. Click or tap Connect using on-premises data gateway.

    Choose SharePoint on-premises


    Gateways and on-premises connections can only be created and used in the user's default environment.

  2. Specify your user name and your password.

    If your credentials include a domain name, specify it as Domain\Alias.

    Specify your credentials

  3. If you don't have an on-premises data gateway installed, install one, and then click or tap the icon to refresh the list of gateways.

    Install a gateway

  4. Under Choose a gateway, click or tap the gateway that you want to use, and then click or tap Add connection.

    Choose a gateway

Next steps

  • Generate an app automatically based on a list that you specify. The app will have three screens by default: one each for browsing records, displaying details about a single record, and creating or updating a record.
  • Build an app from scratch. This topic was written for Excel, but the same principles apply to SharePoint.