How to Extract String After Character in Power Automate?

Do you want to extract string after character using Power Automate flow? Then, this Power Automate tutorial is for you. Here, I will show you how to extract string after character in Power Automate with a few examples.

Scenario:

Recently, I got a requirement where I extract string after character using Power Automate flow. For example, if we have input values like below

Text@123

Once the string is presented after the character is extracted, it should display the value below:

123

Here, I will explain how to extract string after character using the Split() function in Power Automate with different examples.

Now, we will create a flow to extract string after character in Power Automate.

Cxtract string after character using Power Automate flow

Let us see how to extract string after character using Power Automate flow

Example – 1:

Step-1:

Create an instant cloud flow with a manual trigger; add two text input values to get the input string and the character to split.

power automate extract string after character

Step-2:

And another compose data operation, to split the values based on the character presented in the string input.

split(triggerBody()['text'],triggerBody()['text_1'])

Where,

  • Split – Function name
  • triggerBody()[‘text’] – input string
  • triggerBody()[‘text_1’] – character to split
How to extract string after character using Power Automate flow

Step-3:

Add another compose data operation, to get the output of the previous compose data operation.

outputs('Extract_String_after_character')[1]
How to extract string after character using Power Automate

Step-4:

Save and run the flow here. I have passed the input string as SPGuides@EnjoySharePoint passed the character as @, and selected the run flow option

Extract string after character using Power Automate

Once the flow runs successfully, we can see the expected output in the compose data operation; it splits and displays the value based on the character.

Extract string after character using Power Automate flow

This is how to extract string after character using Power Automate flow.

See also  How to Check Condition Contains String in Power Automate?

Example-2:

In this example, I will show you how to extract string after character from the SharePoint list text column using the Split() function in Power Automate flow.

Here, I am going to use the below Technologies SharePoint list, Consisting of

  • Technology – default title column
  • InputString– Single line of text type
Extract string after character in Power Automate

Now, we will create a flow to extract string after character for the Input String column presented in the SharePoint list.

Step-1:

Create an instant cloud flow with a manual trigger, Expand the trigger action, and add a text input to get the character to split

Example to Extract string after character using Power Automate flow

Step-2:

select Get items action from action triggers, and configure the required parameters.

  • Site Address – select the SharePoint site address from the dropdown
  • List Name – choose the SharePoint list. Here I have selected my technology list
Example to Extract string after character using Power Automate

Step-3:

Add a new step, choose an Apply to each control, and pass the value from the dynamic content

power automate extract string after character using split function

Add compose data operation to split the values based on the character presented in the input string field in the SharePoint list.

split(items('Apply_to_each')?['String'],triggerBody()['text'])
extract string after character using split function in power automate

Add another compose data operation, to get the output of the previous compose data operation.

outputs('Extract_String_after_character')[1]
How to extract string after character using Power Automate

Step-4:

Save and run the flow. I have passed the character & and selected the run flow option

Extract string after character in Power Automate flow

Once the flow runs successfully, we can see the expected output in the compose data operation,

In the SharePoint list for the first item, it splits and returns the value as ModernSharePoint

Example to Extract string after character in Power Automate

For the second item presented in the SharePoint list, it returns the value as Power BI

Example to Extract string after character in Power Automate flow

This is how to extract string after character presented in the SharePoint list field using flow.

See also  Power BI Pie Chart Conditional Formatting

Conclusion

I hope you can extract string after character in Power Automate flow. Here, I have shown you how to extract string after character using the Split() function with different examples in Power Automate.

You may like the following tutorials:

>