How to submit multiple forms at one buttom

Like (0) Share

Report

Posted on 6 Feb 2017 07:22:31 by Community Power Pla...

Hello,

I have 2 forms in my app called EditForm1 & EditForm 2

On form 2 i have 1 button, i would like to save both forms with that single button.

But how??

Categories:

General Questions

All responses (20)

Answers (0)

dperez13 432 on 05 Jan 2023 at 20:46:41

Like (0)

Report

Re: How to submit multiple forms at one buttom

Quick question, when you have multiple forms that all submit to the same row, how do you tell the forms to reset when creating a new row item in the gallery? do you have to reset each one so it doesnt hold the last submits data somewhere?
chettawan 2 on 14 Jul 2022 at 08:55:26

Like (0)

Report

Re: How to submit multiple forms at one buttom

This code worked. Thanks!
UDA_Solomon 2 on 29 Dec 2019 at 19:20:50

Like (0)

Report

Re: How to submit multiple forms at one buttom

Thank you for your contribution from the future.

How would you accomplish this with a model driven app?
KingCarmo 4 on 08 Nov 2019 at 12:09:29

Like (2)

Report

Re: How to submit multiple forms at one buttom

Hi, I might be late to the party by about 2 years but I'm here for future people incase they need help with this problem.

I found that doing the following helps submitting multiple forms with one button

I use the following code "SubmitForm(MyForm1) && SubmitForm(MyForm2) && SubmitForm(MyForm3) && ...." within the OnSelect Function

I've used this to update multiple forms within my Sharepoint List and I hope this helps people in the future
PhilD 1,009 on 21 Mar 2018 at 14:02:25

Like (0)

Report

Re: How to submit multiple forms at one buttom

Nice!

Great example that explains the approach very well, thanks!
Meneghino 6,949 on 19 Mar 2018 at 10:58:43

Like (2)

Report

Re: How to submit multiple forms at one buttom

Hi @PhilD
Thanks for the support. I have since created this blog post on creating your own forms:
https://baizini-it.com/blog/index.php/2017/09/28/powerapps-101-create-your-own-forms/
Community Power Pla... on 16 Mar 2018 at 18:43:38

Like (3)

Report
Re: How to submit multiple forms at one buttom

I have many forms across different screens in my app that I submit to one record in my SQL database. The method I use is.
Patch('database', Defaults('database'), Form1.Updates, Form2.Updates, Form3.Updates...etc.)
If there is already a record in the database that I want to modify I search for the ID_Key (Must be a unique key to work) and then patch to that.
Patch('database',{ID_key:LookUp('database',Name=DataCardValue9.Selected.Value,ID_key)},Form1.Updates, Form2.Updates, Form3.Updates, etc...)
PhilD 1,009 on 16 Mar 2018 at 17:34:28

Like (0)

Report

Re: How to submit multiple forms at one buttom

@Meneghino

I think I hear you saying that in some cases it may be better to just use controls that are individually configured to handle CRUD operations on records rather than rely on forms with data cards, etc.

I have a similar need where I need to populate one dropdown/lookup with a subset of the lookup choices but can't get this to work in a datacard with SharePoint integration. The patch operation works fine but then I have to mess around with the remainder of the controls in the form when it comes to a submit/update operation using 'Last()', etc.

Your perspective is fresh and unique and frankly I am relieved to think there is a way to provision these controls manually as I am not a big fan of the forms in PowerApps. I'm glad I read your suggestion.

I plan to give a go at configuring controls for the view, edit and new states and use patch to update/create records.

I would love to hear any additional considerations you may have when using this approach that I may not have thought of and thanks again for helping us to look at this in a different way.
Community Power Pla... on 28 Feb 2018 at 10:02:53

Like (0)

Report

Re: How to submit multiple forms at one buttom

Hi Meneghino,

your formula was correct. I just made a litte change to the syntax. It works for my project very well.

In fact I have two items and one of those items is split into 3 forms:

Spoiler (Highlight to read)
SubmitForm(FinanzJ1);Patch(Finanzdaten,FinanzJ1.LastSubmit,FinanzJ2.Updates,FinanzJ3.Updates);SubmitForm(ItemForm2)
SubmitForm(FinanzJ1);Patch(Finanzdaten,FinanzJ1.LastSubmit,FinanzJ2.Updates,FinanzJ3.Updates);SubmitForm(ItemForm2)

The OnSuccess property of all Finanz Forms is set to false.
BoonYar_Aeris 92 on 07 Jun 2017 at 04:31:26

Like (0)

Report

Re: How to submit multiple forms at one buttom

I was searching for this solution. Tried your method and it works. Thanks!