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 (read-only)||View lookup|
|Number||Yes||View percentage |
|Currency||Yes||View percentage |
|Date and Time||Yes||View text|
|Lookup||Yes (as of release 2.0.440)||View lookup |
Edit lookup (as of release 2.0.440)
|Boolean (Yes/No)||Yes||View text |
|Person or Group||Yes (as of release 2.0.440)||View lookup |
Edit lookup (as of release 2.0.440)
|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.
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.
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.
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 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 tables that you want to use, and then click or tap Connect:
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 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.