Substring in Text Functions Connector(Power Automate Cloud flows)

10/07/2023

Japanese version.

Similar to the expression function substring(), this action cuts out a portion of text by specifying a starting position and length.

This function is similar to the MID function in Excel.

How to use

Select the "Text Functions" connector when adding steps to the flow.

Select the "Substring" from the "Action" menu.

Set Parameters.

Cut out text from "Text" by the number of characters from the "Starting Position" to the "Length".

The beginning of the "Starting Position" is 0.

If "Length" is omitted, the result is cut out to the end of the text; if it is 0, the result is empty.

In the example of the capture, "BCD" is the result.

Dynamic Content

Dynamic content available in subsequent steps is "Substring".

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

Text Functions Connector(Power Automate Cloud flows)