Power Platform Community Forum Thread Details

Problem:
I have a power automate flow where I have some selects and they return an array of objects and I need only the value of the array to make a chart using create a chart from QucikChart. I have tried a few options from array variables with for each actions after, other simple select statements also trying to string some composes after. Is there any way to flatten my object array to a plain array or will I have to find a different way to make charts through power automate.

Additional Context:

I am getting my data from a stored sql procedure returning an array of objects. For the chart I will need two different numbers and a label. I tried static plain arrays and those worked. The screenshot below are the steps that I currently have implemented that pertain to this problem.

Screenshot 2026-0...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Power Automate Desktop

Hello, could you please embed your flow as an image in the body of your question, above?

As you may have already noted, your attachment is being held back for scanning, plus, many people just cannot access the attachments full stop. :-(

Embedding avoids the doubt. 👍

In the meantime, I am just going to throw out a guess that you may wish to use separate Selects for separate purposes, here.

For example, if you want a 'simple' string array of one of the values, you can make that using the 'text' view of the 'Where' / 'Map' field in the Select action.

To take that example a stage further, let us pretend there is an email key named 'email' with values in all the objects, and you want a list of all the emails.

To get that you would take the array, tap the 'text' button on the map, and enter an expression in the expression builder that simple states:

item()?['email']

That would produce a list of emails (with repeats, that you can union() out in a later action) you can then use for whatever purpose is needed.

Equally, there is a chance that there are a few xpath() solutions to achieve really good results in one go!