split String function(Power Automate Cloud flows)

Japanese version.

Converts text into an array by splitting it at specified delimiters.

It works in reverse of join and is mainly used for splitting CSV and TSV.


textRequired fieldTarget text.
delimiterRequired fieldString.

How to use

In many cases, it is used to initialize or set variable of type "Array".

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

The first argument is the text to be divided, 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.)

For example, an expression "split('aaa,bbb,cccc',',')" would be split into three items separated by commas.

TSV division is also possible by specifying TAB.

However, if you key in TAB as it is, it becomes a space.

Therefore, you need to type TAB in a text editor and then copy and paste it.

If you want to split by newline code, you must provide a variable.

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.


Collection Functions(Power Automate Cloud flows)