Connect to a SharePoint list in PowerApps step by step

PowerApps SharePoint connection step by step

No comments

 4,368 total views,  13 views today

In this PowerApps Tutorial article, we will learn about how to connect to a SharePoint list in PowerApps using the SharePoint connection step by step. SharePoint is one of the much-used connections in PowerApps, where we can seamlessly integrate SharePoint with the PowerApps and do the data operation.

PowerApps SharePoint connection: What you will learn from this article?

  • How to design the PowerApps canvas app using form control?
  • How to work with form control in PowerApps?
  • How to connect to the SharePoint site from PowerApps step by step?
  • How to connect to the SharePoint list from PowerApps and display the data in PowerApps?
  • How to do the CRUD operation in PowerApps with the SharePoint connection?
  • How to work with SharePoint connection in PowerApps?
  • How to work with the SubmitForm function in PowerApps?

We assume that we have a SharePoint list with a few columns, then we will design the form step by step and integrate the SharePoint list, before connecting to SharePoint we design the form in PowerApps, let’s gets astarted with that.

PowerApps SharePoint connection: how to add form control in PowerApps Canvas App?

To add the form control in PowerApps Canvas App – click on the insert menu, then select the Edit or Display form from the forms selection dropdown list.

PowerApps SharePoint connection - add form control in PowerApps Canvas App
How to add form control in PowerApps Canvas App?

Then add the data source to the form.

How to connect to a SharePoint Site from the PowerApps Canvas app?

To add a SharePoint site in PowerApps, we need to follow the below steps:

Click on the “+ Add data” link.

PowerApps SharePoint connection - add data source to PowerApps Form
How to add the data source to PowerApps Form?

Then select SharePoint as the data connection.

Steps to add SharePoint data connection in PowerApps
Steps to add SharePoint data connection in PowerApps

Then select the “Connect directly (cloud services)” radio button in PowerApps

Connect directly (cloud services) in PowerApps
Connect directly (cloud services) in PowerApps

Click on the Connect button.

Then enter the Site URL in the “Enter the SharePoint URL for the location of your list” textbox or select your site from the recent sites list.

How to connect to a SharePoint Site from PowerApps Canvas app?
How to connect to a SharePoint Site from the PowerApps Canvas app?

In the next screen, you select your list/library (choose a list) along with their columns whichever you need.

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

Click on the connect button.

SharePoint data connection is added to PowerApps left sidebar menu.

SharePoint data connection is added to PowerApps left sidebar menu
SharePoint data connection is added to PowerApps left sidebar menu.

Now select your form control which you have added in the beginning.

Go to the properties tab of the form control select your SharePoint data source from the data source selection list.

Configure SharePoint list data connection in PowerApps Canvas App
Configure SharePoint list data connection in PowerApps Canvas App

Click on the Edit fields button to add or remove the field in the SharePoint data source control from the PowerApps form.

Add or remove fields in SharePoint data source from PowerApps
Add or remove fields in SharePoint data source from PowerApps

Now, select the “Submit” button, and on the “OnSelect” event write the below function:

SubmitForm(Form1)

Submit form data to SharePoint Online list from PowerApps using the SubmitForm function

Submit form data to SharePoint Online list from PowerApps using the SubmitForm function

Notes:

  • In the above SubmitForm, function form name is the parameter, here I have selected my form as “Form1”.
  • Now once we fill up the contact details and hit the submit button automatically, the contact information gets saved to SharePoint Online contact information list.
Submit PowerApps form data to SharePoint Online list using the SubmitForm function
Submit PowerApps form data to SharePoint Online list using the SubmitForm function
SharePoint list item has been created using the PowerApps SubmitForm function
SharePoint list item has been created using the PowerApps SubmitForm function

Summary: What we had here from the PowerApps SharePoint connection tutorial?

Thus, in this article, we have learned the below with respect to connecting to the SharePoint list from the PowerApps form:

  • How to design the PowerApps canvas app using form control?
  • How to work with form control in PowerApps?
  • How to connect to the SharePoint site from PowerApps?
  • How to connect to the SharePoint list from PowerApps and display the data in PowerApps?
  • How to do the CRUD operation in PowerApps with the SharePoint connection?
  • How to work with SharePoint connection in PowerApps?
  • How to work with the SubmitForm function in PowerApps?

See Also

You may also like the below PowerApps articles:

Buy SharePoint Online & Office 365 Administration eBook

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


Buy SharePoint Online & Office 365 Administration eBook

Reference URL