SharePoint

Connect to a SharePoint site to generate an app automatically from a list, build an app from scratch, or update an existing app.

Known issues

You can add data from a custom list but not a library. In addition, not all types of columns are supported, and not all types of columns support all types of cards.

Column type Support Default cards
Single line of text Yes View text
Multiple lines of text Yes View text
Choice Yes (single values only) View lookup
Number Yes View percentage
View rating
View text
Currency Yes View percentage
View rating
View text
Date and Time Yes View text
Lookup Yes (single values only) View lookup
Edit lookup
Boolean (Yes/No) Yes View text
View toggle
Person or Group Yes (single values only) View lookup
Edit lookup
Hyperlink Yes View URL
View text
Picture Yes (read-only) View image
View text
Calculated Yes (read-only)
Task Outcome No
External data No
Managed Metadata Yes (read-only)
Rating No

Moreover, PowerApps doesn't support columns that support multiple values or selections.

  • For Lookup columns, the Allow multiple values checkbox must be cleared.

    Check box to allow multiple values in a Lookup column

  • For Managed Metadata columns, the Allow multiple values checkbox must be cleared.

    Check box to allow multiple values in a Managed Metadata column

  • For Person or Group columns, the No option under Allow multiple selections must be selected.

    Options to allow multiple selections for a Person or Group column

  • For Choice columns, the Drop-Down Menu or Radio Buttons option under Display choices using must be selected.

    Options to display choices for a Choice column

Prerequisites

Open PowerApps by taking either of these steps:

Create an app

Add a SharePoint list to an existing app

  1. In PowerApps Studio, open the app that you want to update.

  2. In the right-hand pane, click or tap the Data sources tab, and then click or tap Add data source.

    If the right-hand pane doesn't show a Data sources tab, click or tap any screen in the left navigation bar.

    Add data source

  3. Click or tap New connection, click or tap SharePoint, and then click or tap Connect.

    Add SharePoint connection

  4. Specify the type of SharePoint site to which you want to connect:

    Specify type of connection

    • Click or tap Connect directly (cloud services) to connect to SharePoint Online.
    • Click or tap Connect using on-premises data gateway to connect to an on-premises SharePoint site.

      Specify Windows as the authentication type, and then specify your credentials. (If your credentials include a domain name, specify it as domain\alias.)

      Specify credentials

      Note: 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.

      Under Choose a gateway, click or tap the gateway that you want to use.

      Choose gateway

  5. Click or tap Connect.

  6. Under Connect to a SharePoint site, click or tap an entry in the Recent sites list (or type or paste the URL for the site that you want to use), and then click or tap Go.

    Select a SharePoint site

  7. Under Choose a list, select the check box for one or more tables that you want to use, and then click or tap Connect:

    Select the tables in SharePoint

    The data sources are added to your app.

    List of data sources added to the app

Show data in a gallery

To show data from any of these types of columns in a gallery, use the formula bar to set the Text property of one or more Text box controls in that gallery:

  • For a Choice or Lookup column, specify ThisItem.[ColumnName].Value to show data in that column.

    For example, specify ThisItem.Location.Value if you have a Choice column named Location, and specify ThisItem.PostalCode.Value if you have a Lookup column named PostalCode.

  • For a Person or Group column, specify ThisItem.[ColumnName].DisplayName to show the display name of the user or the group.

    For example, specify ThisItem.Manager.DisplayName to show display names from a Person or Group column named Manager.

    You can also show different information about users, such as email addresses or job titles. To display a complete list of options, specify ThisItem.[ColumnName]. (with the trailing period).

    Note: For a CreatedBy column, specify ThisItem.Author.DisplayName to show the display names of users who created items in the list. For a ModifiedBy column, specify ThisItem.Editor.DisplayName to show the display names of users who changed items in the list.

  • For a Managed Metadata column, specify ThisItem.[ColumnName].Label to show data in that column.

    For example, specify ThisItem.Languages.Label if you have a Managed Metadata column named Languages.

Next steps