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.

For those who want to learn Power Automate Cloud flow effectively

The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Power Automate Cloud flow to streamline your workflow.

Links

Collection Functions(Power Automate Cloud flows)