join

The join() function provides the ability to convert a list of values into a formatted, filterable text string.

Syntax

join(separator, value)

Argument Description
separator

(required)

A separator (, / ; : |) surrounded by quotations which will be used to separate the list value.
value

(required)

An association, pick list, or text attribute. Most commonly leveraged with a union or unionIf.

Where Available

Available in all places the expression or injected expression icon is visible except for Metric expressions.

Examples

Where Example(s)
Text Attribute Calculated Expression join("|", Owners_List__c

join(";", All_Territories__c)

Updated on May 4, 2026

Related Articles