Hi Everyone,
I am returning a multi-row json object (see screenshot/json below) from a flow into PowerApps via
ClearCollect(mycollection,'exampleflow'.Run())
to load it into a collection. The collection populates as expected and I can see its contents when I view the collection in PowerApps collections explorer (see screenshot).
However when I set the gallery datasource as 'mycollection' and try to populate labels in the gallery via:
ThisItem.Catalog.CD.Artist
I get the following error message: "Expected Text Value". However, if I use:
First(ThisItem.Catalog.CD).Artist
then the gallery returns the first row from within the collection but none of the other rows for Bonnie, Dolly etc (which I want to see!)
It feels like I'm missing something very simple!! Does anyone have any ideas about how best to display a nested json collection data in a gallery????
Thanks!
---------------------------------------------
Here is the example json I am using:
{
"CATALOG": {
"CD": [
{
"TITLE": "Empire Burlesque",
"ARTIST": "Bob Dylan",
"COUNTRY": "USA",
"COMPANY": "Columbia",
"PRICE": "10.90",
"YEAR": "1985",
"ORACLE": "\n select * from scott.dept;\n "
},
{
"TITLE": "Hide your heart",
"ARTIST": "Bonnie Tyler",
"COUNTRY": "UK",
"COMPANY": "CBS Records",
"PRICE": "9.90",
"YEAR": "1988"
},
{
"TITLE": "Greatest Hits",
"ARTIST": "Dolly Parton",
"COUNTRY": "USA",
"COMPANY": "RCA",
"PRICE": "9.90",
"YEAR": "1982",
"ORACLE": "\n begin\n htp.p('This is the test data');\n end;\n "
},
{
"TITLE": "Still got the blues",
"ARTIST": "Gary Moore",
"COUNTRY": "UK",
"COMPANY": "Virgin records",
"PRICE": "10.20",
"YEAR": "1990"
}
]
}
}I have confirmed that the json is valid in a json validator
