I have created a collection based on a json flow response that has created a multi level collection. I am looking for help in trying to access data nested 3 levels deep in the collection. For instance I have a collection called colFaceData > responses > webDetection > bestGuessLabels > label
I am trying to access the value in label. I have attached the schema, and example response, and a screenshot of my collection.
How would I first assign a gallery to the bestGuessLabels collection and then assign the text value of a label control with the "label" value?
Solved! Go to Solution.
Just as a little example...
//Simple ForAll
CountRows(ForAll([1,2,3,4,5], Value)) = 5
First(ForAll([1,2,3,4,5], Value)).Value = 1
Last(ForAll([1,2,3,4,5], Value)).Value = 5
//ForAll to make records
CountRows(ForAll([1,2,3,4,5], {myVal:Value})) = 5
First(ForAll([1,2,3,4,5], {myVal:Value})).myVal = 1
//A little more structure Last(
First(
ForAll([1,2,3,4,5],
{myVal:Value,
myTab:ForAll([10,20,30,40], Value)
}
)
).myTab).Value = 40
They're not all that complex to deal with, but one must remember...there are not For Next loops!! They are data iterations.
User | Count |
---|---|
224 | |
100 | |
94 | |
57 | |
31 |
User | Count |
---|---|
281 | |
114 | |
110 | |
63 | |
57 |