One of the key features of Power Automate is the ability to manipulate text using built-in functions and expressions. In this blog post, we will explore the substring function, which is used to extract a specific part of a string. This function is particularly useful for handling and processing text data efficiently.

What is the Substring Function?

The substring function in Power Automate extracts a portion of a string based on specified starting index and length parameters. This can be extremely helpful when you need to isolate specific sections of text from larger strings, such as extracting part numbers, date segments, or other formatted data.

Step-by-Step Guide to using the Substring Function

Step 1: Create a new instant cloud flow with a manual trigger

Step 2: Add a text input to the manual trigger

Step 3: Add an initialize variable action card with the following details

Step 4: Add a new compose action card with the following details:

Step 5: Add a substring action card with the following details:

Step 6: Save and Test the flow. Use “Friday” as the input.

Your results should be as followed: