JSON to Array for Lookup

[dprjustin]

I'm trying to build a Flow that does the following

1. User adds record to SharePoint list that is a person
2. Flow uses that person to lookup data from O365 (phone, location, etc) and adds those values into the SharePoint list
3. Flow uses that person to lookup data from an HTTP request from another system (HRIS) so we can add in the legal name

I'm getting stuck on #3. I run the HTTP request, which returns a JSON response. I parse through that JSON response, which gives me this body

       "body": {
            "type": "object",
            "properties": {
                "Report_Entry": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "Employee_ID": {
                                "type": "string"
                            },
                            "Legal_Name_-_First_Name": {
                                "type": "string"
                            },
                            "Legal_Name_-_Middle_Name": {
                                "type": "string"
                            },
                            "Legal_Name_-_Last_Name": {
                                "type": "string"
                            },
                            "Supervisory_Organization": {
                                "type": "string"
                            }
                        },
                        "required": [
                            "Employee_ID",
                            "Legal_Name_-_First_Name",
                            "Legal_Name_-_Last_Name",
                            "Supervisory_Organization"
                        ]
                    }
                }
            }
        }

I realize that I can run that JSON through an 'Apply to each' for every record, but that JSON response is huge, and I don't want to cycle through every record within it to find the one that matches the person (from step #1). I was hoping that I could somehow save that JSON body response to an array, and then just do a filter array to pull the specific data for the person, without having to cycle through all of the records.

Any ideas?

[ScottShearer]

@dprjustin :

Not sure that this will work for you.... 

I am assuming that you are using the Parse JSON action.  If so, have you tried using the Filter Array action (Data Operations) using the ouptut of the Parse JSON action as tthe input to Filter Array??

Scott

[Anonymous]

Resurrecting an old topic here, but I'm looking for this solution, as well. I have a large JSON array that I need to filter for one value. My JSON schema is similar to @dprjustin's...

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "DisplayName": {
                "type": "string"
            },
            "NativeID": {
                "type": "string"
            },
            "SubName": {
                "type": "string"
            },
            "SubNativeID": {
                "type": "string"
            }
        },
        "required": [
            "DisplayName",
            "NativeID",
            "SubName",
            "SubNativeID"
        ]
    }
}

I want to filter that array on the value of a property of the contained objects. When I attempt to set up a Filter array action, Power Automate immediately encapsulates the action within an Apply to each action. I would rather avoid the apply to each, because there are thousands of objects in this array. It seems like filtering an array of objects on the value of an object property would be a no-brainer for any platform that uses JSON data.