Array Operations

Transforms an array by filtering, projecting, sorting, counting, or slicing its contents, and returns the result.

Purpose

Use Array Operations when a workflow holds a list of items and needs to narrow it down, reorder it, extract specific values, or measure its size before passing data to the next step. It works with both flat arrays and arrays of objects, making it suitable for any list-shaped data produced by earlier tasks — such as search results, database rows, or split strings.

Inputs

Field	Type	Required	Description
Input Array	Text	Yes	The array to operate on. Typically a variable reference from a previous task.
Operation	Dropdown	Yes	The transformation to apply. See the Operations table below.
Property Name	Text	No	The object property to filter by, project, group by, or sort by. Visible when Operation is Where, Select, DistinctBy, OrderBy, or OrderByDescending.
Value	Text	No	The value a property must equal for an item to pass the filter. Visible when Operation is Where.
Skip Count	Text	No	Number of items to discard from the beginning of the array. Visible when Operation is Skip.
Take Count	Text	No	Maximum number of items to return from the beginning of the array. Visible when Operation is Take.

Visibility Rules

Property Name is visible when Operation is Where, Select, DistinctBy, OrderBy, or OrderByDescending. Value is visible when Operation is Where. Skip Count is visible when Operation is Skip. Take Count is visible when Operation is Take.

Operations

Operation	Description
First	Returns the first item in the array.
Last	Returns the last item in the array.
Where	Returns only the items where the specified property equals the specified value.
Select	Returns a flat list of values extracted from the specified property of each object.
Distinct	Removes duplicate items from the array.
DistinctBy	Removes items that share the same value for the specified property, keeping the first occurrence.
Count	Returns the number of items in the array.
Skip	Returns the array with the first N items removed.
Take	Returns only the first N items of the array.
OrderBy	Sorts the array ascending by the specified property.
OrderByDescending	Sorts the array descending by the specified property.

Outputs

Name	Description
Result	The transformed array or value produced by the operation. For Count, this is a number. For First and Last, this is a single item. For all other operations, this is an array.
ResultCount	The number of items in the result array. Produced by all operations that return an array (not Count, First, or Last).

Examples

Filter objects by property value

Return only the users with the role Admin.

Field	Value
Input Array	GetUsers.Result
Operation	Where
Property Name	Role
Value	Admin

Extract a list of property values

Build a flat list of all user names from an array of user objects.

Field	Value
Input Array	GetUsers.Result
Operation	Select
Property Name	Name

Sort ascending by a property

Field	Value
Input Array	GetUsers.Result
Operation	OrderBy
Property Name	Age