Power Automate Functions - Substring Function

Power Automate Functions-Substring Function


Substring Function

What is the Substring function?

Substring is used to extract some part of it. Like you can extract the first name using the ‘substring function’. You have to give the index from where this function starts extraction.

Description:

In this guide, we will discuss how to use the float function in power automation. Let us create a new flow. To create a new flow follow the following instructions:

Go to power Apps:

Power Automate Functions-Substring Function


Navigate to Flows:

Power Automate Functions-Substring Function

Click on the ‘New Flow’ button:

Power Automate Functions-Substring Function

After clicking new flow, select ‘Instant Cloud flow’ from the dropdown:

Power Automate Functions-Substring Function

Finally set its name and select ‘manually’ as flow trigger point:

In the below screenshot we set the Name of flow and its trigger point which is ‘Manually trigger a flow. Finally, click on the create button to create a new flow. 

Power Automate Functions-Substring Function

First, add INITIALIZE VARIABLE ACTION:

To initialize a variable select initialize variable action from the actions set. Then set its properties the same as mentioned in the screenshot.

1# INITIALIZE VARIABLE ACTION

INITIALIZE VARIABLE:

Initialize a variable having the following attributes. 

Name: set variable name

Type: set the type of variable as ‘STRING’

Value: BELIEVE YOURSELF IF YOU WANT TO MAKE YOURSELF SUCCESSFUL MAN

Power Automate Functions-Substring Function


1# ADD COMPOSE ACTION

Add compose action to call ‘substring’ function in it

CODE:

substring (variables ('NEW STRING'), 8)

8 means that after 8 characters extract reaming string.

Power Automate Functions-Substring Function

OUTPUT:

Power Automate Functions-Substring Function

 

 

0 Comments

Thanks for commenting. Your comment will be live soon after approval.