Create a canvas app in Power Apps from a SharePoint list
In this topic, you'll use Power Apps to create a canvas app based on items in a SharePoint list. You can create the app from within Power Apps or SharePoint Online. From within Power Apps, you can create the app based on a list in an on-premises SharePoint site if you connect to it through a data gateway.
The app that you create will contain three screens:
- In the browse screen, you can scroll through all items in the list.
- In the details screen, you can show all information about a single item in the list.
- In the edit screen, you can create an item or update information about an existing item.
You can apply the concepts and techniques in this topic to any list in SharePoint. To follow the steps exactly:
- In a SharePoint Online site, create a list named SimpleApp.
- In a column named Title, create entries for Vanilla, Chocolate, and Strawberry.
The principles of generating an app won't change even if you create a list that's far more complex, with many columns of various types such as text, dates, numbers, and currency.
Power Apps doesn't support all types of SharePoint data. For more information, see Known issues.
Create an app from within Power Apps
Sign in to Power Apps.
Under Make your own app, hover over Start from data, and then select Make this app.
On the SharePoint tile, select Phone layout.
With the Connect directly option selected, select Create.
Under Connect to a SharePoint site, type or paste the URL for your SharePoint Online site, and then select Go.
Include only the site URL (not the name of the list), as in this example:
Under Choose a list, select SimpleApp, and then select Connect.
After a few minutes, your app opens to the browse screen, which shows the items that you created in your list. If your list has data in more columns than just Title, the app will show that data. Near the top of the screen, a title bar shows icons for refreshing the list, sorting the list, and creating an item in the list. Under the title bar, a search box provides the option to filter the list based on text that you type or paste.
You'll probably want to make more changes before you use this app or share it with others. As a best practice, save your work so far by pressing Ctrl-S before you proceed. Give your app a name, and then select Save.
Create an app from within SharePoint Online
If you create an app of a custom list from the SharePoint Online command bar, the app appears as a view of that list. You can also run the app on an iOS or Android device, in addition to a web browser.
In SharePoint Online, open a custom list, select PowerApps on the command bar, and then select Create an app.
In the panel that appears, type a name for your app, and then select Create.
A new tab appears in your web browser that shows the app that you created based on your SharePoint list. The app appears in Power Apps Studio, where you can customize it.
(optional) Refresh the browser tab for your SharePoint list (by selecting it and then, for example, pressing F5), and then follow these steps to run or manage your app:
To run the app (in a separate browser tab), select Open.
To let others in your organization run the app, select Make this view public.
To let others to edit your app, share it with Can edit permissions.
To remove the view from SharePoint, select Remove this view.
To remove the app from Power Apps, delete the app.
Apps created from the SharePoint list currently do not show in the Power Apps Mobile.
In this topic, you created an app to manage data in a SharePoint list. As a next step, create an app from a more complex list, and then customize the app (starting with the browse screen) to better suit your needs.