Power Automate Join or Merge Arrays Efficiently | No Apply to Each

Learn how to merge or join multiple arrays super quick with no apply to each. Using string techniques we can rebuild an array to form an object and access data directly using a primary key value. I will demonstrate the speed of the solution on three arrays containing 5,000 records, joining them one to many and one to one to form a new array in under 10 seconds.

This works in Power Automate or Logic Apps and on all data sources, SharePoint, Dataverse, APIs, JSON. Join related data in seconds, not hours.

00:00 Intro
00:52 Three datasets in SharePoint
01:52 Getting started with Power Automate
03:09 Understanding Array, Objects and Expressions
05:42 Repurposing an Array to form an Object
10:50 Joining 3 Arrays to form a new Array
16:19 Flow demo joining Arrays quickly
18:03 Outro

JSON Videos:
5 Challenges:    • Power Automate JSON Arrays: Fun, Prac...  
Basics:    • JSON Array in Power Automate - Walkth...  

Native JSON Beautifier for your Edge Browser https://learn.microsoft.com/en-us/mic...

#PowerAutomate #JSON #Array

Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕