Nested Galleries

[prathig14]

Hi All,

1. Can we select the row in the Nested gallery?

2. Based on the selection of row, can we populate data in the below textboxes?

Could you please help me on this?

Thanks for your support in advance!!

Prathibha

[v-siky-msft · Accepted solution]

Hi @prathig14 

Sample data named Countries:

Country	Cities
Germany	City Population Hamburg 1760000 Munich 1494000
Italy	City Population Rome 2874000 Milan 1344000

If you want to get the Rome row, try this code, the first LookUp funciton is to get the nested table, the second LookUp function is to get the Rome row based on the nested table.

LookUp(LookUp(Countries, Country="Italy").Cites,City="Rome")

If you want to get the Population of Rome, try this:

LookUp(LookUp(Countries, Country="Italy").Cites,City="Rome").Population

Hope this helps.

Sik

[prathig14]

Thank You Sik. Your solution helped me.