Unanswered

Make a combined array out of 2 or more arrays with the same rows from all.

(0) Share

Report

Posted on by jaredbidlow

256

I have found methods that use an 'apply to each', but this relies on inputting the arrays. I have these arrays built and i would like to combine them. The number of arrays within the variable can change. Does anyone know of a template flow that I can call to combine x amount of arrays? Or, better yet, is there a quick way to merge arrays where we are joining each row?

[
 "[{\"Filename\":\"Excel VBA folder files.xlsx\"},{\"Filename\":\"Data.xlsx\"},{\"Filename\":\"ALAN.xlsx\"}]",
 "[{\"Title\":\"Excel VBA folder files\"},{\"Title\":\"Data\"},{\"Title\":\"ALAN\"}]",
 "[{\"folder\":\"Export files from local folders\"},{\"folder\":\"Export files from local folders\"},{\"folder\":\"Export files from local folders\"}]"
]

Sample Arrays

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

takolota1 4,980 Moderator on at

Like (1)

Report
Copy link

Link copied!

@jaeiow

Do you mean append arrays, so add one array’s items below another’s or do you mean merge a key/column from one array into another array based on a primary key?

Was this reply helpful? Yes No
jaredbidlow 256 on at

Like (0)

Report
Copy link

Link copied!

I want to it by index (not present, but self explanatory 1, 2, 3....). This merging of arrays of equal length into one array will collect all the keys/value from the indices into a {}. The number of times it does this will be variable, but I have only found solutions based on 2 or 3 arrays, not variable. I think a nested "Do Until" could do the trick, but this would take very long even if it did.

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you’re just trying to append a variable number of arrays, you should be able to use an Apply to each on the array of arrays and in each loop set a variable action to append the next array with a union( ) of its previous variable value & the loop item.

Was this reply helpful? Yes No
jaredbidlow 256 on at

Like (0)

Report
Copy link

Link copied!

Let me back up to array of array creation. In order to get the array of arrays, all I did was do
concat(',',body('Select_2')) in an "append to string var" inside a loop. So i don't think that this is a true array that can be used in an apply to each. But I could be wrong, Is there another way to build the array or should it work with the current format.

"ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@variables('string')' is of type 'String'. The result must be a valid array."

Was this reply helpful? Yes No