CRUD operations in PowerApps using SharePoint online list

CRUD operations in PowerApps using SharePoint online list

No comments

 1,574 total views,  14 views today

In this tutorial, we will learn how to perform CRUD operations in PowerApps using SharePoint online list, in the previous article we have seen CRUD Operation in PowerApps Using Excel OneDrive.

Performing CRUD operations on the SharePoint list using PowerApps is very simple, just we need to create a list with some data filled in, then we need to create a model-driven app out of that list, looks very complicated? It is very simple, could be implemented in just 5 minutes. So, let’s get started.

As part of this demo prerequisite, we need to create a customer (or any sample list with data) list out of the customer excel file. In order to create a list on the SharePoint Online site, open your SharePoint Online site, go to the site contents, click on the List link from the “+ New” menu

Create list in modern SharePoint Online site
Create a list on the modern SharePoint Online site

In the next screen, select “From Excel”, then upload your excel file, and name the list.

Create list in SharePoint Online site from the existing excel file
Create a list in SharePoint Online site from the existing excel file

Now, select a table from the excel file to create the SharePoint list. Here in this scenario, we have only one table “Table1”, so, we are selecting “Table1”.

Select a table from the excel file to create the SharePoint list
Select a table from the excel file to create the SharePoint list

Note:

  • In order to create the SharePoint Online list from the excel data, the source excel should be in a tabular format.

Click on the Next button, and name the list, a custom SharePoint Online list will be created out of the excel file automatically.

The next step is to connect a connection to the SharePoint Online list from PowerApps.

Log in to the PowerApps environment – https://make.powerapps.com.

Click on the “SharePoint” from the start with your data section.

Create model-driven PowerApps with SharePoint connection
Create model-driven PowerApps with SharePoint connection

Now, if you are first time connecting to your SharePoint environment, you need to go through the connection establishment/authentication process between PowerApps and SharePoint Online otherwise your already created connections will be listed over here.

Then you can select your recent site or you can enter your site URL and click on the “Go” button.

Connect to a SharePoint sites from PowerApps connection
Connect to a SharePoint site from PowerApps connection

Next, choose your SharePoint online list and click on the Connect button.

Choose a SharePoint list from PowerApps connection
Choose a SharePoint list from PowerApps connection

Note:

  • In this demo, we have selected the “Contact Information” list, just to show the proof of concept.

Then, once we click on the “Connect” button, the SharePoint said list will be opened in the PowerApps designer along with the data.

SharePoint Online list is opened in PowerApps designer
SharePoint Online list is opened in PowerApps designer

Now, let’s preview this model-driven PowerApps by clicking on the play button from the top right-most corner or simply press the F5 key.

We can see that the Contact Information list has been opened as an app – this version of the app is called model-driven PowerApp (where an app is created automatically out of the source data connection).

CRUD Operation in PowerApps Using SharePoint list
CRUD Operation in PowerApps Using SharePoint list

What we can do from this model-driven PowerApp?

We can perform the CRUD operations in the SharePoint Contact Information list like Create Item, Read Item, Update Item, and Delete Item.

Summary: What we had here?

Thus, in this article, we have learned how to perform the CRUD operations in PowerApps using SharePoint online list.

See Also

You may also like the below PowerApps articles:

Buy the premium version of SharePoint Online & Office 365 administration eBook from here:


Buy SharePoint Online & Office 365 Administration eBook