Streamlined Inner Join

[Anonymous]

 I have two arrays with a key column, how can I join on the matching keys and bring in the columns (OBJECTS) from both arrays?
There are approximately 3,000 items in each array, so I am looking for something that won't run for 2 weeks.

[v-bofeng-msft]

Hi @Anonymous :

   At present, what I can think of is to use two nested apply to each action to achieve it, but this means that this will create a loop of 3000*3000=9000000 times. The performance of this flow will be very poor, and I can’t ensure that this flow can run normally to the end, which is why I do not recommend using Flow to achieve this requirement.

  I suggest you import the data into the database, and then use inner join to achieve this requirement.

Best Regards,

Bof