Join items in collection

Use the Join items in collection action A tool for building the processes, logic, and direction within workflows. to join all the values of items in a specified collection A variable containing multiple items, such as email addresses. Collection variables are useful for storing and operating on query results. For example, you can set up collection variables for names, email addresses, and index values to store results from querying a list. You can then loop through items in a particular collection variable (names, emails, or index values). into a string. Each value is separated by a specified delimiter.

You can use this action to concatenate, or join, all collection items into a single string. For example, you can join all names in a target collection of reviewers as shown below;

Target collection

Index Item
0 Andy
1 John
2 Sally

Output for the target collection given above with the delimiter comma (,)

Andy,John,Sally

 

Before you start 

Add and configure the Join items in collection action

  1. Click the Operations action group in the action toolbox.
  2. or

    Type the action name or function in the Search field at the top of the action toolbox.

  1. Drag the Join items in collection action to the Designer canvas.
  2. Do one of the following to open the Action configuration window:

    • Double-click the action.
    • Click on the action and then click Configure.

    See Action configuration window for more information.

  3. Select the Collection variable that has the items to be joined in Target collection.
  4. Select or create an Output variable to store the string.
  5. Click Save.

For more information about the fields and settings, see Join items in collection fields and settings