Power Automate Repurpose an Array Step by Step Example with No Apply to Each

Based off of an example Power Platform support case https://powerusers.microsoft.com/t5/G..., I have prepared a demonstration of how to re-purpose an array, find the unique values, combine key/values, all without using an apply to each. Learn how to use compose and select action, build expressions using Union and JSON. See how I flatten an array using the replace action and call the first object using first. Example expressions are at end of the description.

Another Array video worth watching is here    • JSON Array in Power Automate - Walkth...  

Download my flow https://github.com/DamoBird365/PowerA...

00:00 Intro with an example scenario
01:38 Starting the build of our Flow to build an array of Unique Names
04:03 Using Select to create a unique Key/Name Pair
06:10 Flatten an array using Replace/JSON expression and a Compose
10:29 Using Select to dynamically build the new Array
15:10 Running the full solution
15:56 Run the Flow using a Larger Array ~2500 Rows from OneDrive
17:55 Summary & walk through the history of flow to demo the actions

#PowerAutomate #Arrays #Objects #Select #Compose

Example Expressions:
union(body('Select'),body('Select'))
json(replace(join(body('ComboKeys'),','),'},{',','))
first(outputs('NewArray'))?[concat(item(),'-Home Phone')] Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕