Power Automate - Building Flows

Answered

How to combine two arrays?

Like (0) Share

Report

Posted on 7 Nov 2023 13:44:36 by Oskarkuus

1,095

I have two arrays

[
 {
 "CustomerName": "Customer A",
 "CustomerId": "1",
 "CustomerPersonId": "1",
 "CustomerPersonName": ""
 },
 {
 "CustomerName": "Customer B",
 "CustomerId": "2",
 "CustomerPersonId": "1",
 "CustomerPersonName": ""
 },
 {
 "CustomerName": "Customer C",
 "CustomerId": "3",
 "CustomerPersonId": "2",
 "CustomerPersonName": ""
 }
]

And

[
 {
 "PersonName": "PersonName 1",
 "PersonId": "1"
 },
 {
 "PersonName": "PersonName 2",
 "PersonId": "2"
 }
]

I want to create an array in power automate that looks like this

[
 {
 "CustomerName": "Customer A",
 "CustomerId": "1",
 "CustomerPersonId": "1",
 "CustomerPersonName": "PersonName 1"
 },
 {
 "CustomerName": "Customer B",
 "CustomerId": "2",
 "CustomerPersonId": "1",
 "CustomerPersonName": "PersonName 1"
 },
 {
 "CustomerName": "Customer C",
 "CustomerId": "3",
 "CustomerPersonId": "2",
 "CustomerPersonName": "PersonName 2"
 }
]

So the thing that i want is to do a lookup on customerpersonId and get the name of that person and add that to the first array.

I would prefer not to be forced to use variables since i have many rows to update and want to make it quick. I tend to belive that using vriables does not allow a for each loop in power autoamte to be that fast.

Categories:

Business Process Flows

All responses (4)

Answers (1)

ManishSolanki 15,085 Super User 2025 Season 1 on 08 Nov 2023 at 07:05:06

Like (1)

Report

Re: How to combine two arrays?

Hi @Oskarkuus

The idea is to convert the JSON into XML & using xpath query we can filter required value from xml node. The same concept applies to html also.

You can check out my blog where I have explained with a use case:

Power Platform Join arrays efficiently without using loops in Power Automate Select (technetty.com)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks