Hi,
I'm looking to utilise data (in the form of JSON from a custom API) to create collections in powerapps but the flow i'm currently running seems to return one column: Value with True as the only column value. So the flow seems to work fine - but I can't get any of the data that is in the response from the JSON.


The idea is to create an app that sends requests to the API returing the JSON in a flow to the App, I've seen a lot of posts suggesting to re assemble the flow and then try it again which hasn't worked for me, but I haven't been able to find a response that worked in my situation.
Another issue is that when I include a schema in the Response part of the flow (as i have above), when I attempt to add the flow to powerapps I get the error: Registering error - again I've seen the posts that suggest fields aren't given values however I've checked and they all seem to have values.
JSON schema:
{
"type": "object",
"properties": {
"total": {
"type": "integer"
},
"nb_pages": {
"type": "integer"
},
"items": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "integer"
},
"percentage": {
"type": "number"
},
"approaches": {
"type": "array"
},
"Alpha": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "integer"
},
"name": {
"type": "string"
},
"parent": {
"type": "object",
"properties": {
"id": {
"type": "integer"
},
"name": {
"type": "string"
}
}
}
},
"required": [
"id",
"name"
]
}
},
"attributes": {
"type": "array"
},
"countries": {
"type": "array"
},
"structure": {
"type": "array"
},
"cap": {
"type": "array"
},
"regions": {
"type": "array"
},
"gamma": {
"type": "array"
},
"focus": {
"type": "array"
},
"as_of": {
"type": "string"
},
"geographic": {
"type": "object",
"properties": {
"id": {
"type": "integer"
},
"name": {
"type": "string"
}
}
}
},
"required": [
"id",
"percentage",
"approaches",
"alpha",
"attributes",
"countries",
"structure",
"cap",
"regions",
"focus",
"gamma",
"as_of"
]
}
}
}
}
Any help would be much appreciated!
Thank you