Child ID is not created on success property of form

(0) Share

Report

Posted on by nchandran

426

hi.

I have two sharepoints tables A being parent and B being child.

I created multiple forms against sharepoint A field and the submit button does a patch like this ->
Patch(A, Defaults(A), RequestForm1.Updates,RequestForm2.Updates, RequestForm3.Updates, RequestForm4.Updates). This works like a charm. However on the success property it does seem to patch the MasterID which is the lookup i set on the child sharepoint.

THe idea is to related both the sharepoint with using list A's ID with B's master ID. OnSuccess property is this -> Patch(B, Defaults(B), {MasterID:RequestForm1.LastSubmit.ID, EmployeeName:DataCardValue12.Text}). My end product would be to pull out the related records using gallery later on and edit update functions.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (3)

Sort by

Verified answer

WarrenBelz 155,300 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @nchandran ,

The problem is that OnSuccess only works with SubmitForm and you are using Patch. I suggest you use SubmitForm on the relevant item.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report
Copy link

Link copied!

Bret ,
I agree what u said infact it only worked with a form submit but then I have four screens containing each form of fields all pointing to sharepoint A, when i tried submitform(form1), submitform(form2) etc , it created separate lines of records, i just need one recorded updated. Do u have a solution for this?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,300 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@nchandran ,

Reading your post again, you could submit the first from then OnSuccess I assume there is only one field to write, otherwise add the others (you could actually add all fields from the three forms here)

Patch( DataSource, {ID: Self.LastSubmit.ID}, { MasterID:Self.LastSubmit.ID, EmployeeName:DataCardValue12.Text //I assume this is one form 2 } );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,300 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @nchandran ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
nchandran 426 on at

Like (0)

Report
Copy link

Link copied!

Hi Waren, having some traffic issue with o365. i will come back to you the soonest.

Was this reply helpful? Yes No