Power Automate Flows: Adding Properties to Arrays

By - September 28, 2020

Recently, a client requested something in their Business Central integration: Show us the company for each record you are integrating.

Anyone working with Business Central and Power Automate knows the limits of the standard connectors.

Typically, we are creating APIs or modifying existing pages to access the data we need in Power Automate and this request sounds like it wouldn’t be any different. It might even require custom development in Business Central. Which, we like to avoid whenever possible.

When working with arrays in Power Automate, it is sometimes difficult to access the values within. However, there is a low-code way to add new properties to your array values. With three steps and a function, you will be on your way to becoming a master of Power Automate data manipulation!

 

Step 1: The Array Variable

First, we initialize  an array variable with the ‘value’ property from your query. This stores an object with multiple records as an array within the Flow.

A Microsoft Power Automate Variable Step

 

Step 2: Apply to Each

Next, we will create an Apply to each step that will loop through each record within the array we have just initialized an set. In the field labelled “Select an output from previous steps”, use the Array we have just created.

A Microsoft Power Automate Apply to Each

 

Step 3: Compose

For our third step, we will add a compose step within our apply to each. You can leave the Inputs blank for now.

 

Step 4: addProperty()

For our final step,  we will select the Inputs on our new compose step and select ‘Expression’ in the Dynamic content pane.  First, type or paste addProperty()into the function bar.

The addProperty()function requires three properties to work:

The first parameter of the addProperty() function is the object. As shown in the picture below, this is the object that we want to add a new value to. If you followed this guide, object will be item() and so our expression will be addProperty(item()).

The second parameter is the property. This is just the name of the property we are adding. For this example, I am using ‘Company’ so my expression looks like this: addProperty(item(),'Company')

And finally, we have the ‘value’ property. This is the value we would like to add to our object. I am using a value of ‘Test’ and so my finished expression is as follows: addProperty(item(),'Company','Test')

If we run our Power Automate Flow, we can see our initial array without Company as a property:

And our compose output with the new property:

That’s all there is to it! If you encounter any errors, I would recommend the following troubleshooting steps:

  1. Compare you expression to mine: Check for typos, missed quotes or parenthesis.
  2. Double check your previous steps to see if you are using the correct values.
  3. Ensure your data source is returning data.

Taylor Becktold is a senior associate on the Application Development and Integration team at RSM. Taylor is certified in Dynamics 365 Sales (formerly CRM) and specializes in Microsoft Power Automate, Power Apps, and the KingswaySoft + SSIS integration toolset.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Receive Posts by Email

Subscribe and receive notifications of new posts by email.