Mathematically Elegant way to Flatten an Array of Arrays in Power Automate


When working with data in Power Automate, you may encounter nested arrays (arrays within arrays). In this post, the author shows a mathematically elegant way to flatten an array of arrays into a single-level array using Power Automate expressions. The slow way is to use an array variable, while the faster way is to use string manipulation. The new fastest way is to use div and mod flattening. The author provides an example and explains how this method works.


Article 6d

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time