How to update Array Object properties in Power Automate

(0) Share

Report

Posted on by Jitendra_jangid

128

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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Pstork1 69,270 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NeonThunder 76 on at

Like (0)

Report
Copy link

Link copied!

Any updates to what the code will look like?

Was this reply helpful? Yes No
Pstork1 69,270 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NaserTahiri 2 on at

Like (0)

Report
Copy link

Link copied!
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')).

Was this reply helpful? Yes No