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 (which I want to see!)
It feels like I'm missing something very simple!! Does anyone have any ideas about how best to display json collection data in a gallery????
Thanks!
---------------------------------------------
Here is the example json I am using from the following website: http://hp1.gcal.ac.uk/help/wvtxmlex.htm.
I have confirmed that the json is valid via jsonlint.com
{
"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 recently cam across the following post which I am experiencing a similar problem to.
https://powerusers.microsoft.com/t5/General-Discussion/Powerapps-problem-accessing-JSON-collection/td-p/104100
I essentially followed this helpful guide here: https://powerapps.microsoft.com/ja-jp/blog/return-an-array-from-flow-to-powerapps-response-method/
