Power Automate unlocked for Excel users (PART 2): collection functions

Let’s be real for a moment. If you are reading this, you have probably spent countless hours in Excel doing the same things over and over again. Well, most of us have been there struggling with manual work sucking the life out of us. And again most of us have been there thinking “But there has to be a better way!”. The good news is: there IS a better way.

To read the full story for free, click here.

In previous post, we had chance to get to know string functions — now we will focus on collection functions. In Power Automate, collection functions allow you to efficiently work with arrays. Whether you are processing data from Excel tables, SharePoint lists, or any dataset, these functions may help you to manipulate data without complex looping structures. Let’s explore the essential collection functions with examples and their Excel equivalents:

1. Chunk

Power Automate:

This function breaks an array into smaller sub-arrays of equal size. When working with large datasets in Power Automate, chunking allows you to process data in manageable batches, especially helpful for API calls with size limitations.

chunk(array, size)

// Break an array into chunks of 2 elements each…