In this PowerApps Tutorial, We will discuss how to save data or items to a SharePoint Online list using a PowerApps Form. Also, We will see how to connect the SharePoint Online List to PowerApps app and submit the Powerapps form data to the SharePoint list.
By taking a simple scenario, We will see how to clear the previous text, reset the Powerapps Edit form and save the data to the SharePoint Online list. so that anyone can understand easily.
PowerApps Save Data to SharePoint List
Coming to the example, I have a SharePoint Online List named SharePointTraining. This training list has below columns with different data types:
- Title: By default, this is a Single line of text data type column.
- FullName: This is the column that I have created with a Single line of the text data type.
- Course: This is the Choice type column that contains some choice values like SharePoint, PowerApps, Power BI, etc.
- Trainer: This is also a single line of text data type column.
In this example what I want to do is, When a user will enter these field values (Title, Full name, Course, and Trainer) in the Powerapps form, then the user entered data will be saved in the SharePoint Online List (SharePoint Training).
If you are new to PowerApps, then you can read this article: Create your First form using Microsoft PowerApps in SharePoint Online.
The below screenshot represents the various columns of the SharePoint Online List (SharePoint Training).
Read Power Apps Button Control
Create a PowerApps form for SharePoint Online List
Once the SharePoint Online List is ready, next it’s time to create a PowerApps Form where you can enter the data. When you will submit the form, then all the data will save into the SharePoint Online List. Follow these below process to do so:
- Sign in to the PowerApps app.
- Go to the Apps tab (left navigation) from the Home page -> Click on + Create an app -> Select Cavas as shown below.
- Next, you need to choose an app layout either a Phone or Tablet layout. Select any layout under the Blank app template section. For this example, I have chosen a Phone layout.
- Once you will choose any app layout, then a new Blank PowerApps screen will appear having with that particular layout (Phone layout). By using that screen, you can design your page by taking your desired input controls.
- On the PowerApps Blank screen, Insert these below Powerapps Input controls as:
- Label: Insert one Label control for heading purpose. You can provide any heading by using its Text property.
- Button: Add two Buttons. One Button control is for item submitting purpose and another one is for item clearing purpose. I just renamed these two-button control names as Submit and Clear.
- Now you need to connect the SharePoint Data source to the Powerapps app or form. To connect the SharePoint list to the app, go to View tab -> Data sources -> Create a new or an existing connection by providing your Microsoft credentials -> Enter the SharePoint Online Site URL (where the SharePoint Online list is present) -> Next Click on “Go“.
- After doing these above steps, the SharePoint Data source connector is connected to the Powerapps app. Next, it will ask you to choose the SharePoint list.
- Select the SharePoint Online list (SharePointTraining) and then hit on the Connect button as the below screenshot.
- Add one PowerApps Edit form where users can enter field values. Go to Insert tab -> Forms -> Select Edit as shown below.
- Now a Powerapps blank edit form will appear on the PowerApps screen. Once you will click on the edit form, then it will ask you to connect the data. Select the SharePoint list data source (SharePointTraining) that you have connected previously.
- When you will add the SharePoint list data source to the Powerapps edit form, you can see the form by using the Preview option. Save and Preview (F5) the app.
- Once you will preview the app, you can see an empty page will appear because still the SharePoint Online list (SharePointTraining) is not connected to the PowerApps form.
- To view the SharePoint Online list fields in the Powerapps Edit form, we need to specify some formula on the Clear button’s OnSelect property.
- Select the Clear button and apply this below formula on its OnSelect property as:
OnSelect = NewForm(Form1)
Form1 = PowerApps Edit Form name
- Once again Preview (F5) the app and click on the Clear button, you can able to view all the fields of SharePoint Online List (SharePoint Training) in the PowerApps Edit form.
- Similarly if you want to clear all the text boxes, then add this below formula on Clear button’s OnSelect Property as:
OnSelect = ResetForm(Form1); NewForm(Form1)
Form1 = PowerApps Edit Form name
- Next, to submit the items or field values to the SharePoint Online list (SharePointTraining), we need to specify the formula on the Submit button’s OnSelect property.
- Select the Submit button and apply this below formula on its OnSelect property as:
OnSelect = Submit(Form1);NewForm(Form1)
Refer the below screenshot.
- That’s it for the app. Now Save and Preview (F5) the app. Enter all the field values by using text box control and then just hit on the Submit button as like the below screenshot.
- Once you submit the data, go to the SharePoint Online List (SharePointTraining). You can see all the user data has been saved into the SharePoint list as shown below.
Also, you may like these below PowerApps tutorials:
- PowerApps Navigate to another screen
- Build PowerApps Quiz App – Step by Step
- PowerApps Sum function (Get sum of a column PowerApps)
- PowerApps upload file to SharePoint document library
- PowerApps Gallery Control Filter Example
- PowerApps Send an Email on Submit Button
- Create a PowerApps App from PowerApps template
- How to Customize SharePoint Online List form using PowerApps
- Microsoft PowerApps: Create Login Screen
- Embed PowerApps in Modern SharePoint Online Site Page
- Display SharePoint Online List Columns in multiple screens in Microsoft PowerApps
- PowerApps Twitter Connector
In this PowerApps Tutorial, We discussed how to save data or items to a SharePoint Online list using a PowerApps Form. Also, We saw how to connect the SharePoint Online List to PowerApps app and submit the Powerapps form data to the SharePoint list.
Also by taking a simple scenario, We learned how to clear the previous text, reset the Powerapps Edit form and save the data to the SharePoint Online list.
I am Bijay a Microsoft MVP (8 times – My MVP Profile) in SharePoint and have more than 15 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com
When I put in the necessary info for the Submit button for OnSelect, it gives me an error that says, “Invocation of unknown or unsupported function.” What do I do?
This info is helpful but there are so may ads on this site that I can barely load it
This was very helpful! Thanks a lot 🙂
Glad the article helped you.
This is great!!
Submitform does not work updating from powerapp to sharepoint list.
What could be the issue?