Unanswered

How can I create one edit form in SharePoint online that contains items from a parent-child relationship?

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a parent-child relationship. I have the parent modeled as one list and the children modeled in another list with a lookup field referencing the parent.

I want to create one edit form for the parent that contains all the parent's fields, plus a list of all the children with the ability to either add new children or remove children. How can I accomplish this?

Thanks for your help.

- Ed.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

dyee4614 283 on at

Like (0)

Report
Copy link

Link copied!

I'd do this outside of a form. I'd just add all the questions in a gallery and then use the patch field to send it to each individual form. It would look something like this.

Q1 - Parent
Q2 - Parent
Q3- Parent
Q4 - Child
Q5- Child

Patch(ParentList,Defaults(ParentList),
{FieldName: Q1.Text,
FieldName2:Q2.Text
FieldName3: Q3.Text})
Patch(ChildList,Defaults(Childlist),
{FieldName: Q4.Text
FieldName2: Q5.Text})

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply. I don't think I was clear enough in my o.p. I'm envisioning something like this:

The "Title" field is from the parent list, while the list of items beneath it is a list of children items that can be added or removed as desired, all on one form. This screenshot was taken from a 3rd. party tool, but I'd rather do it natively.

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I would look over this set of videos:
https://m.youtube.com/watch?v=xgznk4XlPCo
That will show you how to add multiple children and keep track of them.

Was this reply helpful? Yes No