UNIQUE
Use the UNIQUE function to return the unique items in an array.
Use
UNIQUE( array )
Returns the unique values in an array.
| Parameter | Required | Description |
|---|---|---|
| array | Yes | an array (any type) |
| Returns | Array 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,.