Introduction
Hello everyone, today I am going to write a blog on how to use the SharePoint list/library with PowerApps. We will learn about the SharePoint connector and how to apply and use SharePoint list data into the PowerApps interface.
We will also learn about adding, updating, and deleting data in the SharePoint list using the PowerApps interface. We can create an app either within the PowerApps or we can create it form SharePoint online itself. So, let’s start and learn how to create basic PowerApps with a SharePoint list.
First, we will create one SharePoint list in our test or development environment. I have created the list name “Asset Tracker” with 5 columns like Title, Employee Name, Desk Number, Make, Model, and CPU ServiceTag and all columns are single-line text type. Below is my SharePoint list with sample data.
Create an App from PowerApps
We need to sign into PowerApps using your login credentials. There will be a landing page where we can see all the connectors and app templates.
Here, we have to choose the Canvas app from a blank template to create a blank app.
Please provide your app name and select format Tablet or Phone. Based on the app accessibility, you can choose the format of the app layout.
We keep selecting Tablet format for this app and click on the create app button.
It will redirect it to the PowerApps Studio page and the app will be in an editable mode. Click on the SharePoint data source and it will ask for the SharePoint site URL and select the Asset Tracker list and click on the connect button.
When you connect with the SharePoint site it takes some time to build an app and gathering SharePoint Asset Tracker list data. PowerApps create an app with three different screens (Browse, Details, and Edit screen).
We can further customize this screen as per our requirements. You can see the icons on top of the browse screen where we can refresh, sorting, and add new records using + icon. Also, there is a gallery control on browse screen which by default displaying Title, Employee Name, and Desk Number. We can customize it and add more columns that we want to display.
When clicking on the arrow icon, it will redirect it to the summary page where can see all the data from the SharePoint list and can edit and delete the record as well.
Once all the changes have been done on the app, the developer can save and publish the app, and then it can be further shared with multiple users within the organization.
Under the File menu, there are so many options are available where we can manage our apps.
A developer can see all the version history of this app can also see all the details, like when the app is modified, who has modified it, and whether it is published or not and the version note, if any is mentioned.
I hope you get an idea of how to create PowerApps with a Sharepoint list. Happy Learning!