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, Excel rows, API responses, 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	Conditional	The object property to filter by, project, group by, or sort by. Supports nested properties using dot notation (e.g. Address.City). Leave blank when the array is plain strings or numbers — the operation then works on each value directly.
Operator	Dropdown	No	How to compare the property value when using Where. Defaults to Equals. See Operators below.
Value	Text	Conditional	The value to compare against when filtering.
Skip Count	Text	Conditional	Number of items to discard from the beginning of the array.
Take Count	Text	Conditional	Maximum number of items to return from the beginning of the array.

Visibility Rules

Field	Visible when Operation is
Property Name	Where, Select, DistinctBy, OrderBy, OrderByDescending
Operator	Where
Value	Where
Skip Count	Skip
Take Count	Take

Operations

Operation	Description
First	Returns the first item in the array.
Last	Returns the last item in the array.
Where	Filters the array based on the Operator and Value. See Operators below. Leave Property Name blank to compare each value directly when the array is plain strings or numbers.
Select	Returns a flat list of values extracted from the specified property of each object. Leave Property Name blank to return each value as-is.
Distinct	Removes duplicate items from the array.
DistinctBy	Removes items that share the same value for the specified property, keeping the first occurrence. Leave Property Name blank to de-duplicate on each value directly.
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. Leave Property Name blank when sorting an array of plain strings or numbers.
OrderByDescending	Sorts the array descending by the specified property. Leave Property Name blank when sorting an array of plain strings or numbers.

Operators

The Operator field controls how the Where operation compares each item's property value against the Value field. If Operator is not set, it defaults to Equals.

Operator	Description
Equals	The property value must exactly match the Value. Also supports wildcard patterns — use * to match any sequence of characters and ? to match a single character (e.g. Admin*, file_??.pdf).
Does Not Equal	The property value must not match the Value.
Greater Than	The property value must be greater than the Value. Works with dates, numbers, and text.
Less Than	The property value must be less than the Value. Works with dates, numbers, and text.
Is Empty	The property value is null, empty, or whitespace. The Value field is ignored.
Is Not Empty	The property value is not null, empty, or whitespace. The Value field is ignored.

How comparison works

Greater Than and Less Than automatically detect the type of data being compared:

1. Dates — if both values can be parsed as dates, they are compared chronologically. Common formats like 2026-06-15, 06/15/2026, and 15 Jun 2026 are supported.
2. Numbers — if both values are numeric, they are compared numerically.
3. Text — if neither date nor number parsing succeeds, values are compared alphabetically (case-insensitive).

This means you can filter Excel rows to find dates after today, values above a threshold, or any other comparison — without needing to convert data types first.

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 exact property value

Return only the users with the role Admin.

Field	Value
Input Array	{{GetUsers.Result}}
Operation	Where
Property Name	Role
Operator	Equals
Value	Admin

Filter a plain string array

When the array is a simple list of strings (or numbers) rather than objects, leave Property Name blank so each value is compared directly. This returns only the entries equal to Approved.

Field	Value
Input Array	{{GetStatuses.Result}}
Operation	Where
Property Name	(leave blank)
Operator	Equals
Value	Approved

The same applies to Select, DistinctBy, OrderBy, and OrderByDescending — a blank Property Name makes them operate on each value directly.

Filter using a wildcard pattern

Return all files whose name starts with Report_.

Field	Value
Input Array	{{ListFiles.Result}}
Operation	Where
Property Name	FileName
Operator	Equals
Value	Report_*

Filter Excel rows by date

After reading an Excel file with ExcelCRUD (mode READ), return only the rows where the Due Date column is after today.

Field	Value
Input Array	{{ReadExcel.ExcelData}}
Operation	Where
Property Name	Due Date
Operator	Greater Than
Value	2026-06-15

Each row includes a _RowNumber property containing its Excel row number. Use this value with ExcelCRUD's UPDATE mode to write changes back to the correct row.

Find rows with a value above a threshold

Return items where the Amount property is greater than 1000.

Field	Value
Input Array	{{GetInvoices.Result}}
Operation	Where
Property Name	Amount
Operator	Greater Than
Value	1000

Find rows with empty values

Return items where the Email property is blank or missing.

Field	Value
Input Array	{{GetUsers.Result}}
Operation	Where
Property Name	Email
Operator	Is Empty
Value

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