is this the correct way to update multiple form(s) into the same row item?

(0) Share

Report

Posted on by dperez13

432

this is not in the sharepoint integrated power app but standalone, fyi.

which way is best/correct?

option 1: have a button at end submitting the form its on and on success property patch the rest of the forms with the update property

i.e. submitform5 on select

patch form1,2,3,4 on sucess

option 2:

patch everything, no submit

option3: submitform5 on select

patch based off ID using lookup? not sure how to code this one, anyhelp?

option 4. submitform 5 onselect

on success patch all the other forms using Defaults('Quality Control Team Checklist')

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@dperez13

@RandyHayes has a video on how to split forms here https://www.youtube.com/watch?v=2E4FXNPLVXw He also has a superb video on everything you need to know about forms. It is long but well worth the time to view it. https://www.youtube.com/watch?v=w724AECyMxo

Was this reply helpful? Yes No
dperez13 432 on at

Like
a
(0)

Report
Copy link

Link copied!
https://youtu.be/2E4FXNPLVXw?t=307 Im a little hesitant on having one form with all of the questions on it. this will slow down my app considerably, as its going to be like 200 datacards connected to sharepoint. Is there a way to submit all the forms without one 'master form' with all the data controls ? @RandyHayes

i know randy mentions losing functionality of using the patch, but im okay with that if it means not having all my datacards on one form in addition to other places. is there anyway i can use the patch function to submit multiple forms to one row? right now I am able to do this, BUT , on an EDIT, two forms are made

For example, if i go to row 5 and edit it and hit submit, i get a row 6 instead i think. or row 5 modified and a new row added, resulting either way in a duplication of sorts. any tips??

Patch('database',{ID_key:LookUp('database',Name=DataCardValue9.Selected.Value,ID_key)},Form1.Updates, Form2.Updates, Form3.Updates, etc...)
here is what i have working thus far

If( form#5 = new
submit form5
patch form1.updates,form2.updates,form3.updates
else, // on an edit
Patch(database name, {ID:gallery1.selected.ID}, form5.updates,form4,updates,form3,updates,form2.updates,form1.updates
)
So far this is working where it matters, both on a new record, and on an edit, with nothing being duplicated? Thoughts on the code up above? Any potential pitfalls to worry about? Im worried as it was almost too easy, and nothing ever is with multiple forms it seems, haha.

Was this reply helpful? Yes No
dperez13 432 on at

Like
a
(0)

Report
Copy link

Link copied!
I am no longer able to submit a form on a new record (and patch in multiple other forms) and only have one row item created. what happens is two row items are created at the same time , with the data I believe going to both.

If( form#5.MODE = new submit form5 patch(datalist,Defaults(datalist), form1.updates,form2.updates,form3.updates,form4.updates ); else, // on an edit Patch(database name, {ID:gallery1.selected.ID}, form5.updates,form4,updates,form3,updates,form2.updates,form1.updates )

on edit things work (but strangely enough when I go to edit a form, my ID doesnt show up from the sharepoint list as a datacard, only when I grab gallery1.selected) , on new , duplicates happen.

edit: i removed submitform and its now working again. im not sure why i had it in the first place but it seemed to work in the past.

Was this reply helpful? Yes No