Best way PowerApps SharePoint connection step by step – o365

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 get started 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.

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.

Then select SharePoint as the data connection.

Then select the “Connect directly (cloud services)” radio button 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.

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

Click on the connect button.

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 and select your SharePoint data source from the data source selection list.

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

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

SubmitForm(Form1)

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

Notes:

• In the above SubmitForm, the 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.

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: PowerApps Tutorial

You may also like the below PowerApps articles:

• How to send email from PowerApps button click?
• How to open outlook from PowerApps step by step?
• Show or hide columns conditionally in SharePoint list form
• Create your first chatbot in PowerApps step by step
• Cascading dropdown in PowerApps using SharePoint data
• CRUD operations in PowerApps using SharePoint online list
• CRUD Operation in PowerApps Using Excel OneDrive
• Phone number and email validation in PowerApps
• Connect to a SharePoint list in PowerApps step by step
• Collection variable in PowerApps
• Understand the difference between Set and UpdateContext function
• String concatenation function in PowerApps
• 3 ways to create Power Apps – Types of Power Apps
• Overview view of PowerApps development environment in Power Platform
• Customize SharePoint List Forms Using PowerApps step by step – Office 365
• Create free development environment using Power Apps Community Plan

Buy SharePoint Online & Office 365 Administration eBook

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

Reference URL

• Connect to SharePoint from a canvas app

About Post Author

SP Doctor

I am your SharePoint and Power Platform doctor and guide. Sharing knowledge with my fellow colleagues, friends, and the tech community makes me utmost happy in my job.

See author's posts