join function. Collection.(Power Automate Cloud flows)

01/16/2024

Japanese version.

This function joins arrays by specifying a delimiter.

The result is text.

It works in the opposite way of split.

Spec

join(<collection>,'<delimiter>')
ArgumentDefaultDescription
collectionRequired fieldTarget array.
delimiterRequired fieldString.

How to use

In many cases, the type is used for "text" variable operations.

Clicking on join in the "Expression" tab sets the function name and () in the formula field.

The first argument is the array to be combined, and the second argument is the delimiter enclosed in '.

When dynamic content or variables are used in expressions, special specifications are required.

(How to get dynamic content with expressions.)

If you see something like the following, the setup is complete.

You can change the contents of the function by clicking on the purple icon.

For example, we have array variables ["A", "B", "C"].

If the expression is " join(variables('array variables'),',')", The result will be "A,B,C".

In the case of array items, they are automatically converted to text and combined.

---

Links

Collection Functions(Power Automate Cloud flows)