I am returning 3 columns of data from a stored procedure.
The JSON Is coming back, but I cannot seem to get it into a Power Apps collection.
The collection just shows an Items and a Type column with no data.
For the body expression I used
{
"type": "array",
"items": {
"type": "object",
"properties": {
"LoginID": {
"type": "string"
},
"Surname": {
"type": "string"
},
"Forename": {
"type": "string"
}
},
"required": [
"LoginID",
"Surname",
"Forename"
]
}
}
Any help appreciated
Thanks
