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.

[NeonThunder]

Any updates to what the code will look like?

[Pstork1]

Please post this as a new question and provide a detailed example.  You'll get more responses and others will be able to find the answer more easily later.  Without knowing what your data looks like there is no way to provide what the code would look like.

[NaserTahiri]

using Power Automate's Compose action with the union and if expressions to update the Email field for "Person 1":

union(
    variables('yourArrayVariable'),
    [
        {
            'Approvers': [
                if(equals(items('Your_Approvers_Loop')?['DisplayName'], 'Person 1'),
                    {
                        'DisplayName': 'Person 1',
                        'Email': 'New Person 1 Email',
                        'Status': items('Your_Approvers_Loop')?['Status']
                    },
                    items('Your_Approvers_Loop')
                )
            ],
            'Status': items('Your_Main_Loop')?['Status']
        }
    ]
)

In this example, yourArrayVariable should be the original array, and 'Your_Approvers_Loop' and 'Your_Main_Loop' should be your current items in the respective Apply to each loops (you can get these with the Current item from the dynamic content panel).

Let's break this down:

• union() is merging your existing array with the new array we're creating inside of it.
• Inside the if(), we check if the DisplayName is "Person 1". If it is, we update the Email; if not, we keep it as is (items('Your_Approvers_Loop')).