Unanswered

how to merge two arrays

(0) Share

Report

Posted on by beginner_PA

Hi,
Im beginner of power automate.
Im also japanese and not good at English.

・Question
I would like to merge the following two arrays.
Arrays1・・・this array is composed of varriables that is appended from List rows present in a table

{
    "name": "excel",
    "value": "test1@test.onmicrosoft.com"
"name": "excel",
    "value": "test2@test.onmicrosoft.com"
"name": "excel",
"value": "test3@test.onmicrosoft.com"
}

Arrays2・・・this array is composed ofof varriables that is appended from List folder

{
    "name": "sharepoint",
    "value": "ID1"
    "name": "sharepoint",
    "value": "ID2"
"name": "sharepoint",
"value": "ID3"
}
※Arrays are dynamic variable

Because i would like to use two arrays for Grant access to an item or a folder
ID = Arrays2
Recipients = Arrays1

For that reason, please tell me the process.

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@beginner_PA Use append to array variable.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
beginner_PA 8 on at

Like (0)

Report

Thank u for reply
I was bad at communicating.
I modified the question slightly.
i would like to use two arrays for Grant access to an item or a folder
ID = Arrays2
Recipients = Arrays1
Could u tell me the solution..

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (1)

Report

Are you looking to "stack" or union your two arrays, or "join" them so when recipient ID in array 1 equals ID in array 2 show information from array 1 and 2 together in the same row?

Array 1

RecipientID Name

123 Billly

Array 2

ID LastName

123 Bob

Desired outcome

RecipientID FirstName LastName

123 Billy Bob

@Hardesh15 correct me if i'm wrong but I don't believe you can join arrays in power automate. Without an series of apply to each for each value from each array correct?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report

@srduval Yes,You can join two array using xml ways without any loop.

@beginner_PA If you want to join array then column key must be present in both array other wise you will end up in loop inside loop.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report

@Hardesh15 You have an example handy for the XML join? I've come across this scenario a couple times and I usually just kick it over to SQL to join and return. A flow based solution could be useful for small jobs.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@srduval will share details tomorrow.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
beginner_PA 8 on at

Like (0)

Report

@srduval
@Hardesh15
Below is Excel Table
No. name addless
1 test1 test1@test.onmicrosoft.com
2 test2 test2@test.onmicrosoft.com
3 test3 test3@test.onmicrosoft.com

Below is folder created on sharepoint
column of name on table and folder name are same.
Desired outcome(arrays3)
Name addless ID
test1 test1@test.onmicrosoft.com 1
test2 test2@test.onmicrosoft.com 2
test3 test3@test.onmicrosoft.com 3
※ID is not "No." on excel table. It is unique identifier of the folder
i think i can do Grant access to an item or a folder by using arrays3

Was this reply helpful? Yes No
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (2)

Report

@srduval I have written article on this. Pls check.

How to merge two arrays in Power Automate without apply to each? | Gopenly

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (1)

Report

Good blog, I like how you used the notes to show the formulas.

@beginner_PA I think @Hardesh15 blog above will help do what you need

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@srduval click on three dots and click add a note.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No