Power Platform Community Forum Thread Details

Hey everyone,

I am currently trying to set up a new software for my company (can not share the actual code).
I will get JSON files of an Azura Database.
The JSON type is like {Data: [SubData1: X, SubData2: [{SubSubData1: Y, SubSubdata2: [SubSubSubData1: Z]}]]}.
I wanted to transfer the JSON into a nested collection to access the data easily.
I got an index for the parent collection by counting the rows:

ForAll(ParentColl, Collect( Data,{SubData1: ForAll( Table( Index(ParentColl, CountRows(ParentColl))))})
The problem now is, that the SubSubData needs an index as well to get all the SubSubSubData.
So basically I need an index for my nested collection, but preferly without creating a collection first.
Any ideas? And I hope it is somehow understandable. Feel free to ask. This is my first post here.

Categories:

Building Power Apps