Power Automate Join or Merge Arrays with Speed
May 1, 2023 1:50 PM

Power Automate Join or Merge Arrays with Speed

External YouTube Channel

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

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.

  • 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

More about Power Automate Join or Merge Arrays

Power Automate Join or Merge Arrays with Speed is a feature that allows users to join or merge multiple arrays quickly and easily. This feature simplifies the process of combining arrays of data into a single array, which can then be used in a variety of ways. This feature helps users save time and effort, as it allows them to quickly and easily join or merge data from multiple sources. This feature also ensures that data is properly formatted and organized, which makes it easier for users to analyse and interpret the data.

Mar 20, 2020 โ€” The INNER JOIN keyword selects records that have matching values in both tables. Inner Joins in Power Automate. I've built the following flow.

Jul 12, 2022 โ€” How to merge two seperate arrays into a single array in Power Automate using the xpath expression for maximum performance.

Jun 20, 2021 โ€” How to combine properties of multiple objects within an Power Automate Array into one big string without an Apply to each loop.

Dec 1, 2021 ยท 3 postsHere is one way to cross join two arrays. A Select can often be used to take one ATE out of a Flow and speed things up.