cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New2PA2020
Advocate I
Advocate I

Submit data from more than one form

Hi PowerAddicts,

 

I am very new to power Apps, I have 8 forms in my app and I need to submit the data to a single sharepoint list but I need to check if there is any change on the form (because it is in Edit).

 

I am doing this:
Submitform(Form1);.....SubmitForm(form9);

 

Please help me.

1 ACCEPTED SOLUTION

Accepted Solutions

hi @New2PA2020 ,

 

My bad, yes you need to use the lookup like as below:

Patch(
   'SPLIST',
    Lookup(SPList,ID=gallery1.selected.ID),
    If(Form1.Unsaved, Form1.Updates),
    If(Form2.Unsaved,Form2.Updates),
    If(Form3.Unsaved,Form3.Updates),
    If(Form4.Unsaved,Form4.Updates),
    If(Form5.Unsaved,Form5.Updates),
    If(Form7.Unsaved,Form7.Updates),
    If(Form8.Unsaved,Form8.Updates),
    If(Form9.Unsaved,Form9.Updates)
ForAll(CollSpareParts,{Title:title}))


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

 



I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a THUMS-UP and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

View solution in original post

5 REPLIES 5
cds
Impactful Individual
Impactful Individual

are you submitting the all forms at once? 

Concurrent(

SubmitForm(Form1),

SubmitForm(Form2)
)

 

Checking to see if changes have been made? 

Could set an OnChange trigger on each element.. 
UpdateContext({IsChanged: true})

KrishnaV
Community Champion
Community Champion

Hi @New2PA2020 ,

Please try this:

Patch(
   'SPLIST',
    Defaults('SPLIST'),
    If(Form1.Unsaved, Form1.Updates),
    If(Form2.Unsaved,Form2.Updates),
    If(Form3.Unsaved,Form3.Updates),
    If(Form4.Unsaved,Form4.Updates),
    If(Form5.Unsaved,Form5.Updates),
    If(Form7.Unsaved,Form7.Updates),
    If(Form8.Unsaved,Form8.Updates),
    If(Form9.Unsaved,Form9.Updates)
ForAll(CollSpareParts,{Title:title}))


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

 



I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a THUMS-UP and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

Hi @cds ,

 

Thank you for your reply, but I also want to check all the forms is there any change in each form or not. i don't see this helps me.

Hi @KrishnaV,

 

I need this on edit screen, I think I need to use lookup to get the specific rec as below:
Lookup(bidget,ID=gallery.selected.ID)

hi @New2PA2020 ,

 

My bad, yes you need to use the lookup like as below:

Patch(
   'SPLIST',
    Lookup(SPList,ID=gallery1.selected.ID),
    If(Form1.Unsaved, Form1.Updates),
    If(Form2.Unsaved,Form2.Updates),
    If(Form3.Unsaved,Form3.Updates),
    If(Form4.Unsaved,Form4.Updates),
    If(Form5.Unsaved,Form5.Updates),
    If(Form7.Unsaved,Form7.Updates),
    If(Form8.Unsaved,Form8.Updates),
    If(Form9.Unsaved,Form9.Updates)
ForAll(CollSpareParts,{Title:title}))


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

 



I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a THUMS-UP and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

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.

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 (3,294)