Combine two select outputs

(0) Share

Report

Posted on by extect

I have two select actions that ouput data in exactly the same format:

[...]

I now want to combine the two outputs into the same array. How can I achieve that?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Ravi14 26 on at

Like (0)

Report
Copy link

Link copied!

Hi @extect

Do you want to get the 2 outputs as an Array or as a single text?

Was this reply helpful? Yes No
Ravi14 26 on at

Like (0)

Report
Copy link

Link copied!

@extect
Please check the below link for your reference
https://www.powertechtips.com/create-array-power-automate/#:~:text=Create%20an%20Array%20with%20the,workflow%20function%20for%20creating%20them.&text=The%20createArray%20function%20allows%20you,It's%20that%20simple!

Hope it will answer your question

Was this reply helpful? Yes No
extect 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @Ravi14
Thank you for your help. I tried createArray as you suggested.
It outputs something like this.
[ [ { "Name": "A", "Target": "15" }, { "Name": "B", "Target": "10" } ], [ { "Name": "C", "Target": "40" } ] ]

What I am looking for though is this, where Name C is coming from one select output and Name A und B from another select ouput.
[ { "Name": "A", "Target": "15" }, { "Name": "B", "Target": "10" }, { "Name": "C", "Target": "40" } ]

Was this reply helpful? Yes No
Ravi14 26 on at

Like (0)

Report
Copy link

Link copied!

Hi @extect

What is the output you are expecting and from which screenshot?

Was this reply helpful? Yes No
agatakurylak 6 on at

Like (0)

Report
Copy link

Link copied!

Is there any update on it?

Was this reply helpful? Yes No
LeeHarris 1,026 on at

Like (2)

Report
Copy link

Link copied!

Hi @extect and @agatakurylak

You should be able to make use of the Union expression to achieve this as long as both of your arrays are in the exact same format. Note that this will remove any duplicate records that it finds so you will be left with a distinct list.

Add a Compose action as shown in the screenshot further below and set the expression to the following:

union(outputs('Select'),outputs('Select_2'))

Note: outputs('Select') and outputs('Select_2') are just the names of the actions that are creating your arrays. You can change this in the expression if your actions are called something different.

You should then be able to use the output of the Compose action as an array in any actions that follow it.

Hope that helps.

Was this reply helpful? Yes No