Connect to SharePoint from PowerApps
Connect to a SharePoint site to generate an app automatically from a list, build an app from scratch, or update an existing app.
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 |
|Currency||Yes||View percentage |
|Date and Time||Yes||View text|
|Lookup||Yes (single values only)||View lookup |
|Boolean (Yes/No)||Yes||View text |
|Person or Group||Yes (single values only)||View lookup |
|Hyperlink||Yes||View URL |
|Picture||Yes (read-only)||View image |
|Managed Metadata||Yes (read-only)|
Moreover, PowerApps doesn't support columns that support multiple values or selections.
For Lookup columns, the Allow multiple values checkbox must be cleared.
For Managed Metadata columns, the Allow multiple values checkbox must be cleared.
For Person or Group columns, the No option under Allow multiple selections must be selected.
For Choice columns, the Drop-Down Menu or Radio Buttons option under Display choices using must be selected.
Columns that contain spaces can by read by PowerApps, but the spaces are replaced with the hexadecimal escape code "_x0020_". For example, "Column Name" in SharePoint will appear as "Column_x0020_Name" in PowerApps when displayed in the data layout or used in a formula.
Open PowerApps by taking either of these steps:
Open PowerApps Studio for the web in a browser.
For a list of supported browsers and limitations in the preview release of PowerApps Studio for the web, see Create or edit apps in a browser.
Generate an app automatically based on data in a SharePoint list.
The app will have three screens by default: one each for browsing records, displaying details of a record, and creating or updating a record. After the app is generated, you'll probably want to customize the browse screen and the details and edit screens to suit your needs.
Note: If your SharePoint list contains a Choice, Lookup, or Person or group column, see Show data in a gallery later in this topic.
In PowerApps Studio, open the app that you want to update.
On the View tab of the ribbon, click or tap Data sources
In the right-hand pane, click or tap Add data source.
Click or tap New connection, click or tap SharePoint, and then click or tap Connect.
Specify the type of SharePoint site to which you want to connect:
- 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.)
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.
Click or tap Connect.
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.
Under Choose a list, select the check box for one or more lists that you want to use, and then click or tap Connect:
Not all types of lists appear by default. If the name of the list that you want to use doesn't appear, scroll to the bottom, and then type the name of the list in the box that contains Enter a custom list name.
The data sources are added to your app.
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 Label 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.