Send an HTTP request to SharePoint JSON Output to an Array

[Harbie]

WhenI run "Send an HTTP request to SharePoint" I get the output below. Note that the output is dynamic hence can be more or less than two entries. {

  "value": [

    {

      "Email": "adele@xxxxxxxxxxxxxx.onmicrosoft.com"

    },

    {

      "Email": "sayven@vvvvvvvvvvv.OnMicrosoft.com"

    },

    {

      "Email": "jons@xxxxxxxxxxx.onmicrosoft.com"

    }

  ]

}
\SCHEMA

{

    "type": "object",

    "properties": {

        "value": {

            "type": "array",

            "items": {

                "type": "object",

                "properties": {

                    "Email": {

                        "type": "string"

                    }

                },

                "required": [

                    "Email"

                ]

            }

        }

    }

}

question:
How can I convert this JSON Object into an Array?

[CFernandes]

@Harbie 

Hey Mate,

I assume you are trying to get value from the array, something like the screenshot below:

If yes, you can use Parse JSON,> Generate the the JSON schema and directly use the 'Email' the output of Parse JSON asction.

If you want to access individual element then the formula would be.

First Value

body('Parse_JSON')?['value'][0]?['Email']

Similarly Second Value

body('Parse_JSON')?['value'][1]?['Email']

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Harbie]

below is my flow

I have another array and I am trying to compare the values provided by HTTP with the values the Array 2. In other to do this, I need the values from Parse JSON to be stored in an array.
@CFernandes 

[CFernandes]

@Harbie 

In Compose you are using the 'Split' operator I guess with reference to error.

Please paste the formula that you have used in the compose action. 

[Harbie]

@CFernandes I sent that almost same time as your response.

If I am correct, the array, in this case, is Value? 

How can I get just the array below from Value?

[

      "adele@m365x685435.onmicrosoft.com"

      "sydney@M365x685435.OnMicrosoft.com"

      "jons@m365x685435.onmicrosoft.com"

]

Thanks for your time @CFernandes .. I am a learner 

[CFernandes · Accepted solution]

@Harbie  No worries... The only change you will need to make is initialize a variable of type array, and append the array variable with the value. See screenshot below:

The JSON Schema was generated you sample.

{
    "type": "object",
    "properties": {
        "value": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "Email": {
                        "type": "string"
                    }
                },
                "required": [
                    "Email"
                ]
            }
        }
    }
}

Flow Run:

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!