Flatten or Explode Nested Arrays in Power Automate #PowerAutomate #JSON #Tutorial


This video tutorial demonstrates how to flatten or explode nested arrays in Power Automate Cloud Flow. The traditional approach is inefficient and not scalable for larger data sets, so an advanced technique using Select, stringifying JSON, and expressions is shown to achieve the same output in just six actions. The video covers the requirements of a nested array, building a basic flow with nested apply to each, and then explains and demonstrates the efficient flow using Select and stringified JSON. It also includes information on writing data to Excel efficiently and joining data efficiently. The video provides timestamps for easy navigation and includes links to related videos on joining arrays and writing to Excel efficiently.


Video 2w

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