Multiple form submit - tried patching and submit

[awebb]

Hi all, 

I'm hopiong you can help me out. 

I've created a powerapps app, with 8 forms all coming off the same data source (Datasource being sharepoint called audit data). I've created the forms however when submitting the forms it will only save the last form on the last page. 

I've used this as the onselect - 

Patch('Audit Data',Section2Form.Updates;Section1Form.Updates;Form1.Updates;Section3Form.Updates;Section4Form.Updates;Section5Form.Updates;Section6Form.Updates;Section7Form.Updates;Section8Form.Updates)

The last form "Section8form" mamages to get saved to sharepoint. Am i missing something stupid? 

TIA. 

[Meneghino · Accepted solution]

If you are creating a new record then either of the following should work, where the second is more efficient:

Patch('Audit Data', Defaults('Audit Data'), Section1Form.Updates, Section2Form.Updates, etc. etc.)

Patch('Audit Data', {ID: Blank()}, Section1Form.Updates, Section2Form.Updates, etc. etc.)

If you are modifying an existing record, then:

Patch('Audit Data', MyRecord, Section1Form.Updates, Section2Form.Updates, etc. etc.)

Hope this helps 

[awebb]

That worked a treat! 

Thank you! 

[Meneghino]

You are welcome, check out my blog if you are interested, there are some PowerApps related posts there.

https://baizini-it.com/blog/

[Anonymous]

So, I'm creating a new record and tried the first two formulas but its still only taking the last form. 

Formula: 

Patch('CameraInfo', {ID: Blank()}, Section1.Updates, Section2.Updates, Section3.Updates)

I was doing everything the OP did, and still came across this issue.

[jcollins]

What about if you are using Customized Forms from a SP list?  It is one form for New/View/Edit so how would you incorporate those in the onSave of the form? Maybe in an IF statement? 

[Anonymous]

Hi - looking for help and came across this solution which I thought might work for me!

I have created a customized powerapp list view for my sharepoint list and have two forms on one screen and am trying to submit all of the updates when the user clicks on Save at the top of the list view screen.

I have used your sytanx for OnSave in the sharepointintegration:  

Patch ('SANDBOX_SRM End to End', SharePointIntegration.Selected,SharePointForm1.Updates, ProductInfoForm.Updates)

Several issues: 

1.  When I click on Save it doesn't reset so the user won't know the save has been completed

2.  Doesn't seem to always update all of the fields modified.  For example I have date picker fields - all date & time column types in sharepoint list set exactly the same in the Forms.  I doesn't update some of those fields with the OnSave when I have changed and selected a date for the field. 

Any ideas?

[alexesprtu29]

Hello, what is MyRecord here?

[muzair]

I have the same question , what is MyRecord in this code ? 

[Bharad]

Hello Meneghino,

I am trying to do a similar thing, where I have multiple forms connected to the same datasource. I want to edit a record and save it to the same record (modify it).
I have written the following code:
Patch(GV_test,MyRecord,Form1.Updates,Form2.Updates);

NewForm(Form1);

NewForm(Form2);

Notify("Your changes were successfully saved",NotificationType.Success);

Navigate('Form Master')

But the MyRecord throws an error:  Not recognized.

Could you help with with this?

Thanks in advance 🙂