**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"
}
]
Error I have:
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)
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
(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.
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?
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHi @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
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsThank you so much. I am working on this now
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
87 | |
57 | |
39 | |
35 | |
33 |
User | Count |
---|---|
79 | |
67 | |
57 | |
48 | |
41 |