How to Use Arrays in Power Automate

In this video, UG Expert and Microsoft MVP Kylie Kiser continues the conversation on Variables in Power Automate and focuses on one specifically — Arrays.

This episode is sponsored by Community Summit North America, the largest independent gathering of the Microsoft Business Applications ecosystem, taking place Oct. 13-17, 2024, in San Antonio, Texas. Register today to connect with thousands of users across the Microsoft business applications ecosystem at the for user, by user event.

Highlights

00:33 — Arrays in Power Automate are “simply just a table of data.” In this video, Kylie demonstrates how to use them in a flow. She opens up a “demo flow” to create an Array and starts by initializing the Variable before formatting the table.

01:18 — As she sets up the Array, she configures the variable’s ID and name. Once this is set, click the “Compose” button, which allows users to see the data in a table. After pressing the “Compose” button, users can run the flow and see the Array at work. Something to note with Arrays — they can either be appended or reset.

03:07 — Kylie continues to append her Array before testing it. She chooses to filter out certain rows and applies them to different Arrays.

04:06 — Arrays are a promising function for data operations, explains Kylie, especially when there are multiple tables of similar data.

05:21 — Finally, Kylie demonstrates how when a user hovers over the “Compose” button, they can see all of the details of the Array and choose to rewrite the expressions.


Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!