How to update Array Object properties in Power Automate

[Jitendra_jangid]

Hi,

I've an Object Array structure like following one.

[
    {
        "Approvers": [
            {
                "DisplayName": "Person 1",
                "Email": "Person 1 email",
                "Status": "Not Started"
            },
            {
                "DisplayName": "Person 2 email",
                "Email": "Person 2 email",
                "Status": "Not Started"
            }
        ],
        "Status": "Not Started"
    },
    {
        "Approvers": [
            {
                "DisplayName": "Person 3 email",
                "Email": "Person 3 email",
                "Status": "Not Started"
            }
        ],
        "Status": "Not Started"
    }
]

I would like to update individual properties of Array Object and keep the entire updated object. for example, I just want to update the Person 1 email in first Approvers. I tried with setProperty function but that doesn't seem to work with Arrays.

Any suggestions???

Appreciate your time. Thanks

[Pstork1]

There is no easy way to update a value inside an array in Power Automate.  Essentially you'll need to read and process the array to create a new array with the substitute values.  In your case that is even more difficult because you have embedded arrays inside the outer array.  You can handle updating an individual array using the Data Operations Select statement. Simply map each of the columns and then supply the values for the new entries.  You can then use an IF statement in the column you want to change to insert the new value.