How To Save Data From Powerapps To Sharepoint List

Power Apps Save and New Form Push button

When filling out forms, sometimes a form needs to be filled out over and over, if the end users take a lot of information to input. In this case, it'south helpful to accept a push on the form, for "Save and New". This saves time and prevents the user from having to submit each form and then click the new button all over once again. In this mail, I'll show you first how to create a "Save and New" button in a SharePoint listing form that has been customized with Power Apps, and so in a standalone Power App .

Customized SharePoint Listing / Microsoft List

In my instance canvas app, my grade control is named frmTask, and information technology is a task list in an app.

i. Go to your listing.
(In my example video that is associated with this post, I used the "Work Progress Tracker" list template.)

2. In the toolbar at the top of the list, click the Integrate push button, cull Power Apps, and choose Customize forms.

3. In your new Power App, add two buttons, from the Insert menu.

4. Type the text on the two buttons: "Save" and "Salvage & New"

5. Select the Save push button, and to to the property called OnSelect. Use this formula:
Set( varSaveAndNew, false);
SubmitForm( SharePointForm1 )

vi. Select the Salve & New button, and to to the property called OnSelect. Utilize this formula:
Fix( varSaveAndNew, true);
SubmitForm( SharePointForm1 )

seven. Select the form control SharePointForm1, and go to the holding called OnSuccess. Use this formula:
ResetForm( Self );
If(
varSaveAndNew,
NewForm( SharePointForm1 ),
RequestHide()
)

eight. Get to the SharePointIntegration object, and the property called OnSave.

Utilise this formula:
Set( varSaveAndNew, false);
SubmitForm(SharePointForm1)

Standalone Power App (Canvas App)

When you accept a standalone Power App, there are simply a couple of differences in what needs to be done to accomplish this.

First of all, your grade's OnSuccess is not going to have RequestHide, and the OnSuccess could have a different function in it depending on how you've built your app. A mutual thing that is used in OnSuccess, is to Navigate(). Therefore, if you need to navigate to another screen when the form has been successfully submitted, y'all'll accept a dissimilar formula in the OnSuccess holding. It would be:

ResetForm( Self );
If(
varSaveAndNew,
NewForm( YourFormName ),
Navigate( YourOtherScreenName )
)

Also, if y'all take a standalone sheet app, you won't need to worry about that SharePointIntegration object, considering there isn't one.

Here is my associated demo video from Power Hour, when I congenital all of this, and I show yous how to do it in a customized list for and in a standalone app.