cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jasmine2020
Microsoft
Microsoft

How can I update nested fields using a Logic App

**Background:**
I'd like to perform an update on nested fields using the LogicApp

 

**This is what I did:**


1. Ran my query to fetch the documents I need

2. Create global variable that holds the array that I wish to 'update'

3. Run for each loop over the first query, parsed the JSON , create a for each loop for

all of the items in the Feedbacks array : 

 [   
{ "id" : "1234"}

 ]

4. Append the variable that I created with the current item in the loop

5. Finally update that original feedback array with the updated array that was created in the

   first variable dynamically.

"id":"1234"

"Features":

{

"id": "update me"

"state": "update me"

}

]

 

 

jasmine2020_0-1597268621633.png

 

jasmine2020_2-1597268657049.png

 

jasmine2020_3-1597268689062.png

jasmine2020_5-1597268718749.png

 

 

 

 

 

 

 

 


Error I have:

 

 

 

jasmine2020_6-1597268755279.png

 

I suppose its placing the array



{

"id": "update me"
"state": "update me"

}

]

inside the

Feedbacks array []

When I am wanting  the items and array that the feedback id is pointing to to be updated within the feedback array, nested in the Features array.

 


For instance this is the feature container that holds the Feedbacks array (highlighted)

 

jasmine2020_7-1597268788278.png

 

 

And within the Feedbacks array above, I am wanting to iterate within each of its ids and then update that Features array with what I provided in the variable

 

jasmine2020_8-1597268813995.png

 


(I believe what needs to be updated is being placed in that initialize variable?)

 

 

Any advice or suggestion is greatly appreciated. I am a bit stuck on this.

4 REPLIES 4
abm
Super User
Super User

Hi @jasmine2020 

 

 

Your second for each loop I can see you append to array and immediately create or update the document. Is that correct? I can see here your array is going to append 20 times and each time it is going to create or update operation?

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @abm 

 

I am not sure if I am doing this right. For every document in the Feedback array, I wish to loop over this and update the contents within it.

 

 

             Feedbacks: 

                        [

                               {

                                      "id":"1234"

                               }

                       

                              {

                                     "id":"5678"

                              }

                        ]

 

so for every document within this Feedbacks array, I wish to then update the nested fields within it

 

 

 Inside of the "id":"1234":

                  

 

                       "id":"1234"

                       "Features":

                                            [

                                             {

                                     

                                                "id": "i wish to update"

                                                "state": "i wish to update"   

                                             }

                                          [

 

 

I figured I can do a for each loop to iterate over the feedbacks document and then

use a variable to replace certain fields I need to update

abm
Super User
Super User

Hi @jasmine2020 

 

Couple of issues we resolved

 

1. JSON schema validation failed due to null. We resolved this changing the parse schema validation to accept string or null.

2. Next we iterate the ID and extract the id value using another Parse JSON

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Thank you so much. I am working on this now

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.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

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.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,029)