Sharepoint OnSave to Submit Multiple Forms on single form screen

Like (0) Share

Report

Posted on 23 Apr 2020 17:58:36 by kritchensBMcD

Hey All, So a few things have been a bit confusing when looking for a solution. So here is my particular issue.

With power apps and SharePoint connection i created a custom form.

Its not a tabbed form screen.

But 1 form screen with multiple edit forms.

I wanted to know the best way i could submit all information into a single record. Would that be patch? also would i need to create view versions of all these screens as well?

Categories:

General Questions

All responses (7)

Answers (1)

LelandUsher 26 on 12 Feb 2023 at 22:39:43

Like (1)

Report

Re: Sharepoint OnSave to Submit Multiple Forms on single form screen

Ok, I will show you how I got this to work, please review the image below and formulat used on the OnSave Method.
LelandUsher 26 on 11 Feb 2023 at 21:48:03

Like (0)

Report

Re: Sharepoint OnSave to Submit Multiple Forms on single form screen

Well I updated my OnSelect method to: SubmitForm(SharePointForm1);SubmitForm(SharePointForm1_1); SubmitForm(SharePointForm1_2) AND this did not save the fields from any of the forms back to the list. It would be great if this worked but still not working.
LelandUsher 26 on 11 Feb 2023 at 21:41:11

Like (0)

Report

Re: Sharepoint OnSave to Submit Multiple Forms on single form screen

I think I may have figured it out. The screen below shows my mistake, I hope this works now and will report back.

SavingMultipleFor...
LelandUsher 26 on 11 Feb 2023 at 21:34:07

Like (0)

Report

Re: Sharepoint OnSave to Submit Multiple Forms on single form screen

Hello, I tried this on my SharePoint list integrated form with 3 forms and it did not save the data.
SubmitForm(jobdescription);SubmitForm(physicaldemands); SubmitForm(jobdetails)

Any advice on why this would not save from the OnSelect method?

Thank you
Verified answer

rebeccas 2,591 on 23 Apr 2020 at 19:29:34

Like (0)

Report

Re: Sharepoint OnSave to Submit Multiple Forms on single form screen

Okay, you can have the button just do OnSelect: SubmitForm(Form1);SubmitForm(Form2); SubmitForm(Form3)

That will save the changes to each. If you have all your data in a Form then it usually works best to just use the SubmitForm() instead of Patch. Patch is good for when it is not in a form or if you are updating changes because of another action.

After you do the SubmitForm() on the button for those three I would suggest you either have it send them to another screen or do some type of pop-up message letting them know their changes were saved because otherwise it is not very obvious it worked and people tend to hit the button more than once trying to be sure.
kritchensBMcD 16 on 23 Apr 2020 at 19:00:32

Like (0)

Report

Re: Sharepoint OnSave to Submit Multiple Forms on single form screen

Hey Rebecca,
No more like Current Item Being Edited, There is the following items:

Form Screen 1
Edit Form 1
Edit Form 2
Edit Form 3

I would like to use the OnSave To submit the changes or updates and also ensure the view on that single form screen shows the data on the currently selected item.
rebeccas 2,591 on 23 Apr 2020 at 18:38:08

Like (0)

Report

Re: Sharepoint OnSave to Submit Multiple Forms on single form screen

Just so I am understanding...you have multiple forms that you want to submit but you also want the data from those multiple forms to a separate sharepoint list (together as one row item)?

Is that correct?