Answered

Create Nested Collections

(0) Share

Report

Posted on by Bogdan

Hello everyone,

I am trying to build some nested collections:
=============================
ClearCollect(
colEintritt,
{
colCheckliste: {
colStandardsoftware: {
Standardsoftware: galStandardSoftware.Selected.lbl_Office365_2.Text,
angefordert: galStandardSoftware.Selected.Checkbox1.Value,
installiert: galStandardSoftware.Selected.Checkbox1_1.Value
},
colOptionaleSoftware: {
optSoftware: galOptionaleSoftware.Selected.lbl_Office_Project.Text,
angefordert: galOptionaleSoftware.Selected.Checkbox1_22.Value,
installiert: galOptionaleSoftware.Selected.Checkbox1_23.Value
},
colBerechtigungen: {
Laufwerke: txt_Laufwerke.Text,
angefordert: galBerechtigungen.Selected.Checkbox1_32.Value,
installiert: galBerechtigungen.Selected.Checkbox1_33.Value
}
},
Mitarbeiter: DataCardValue2.Selected.DisplayName,
Computername: DataCardValue3.Text,
Ticketnummer: DataCardValue4.Text
}
)
=============================
With the above, it works with only one row (record) being showed.
How can I add multiple rows in the 3rd Level Collection ?

With the method I know, it does not work:

Any respone would be appreciated. I can't go further because of this.

Thank you in advance !

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
To get multiple records at any level for a field you need to specify those records as an array of records. Take a look at this sample. Level 3 is specified as an array using square brackets.

ClearCollect( nestedCollection, { Title: "Level 1A", Level2: { Title2: "Level 2A", Level3: [ {Title3: "Level 3A"}, {Title3: "Level 3B"} ] } }, { Title: "Level 1B", Level2: {Title2: "Level 2B"} } )

Was this reply helpful? Yes No
Bogdan 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks! This is close, if not exactly what I need.
One more question - is this the only solution as Value Arrays ? Is it not possible as simple data Records ?
{
                Standardsoftware: galStandardSoftware.Selected.lbl_Office365_2.Text,
                angefordert: galStandardSoftware.Selected.Checkbox1.Value,
                installiert: galStandardSoftware.Selected.Checkbox1_1.Value
            },
{
                Standardsoftware: galStandardSoftware.Selected.lbl_Office365_2.Text,
                angefordert: galStandardSoftware.Selected.Checkbox1.Value,
                installiert: galStandardSoftware.Selected.Checkbox1_1.Value
            }

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

From what I've tested the first level assumes that multiple records are in an array (collection). But for any additional levels you must declare them explicitly. If you take the collection and look at it in JSON format you can see that multiple records are always in an array. So, no I don't think you can nest multiple records at a different level in the same field unless they are put into an array.

Was this reply helpful? Yes No