Skip to main content

UNIQUE

Use the UNIQUE function to return the unique items in an array.

Use

UNIQUE( array )
Returns the unique values in an array.

ParameterRequiredDescription
arrayYesan array (any type)

ReturnsArray of unique values matching the type of array

Examples

Deduplicating User-Defined Approver Lists (Variable Update)

In workflows where a submitter manually selects a list of reviewers (User-defined assignment), they might accidentally select the same person multiple times,. You can use UNIQUE in a Variable Update formula to clean this list before the assignment occurs.

  • Scenario: A "Project Launch" trigger allows the submitter to pick several team members for a review. If they accidentally add "Adele Vance" twice, the assignment might become redundant.
  • Formula: UNIQUE(@Trigger.out.TeamReviewers),
  • Logic: The function scans the PersonArray provided by the trigger. It identifies the duplicate "Adele Vance" entry and removes the second instance.
  • Result: The resulting array contains each person only once, ensuring the Activity Step is assigned to a clean, unique list of individuals,.

Identifying Unique Cost Centers from Line Items (Input Mapping)

When dealing with multi-valued data, such as a list of line items in an expense report, you may want to extract a list of all unique categories involved without repeating them,.

  • Scenario: A user submits an order form with five line items. Three items are for "Hardware" and two are for "Software." You need to display a summary to a manager that lists which departments/categories are involved in the total spend.
  • Formula: UNIQUE($CategoryList),
  • Logic: The formula targets a TextArray (e.g., Software).
  • Result: The function returns a simplified array: Software. This can then be mapped to a Display Data element on a form to show the manager exactly which unique categories are being billed,.