Edit

Share via

Connect to SharePoint from a canvas app

  • Article

There are different ways to connect to SharePoint in a canvas app:

  • Connect to a SharePoint site to generate an app automatically from a list.
  • Create a SharePoint connection before you add data to a new or existing app.

Note

When you create or view a list in SharePoint, you're automatically redirected to Microsoft Lists. The list can always be found in both Microsoft Lists and SharePoint. Learn more in What is a list in Microsoft 365?.

Connect SharePoint to an app by creating an app

If you have a SharePoint site with a SharePoint list, you can create an app in Power Apps through the list menu in Microsoft Lists.

The Integrate > Power Apps > Create an app menu in Microsoft Lists takes you to Power Apps and builds an app using your list as a data source.

Learn more in Create a canvas app with data from Microsoft Lists.

Create a SharePoint connection

If you build a new app or have an existing app, you can connect to SharePoint through the Data menu in Power Apps.

  1. Sign in to Power Apps.

  2. Select More > Connections in the left navigation bar.

    Screenshot that shows the location of the Connections menu option in the More menu.

  3. Select + New connection and choose SharePoint. A popup appears.

  4. Choose either the cloud-services or on-premises option:

    • To connect to SharePoint Online, select Connect directly (cloud services) and then Create. Provide credentials (if prompted).

      To connect to SharePoint Online, select Connect directly (cloud services).

      The connection is created, and you can add data to an existing app or build an app from scratch.

    • To connect to an on-premises site, select Connect using on-premises data gateway.

      Choose Windows as the authentication type and add your credentials. If your credentials include a domain name, specify it as domain\alias.

      Screenshot of the popup showing how to connect using on-premises data gateway.

      Under Choose a gateway, select the gateway that you want to use, and then select Create.

      Note

      If you don't have an on-premises data gateway installed, install one, and then select the refresh icon for a list of gateways.

      The connection is created. You can add data to an existing app or build an app from scratch.

Add data to an existing app

  1. In Power Apps Studio, open the app that you want to update, select Data on the left-pane.

  2. Select Add data > Connectors > SharePoint.

    Screenshot showing the menu path to connect to SharePoint from the Data menu.

  3. A side panel opens. Under Connect to a SharePoint site, select an entry in the Recent sites list (or add your own URL), and then select Connect.

  4. Under Choose a list, select the check box for one or more lists, then select Connect:

    Screenshot that shows lists you can choose to include.

    Note

    Power Apps supports lists, not template-based lists. If you don't see your list, type the list name in Enter custom table name box. Screenshot that shows the box where you can add a list name.

    You see a confirmation banner that your data source was added to your app.