How to Create an Array from an Object of Objects in Power Automate

Learn how to convert an object of objects into a usable array in Power Automate and loop through its fields effectively.
---

Visit these links for original content and any more details, such as alternate solutions, comments, revision history etc. For example, the original title of the Question was: Create an array from an object of objects

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Create an Array from an Object of Objects in Power Automate

In the realm of data manipulation, especially within Power Automate, one common challenge is the need to convert an object consisting of objects into an array that can be easily looped through. This guide will guide you through this process, using a specific JSON structure and a straightforward solution.

The Problem

You may find yourself facing a scenario similar to this:

Input JSON Structure that resembles an object of objects:

[[See Video to Reveal this Text or Code Snippet]]

The goal is to extract the fields from each item in the array so that they are more accessible. The expectation is to create an array from the fields where each entry comprises the relevant field information.

For example, the original output might look like this:

[[See Video to Reveal this Text or Code Snippet]]

But the desired output should be structured like:

[[See Video to Reveal this Text or Code Snippet]]

The Solution

The good news is that transforming an object of objects into a usable array can be accomplished with a simple set of string replacements within the Power Automate expressions.

Example Input

Let's begin with the input you have:

[[See Video to Reveal this Text or Code Snippet]]

Expected Output

Your desired output structure is as follows:

[[See Video to Reveal this Text or Code Snippet]]

Using Power Automate Expressions

To achieve the desired output, apply the following Power Automate expression:

[[See Video to Reveal this Text or Code Snippet]]

Breaking Down the Expression

string(outputs('Compose')): Start by converting the output from your Compose action (or whatever source you are working with) to a string.

Multiple replace() Functions:

The first replace adds a "field" key to the beginning of each object.

The second replace adds the "field" key to the start of each subsequent object.

The third replace modifies the structure from key: { to introduce a comma for better structuring.

The last replace cleans up the brackets at the end.

Conclusion

This method provides a neat and accessible way to convert an object of objects into an array that can readily be processed in loops within Power Automate. By following the provided solution, you should be able to manipulate your JSON data effectively and achieve your goals.

Feel free to share your thoughts or any additional questions you have about manipulating JSON data in Power Automate in the comments below!