Nested Galleries + Edit Form using Dataverse

[LucasCorsinoPAE]

Hello!

i'm having some trouble with nested galleries and editing forms. 

I have 2 tables, one for buildings and other (the fact table) with dates and progress, all in Dataverse tables with a One to Many relationship by the ID of the buildings.

Inside the app, i have:

• Gallery 1 (table 1 - Buildings) connect to my Form 1 in edit mode, that works perfect, i can choose form the gallery and edit the fields. Form 1: DataSource = Table 1 and Items = Gallery1.Selected

• Gallery 2 (table 2 - Dates and Progress)  connect to my Form 2 in edit mode, that also works perfect, i can choose form the gallery and edit the fields. Form 2: DataSource = Table 2 and Items = Gallery2.Selected

That's works fine, buy i want to use ONLY ONE gallery to filters both edits form at the same time.

Here's a picture of the app with 2 galleries and 2 edit forms:

I tried using nested galleries, but when i put Items = ChildGallery.Selected that's didn't work.

Here's with a only 1 gallery (main gallery + nested gallery) and the 2 edit forms. But didn't work.

I hope you can help me with this problem.

Regards!

Lucas

[BCBuizer]

Hi @LucasCorsinoPAE ,

A way to make this work might be to set the OnSelect property of the child gallery to:

UpdateContext({varChild:ThisItem})

This variable can then be linked to Form2 by setting is as the Item property.

[LucasCorsinoPAE]

@BCBuizer Thank's for your answer, it's wotks fine in a text box but didn't work as a Item Property in my Edit Form 2.

My Edit Form have a lot of dropdowns vinculated to the columns of my fact tables with options (previously created in Dataverse).

For my dropdowns i use this type of code: Choices('Baja (Table2)')

Here's the pic of the problem:

Thank' you for the helping, we are near to the solution!

Cheers,

Lucas

[BCBuizer · Accepted solution]

Hi @LucasCorsinoPAE,

I meant to set the Item property for varChild only, without anything after that.

However, it seems you have a 1:1 relationship between the two lists. Can you confirm?

I that is the case, there is no need for any second gallery, nested or not, because you can use a lookup in the Item property instead:

LookUp(Table2, ID = Gallery1.Selected.ID)

[LucasCorsinoPAE]

@BCBuizer Yes, for now the relationship is a 1:1 from the main table to the fact table.

Your solutions works fine! Thanks for your time!

Cheers,

Lucas