1 step to update an item in an array in Power Automate
What do you do when you have an array of data in Power Automate and you want to update just one item?
Generate an array
In this example I will generate an array of numbers using the following expression:
So how about updating item 7 to 17?
I could imagine using Pieter’s method but there is an easier option. Just 10 minutes ago I was asked on the chat how I would approach this problem.
The question is easy. How to update an item in an array. This array could of course be an array given by another action and this array could contain objects. For simplicity sake, I’m going with the array of numbers. If you have objects, then the principle will be the same however.
Update an item in the array
All we need to do is use the select action.
This select action takes the array that we generated earlier in our Compose action and now within the Mapping part of the Select action we have to do the magic.
The expression used above is:
if(equals(item(),7), add(item(),10), item())
So the above expression compares the items with the value that we can identify the right item with. Then we either return the original item back or we adjust the item value.
And that is it! Simple?
Continue Reading Pieter Veenstra’s Article on their blog
What do you do when you have an array of data in Power Automate and you want to update just one item? In this example I will generate an array of numbers using the following expression: So how about updating item 7 to 17? I could imagine using Pieter’s method but there is an easier option.
Blog Syndicated with Pieter Veenstra’s Permission
More About This Author
- ModernWorkplace2023.01.04Manage Users using the Graph API in Power Automate
- ModernWorkplace2023.01.03Microsoft Graph API and the Power Platform
- ModernWorkplace2022.12.22A form with a multi-select dropdown with additional information collected for each selected option in Power Apps
- ModernWorkplace2022.12.09Quickly find the parent from the child flow in Power Automate