hero image
Function Friday - Collection Functions: Contains, Item, Join

For the last group of collection functions, we’re taking a look at the functions that focus on the items in the collection itself. Contains The contains function details whether or not a collection contains a specific element. The result is a boolean value (true/false). The pattern is as follows: contains('collection', 'value') contains([collection], 'value') The exact way it works depends on what the collection is. If the collection is a string, the contains function works to find a substring of characters.

Friday, June 17, 2022 | 2 minutes Read
hero image
Function Friday - Collection Functions: Intersection, Union, Skip, Take

For the second batch of collection functions we’re taking a look at the functions that let you work with the collections themselves. These functions let you slice, dice, and merge one or more collections together. Intersection The intersection function compares two or more collections and returns a new array that contains only the elements that exist in all the passed in collections. The format is as follows: intersection(collection1, collection2, ...) As with all the functions, you can pass in collection variables or literals, and strings are treated as character arrays.

Friday, June 10, 2022 | 3 minutes Read
hero image
Function Friday - Collection Functions - First, Last, Empty, Length

Power Automate contains excellent support for working with collections of objects. Generally, these will be treated as arrays of objects. However, these functions will also work with strings as, in Power Automate, strings are also considered a collection, as they are essentially an array of characters. As such, Power Automate contains a good selection of functions for working with these collections. For my return to functions in Power Automate, we’ll take a look at the first group of collection functions: First, last, empty, and length.

Friday, June 3, 2022 | 3 minutes Read