3 Ways

3 Ways to add a column to an array in Power Automate

When you have an array in Power Automate and you would like to add a column, you have 3 ways of doing this.

Arrays in Power Automate

In some of my posts in the past I already looked at arrays. In this post I will look at the different ways of adding a column to my array. I’ve found a number of ways of doing this and they all have their advantages.

  • Constructing raw json
  • Using AddProperty
  • Using a select action

In my examples I’m going to use a compose action to create my initial array. But the arrays can really come from any other data source. This could be a SharePoint list, a SQL database or a table in Dataverse or anything else. Arrays are everywhere.

Creating the initial array

I’m creating the initial array, with two objects

3 Ways to add a column to an array in Power Automate Microsoft Office 365

Then as a run my flow I’m getting an array

3 Ways to add a column to an array in Power Automate Microsoft Office 365

Ok, that is good. Now I want to add the length of each title to the array.

Add a column to an array

The first option is to construct the objects inside an apply to each and then adding the Length property followed by an expression that calculates the length.

length(items('Apply_to_each')?['Title'])
3 Ways to add a column to an array in Power Automate Microsoft Office 365

That is easy enough when you only have one property to replicate and it also work probably when you have an array that has predictable propeties, but not every object in each array has to be the same, so this might be some thing that doesn’t always work.

If you have many unpredictable properties in your array you could consider the AddProperty function

AddProperty

3 Ways to add a column to an array in Power Automate Microsoft Office 365

Using the following expression you can add a column to whatever object you want. Giving the same result.

addProperty(items('Apply_to_each_2'),'Length', length(items('Apply_to_each_2')?['Title']))

The fast road to an additional column

Now you could use a select action and replicate all the properties, but that has got that same problem again of managing optional properties.

3 Ways to add a column to an array in Power Automate Microsoft Office 365

Using the addProperty in the select can be really powerful.

Add a column to an array

With the following expression we’re taking each item in the array and adding our property.

addProperty(item(),'Length', length(item()?['Title']))

Advantages of this last option. Only 1 action used, it is fast and it is easy to understand.

3 Ways to add a column to an array in Power Automate Microsoft Office 365

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Archive
%d bloggers like this: