Multi Child with 1 Parent in 3 Page App

(0) Share

Report

Posted on by Mark_SFAI

Building my 1st PowerApp and can't figure out how to have multiple child's show with Edit Form.

Initially I setup 2 tables in Dataverse. 2nd Table has all the information for child items.

1st Page: Vertical Gallery that shows all Parent Names

2nd Page: Edit Form that shows all metadata items for 1 Parent name, plus multiple child names. (this is where I'm have having issues. The entire page needs to scroll together. Form items from 1 Parent Name plus multiple child names).

3rd Page: Edit Form that will show all metadata for a single child name. I know how to do this.

Currently I have everything setup in Tablet format.

3 page app issue - Mark_SFAI.png

User Interaction Flow.

User Selects 1 Parent Name
Result: All Data for the 1 Parent Name Appears along with all the child names that are associated with the 1 parent.

User Selects 1 of the Child Names.
Result: All Data for that Child Name Appears

For a non programmer, how do you get all items to show as a single scroll.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Mark_SFAI

For showing parent record & child records inside single vertical scroll bar, you could make use of nested galleries. In parent gallery, you can show the parent record and child records can be shown in the nested gallery by filtering child records and set the result set in the 'Items' property of child gallery. You may give a try.

Please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks

Was this reply helpful? Yes No
Mark_SFAI 12 on at

Like (0)

Report
Copy link

Link copied!

On the second page, what are step by step how to add/list multiple child names?

I found the following and did the following...

To nest a gallery in PowerApps, you can make use of nested galleries. In parent gallery, you can show the parent record and child records can be shown in the nested gallery by filtering child records and set the result set in the 'Items' property of child gallery.
Here's an example of how to do it:
1. Set up two tables in Dataverse. The second table has all the information for child items. (DONE)
2. On the first page, create a vertical gallery that shows all parent names. (DONE)
3. On the second page, create an edit form that shows all metadata items for one parent name (DONE) plus multiple child names (HOW??). The entire page needs to scroll together.
4. On the third page, create an edit form that will show all metadata for a single child name. (DONE)

When a user selects one parent name, all data for that parent name appears along with all the child names that are associated with that parent. When a user selects one of the child names, all data for that child name appears.

Was this reply helpful? Yes No
Mark_SFAI 12 on at

Like (0)

Report
Copy link

Link copied!

Does anyone know how to solve this one. I have a 3 page app. Vertical Gallery on page one. page two shows Edit form for that vertical gallery. Im trying to list all items from a separate table under that Edit Form and have a single scroll bar.

Was this reply helpful? Yes No
Mark_SFAI 12 on at

Like (0)

Report
Copy link

Link copied!

Is this possible to have these child items show under the form or patch items. I tried it with copilot but I could only use one table.

Was this reply helpful? Yes No
Mark_SFAI 12 on at

Like (0)

Report
Copy link

Link copied!

This is my post from Microsoft Build Conference.

Just started to build my 1st Canvas "tablet" Power App but am having trouble using 2 dataverse table. The UI looks similar to an app built with CoPilot.

- Listed on the left is a "Vertical Gallery" that lists my main dataverse table

- Center column displays the Edit Form data from the main dataverse table. Here is where I run into issues. I want to list ITEMS from the 2nd table under the Edit Form that are associated. The entire center column should scoll. I used a lookup field on the 2nd table.

- Then in Right column - I want to list "Edit Form" data from the 2nd table.

I tried to put a vertical gallery under the center column Edit Form. But was having issues. Is there someone that can help me?

Was this reply helpful? Yes No
Daryl LaBar 156 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Are you at Build? If so, come to room 438, and we can walk through your issue.

Was this reply helpful? Yes No
Mark_SFAI 12 on at

Like (0)

Report
Copy link

Link copied!

Wish I was, but I am remote. Maybe we can do a meet sometime?

Was this reply helpful? Yes No
RichBurdes 6 on at

Like (0)

Report
Copy link

Link copied!

Is this a Canvas App? If so you could use a Scrollable Screen - have 1 section for your parent and 1 for your child items - you'd get a single scroll bar on that type of screen as long as you manipulate your section heights based on your gallery heights.
On parent gallery in each row you'd have a button or the standard > icon - clicking that sets a variable eg set(varRecord, ThisItem) then maybe run a ClearCollect(colChildItems, Filter(myDataverseTable, ParentID eq varRecord.ID)) using whatever column you have to link your child to parent?

This assumes you have a nice 1 parent to many child relationship.

Does this make sense for you? assumes canvas app - happy to keep explaining but figured I'd throw this out to see where you are at..

Was this reply helpful? Yes No
RichBurdes 6 on at

Like (0)

Report
Copy link

Link copied!

If you want to lay out the screen like the image and have 1 scroll bar - still use a scrollable screen. But have all 3 sections in your 1st section - and ensure you are adjusting the height of each gallery based on a CountRows(galChildren.AllItems)* 55 + 15 (55 being whatever your template height is and assumes blank vertical gallery vs flexible height.

Position the gallery under the parent form using formulas as well for your Y coordinate - eg Galchild.Y = parentForm.Y + parentForm.Height + 50 or something like that to allow it to adjust if it needs to..

Hope this helps.

Was this reply helpful? Yes No
Mark_SFAI 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks Rich. I will try these out tonight!

Was this reply helpful? Yes No