Sharepoint OnSave to Submit Multiple Forms on single form screen

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

rebeccas 2,591 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
kritchensBMcD 16 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

rebeccas 2,591 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
LelandUsher 26 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
LelandUsher 26 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
LelandUsher 26 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
LelandUsher 26 on at

Like (1)

Report
Copy link

Link copied!

Ok, I will show you how I got this to work, please review the image below and formulat used on the OnSave Method.

Was this reply helpful? Yes No