Power Platform Community Forum Thread Details

Hi Guys,

Been a couple of days on this one and its starting to drive me bananas. For background, my skill levels here are pretty low!!

I have a JSON GET request that only returns 1 items from an API and passes the data into a Parse JSON. The schema is later in this message.

I am trying to reference the items (e.g. firstName, lastName) etc directly in the Respond to Powerapp Operation... but for some reason I cannot get this to work. The only way I have had success is to Initialise a Variable, then go into a Apply Each loop to then set the variable before exiting the loop and Responding to the Powerapp.

I have tried approaches such as below, but none have as yet worked:

body('Parse_JSON')[0]['firstName']

first(body('Parse_JSON')['firstName'])

etc

Any help of assistance is very much appreciated...!

The schema for the JSON is below:

{
    "type": "object",
    "properties": {
        "meta": {
            "type": "object",
            "properties": {
                "count": {
                    "type": "integer"
                },
                "total": {
                    "type": "integer"
                },
                "limit": {
                    "type": "integer"
                },
                "offset": {
                    "type": "integer"
                }
            }
        },
        "members": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "firstName": {
                        "type": "string"
                    },
                    "lastName": {
                        "type": "string"
                    },
                    "number": {
                        "type": "string"
                    },
                    "accountCredit": {
                        "type": "number"
                    },
                    "amountOwing": {
                        "type": "integer"
                    },
                    "age": {
                        "type": [
                            "integer",
                            "string"
                        ]
                    },
                    "id": {
                        "type": "string"
                    }
                },
                "required": [
                    "firstName",
                    "lastName",
                    "number",
                    "accountCredit",
                    "amountOwing",
                    "age",
                    "id"
                ]
            }
        }
    }
}