cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

a button for submit 2 different form

ame_0-1639145059813.png

i try to create 2 form, one form is name "form1" and an other is "form7" but i didnt found a formula for make this

i would like to make form1+form7 and make the association beetwen this 2 form in my dataverse table.

in the image i try i think like this but i doesnt work . i try also this

ame_1-1639145277073.png

 

10 REPLIES 10
BCLS776
Super User
Super User

Three things to consider:

  1. I recommend putting the SubmitForm(Form1) in the OnSuccess of Form7. That makes Power Apps run the submissions separately and avoid any conflicts over editing parts of the same record.
  2. Submitting forms does not necessarily create an association of any kind in a table - what are you trying to accomplish with that?
  3. NewForm(Form1) + NewForm(Form7) is incorrect syntax. It should be:
NewForm(Form1);;
NewForm(Form7);;

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Anonymous
Not applicable

hi thx for your reply

for the point 2) that you have mentioned in your reply ,the problem is that i have already 60 field to insert in my form 1 so i would know if there is a system for split in 2 different form because for the user is not easy see a single huge form( i know it can be stupid) so im in search of a system for insert all this data in my dataverse 

30 field (form1) 30 field (form7) but with only a single ID

ID 1 with other 60 field, 

i can use also other idea instead the form system for insert, but i didnt found nothing in internet about this problem.

BCLS776
Super User
Super User

Oh, if these forms are part of a sequence to add the same record, consider this structure:

  1. Have the user fill out the form field for the first form, and submit that before going on to the next form
  2. Refer to Form1.LastSubmit as the Item for the subsequent form(s) and submit each of those as your user completes them

In this way, you make sure to create & then update only one record in your table.

 

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Anonymous
Not applicable

hi but i need to put lastsubmit in my button for the form7? i try but i doesnt work.

 

I'm not sure I quite understand - the references to Form1.LastSubmit should be in the Items property of the form, not in the OnSelect of any button. Can you describe in more detail where you are stuck and what error is occurring?

 

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Anonymous
Not applicable

hi, 

my form 1my form 1formula for submit form1formula for submit form1edit property (form7)edit property (form7)formula for submit form 7formula for submit form 7didnt see my field in form 7didnt see my field in form 7

Anonymous
Not applicable

i put last submit in my form 7 but now i didnt see my form 7 


@Anonymous wrote:

i put last submit in my form 7 but now i didnt see my form 7 


Does your Form7 refer to the same table and same record as Form1? If not, then we need to put in the correct Data Source and Item for that form.

 

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Anonymous
Not applicable

the table is the same but how can i refer the record?

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,130)