cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jitendra_jangid
Resolver II
Resolver II

How to update Array Object properties in Power Automate

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

1 REPLY 1
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,228)