This function generates a single text output from a list, using an optional separator. For instance if you have a list of product names, you can use this function to create comma-separated list of products to include in an email.
The function works with lists of text, numbers, True/False, or Date & Time types. To create text from a list of objects, first use the Pluck function to get a list of the values from a single key of the objects, then pass that list into Join.
- list: The list to operate on. This can be a list of text, numbers, True/False, or Date & Time.
- separator (text): Characters that will be inserted in the output text between each item. It can be a single character like a comma or more than one character, like a comma followed by a space.
- text: The output text.