Power Platform Community Forum Thread Details

Hello All,

I’m trying to get a value out of an array. I can’t figure out the “Select” mapping or “Filter Array”to get the value “Level 1” from my array. Below are the elements of my JSON array.
I have a simple flow with button trigger and a variable set as array and contains the JSON data below. Next, I have a Filter Array action with:

From which is the variable containing the JSON data
Filter Query is ’@equals(item()?['Key'], 'Level')’ which returns the second elements of the array.

How do I just get just the value of “Level 1” out of the JSON?

{
    "name": "JSONData",
    "type": "Array",
    "value": [
      {
        "__metadata": {
          "type": "SP.KeyValue"
        },
        "Key": "UserProfile_GUID",
        "Value": "f0c38635-398f-4aad-a4a1-544",
        "ValueType": "Edm.String"
      },
      {
        "__metadata": {
          "type": "SP.KeyValue"
        },
        "Key": "Level",
        "Value": "Level 1",
        "ValueType": "Edm.String"
      }
    ]
}
]