Power Automate Remove Characters From String [With Helpful Examples]

Recently, When I was working with Power Automate, I got a task to remove characters from a text string using Power Automate. This tutorial will explain how to remove characters from a string using Power Automate string() functions.

Also, I will cover the below topics:

• Power Automate: remove the first character from a string
• How to remove the last character from a string using Power Automate
• Eliminating the first and last characters from a string in Power Automate
• Removing multiple characters from a string using Power Automate
• How to eliminate specific characters from a string in Power Automate
• How to remove the last ‘n’ number of characters from a string in Power Automate

Remove First Character from a String in Power Automate

Now, let me show you how to eliminate a single character from a text string using Power Automate.

Example

To work around this, follow the below step-by-step:

1. Navigate to https://make.powerautomate.com to open your Power Automate home page -> Click on + Create -> Select an Instant Cloud Flow and assign a name to it -> Choose the trigger’s flow “Manually trigger the flow” and click on the Create button.

• Add a text input inside the trigger.

2. After that, take an Initialize variable flow action to initialize the text variable. Set the following details:

• Name: Provide the name of the variable.
• Type: Select the type of the variable as String
• Value: Here, I have given value from the dynamic content ‘Text‘.

3. Add the ‘Compose’ flow action to set the expression to skip the elements.

• Inputs: Select field -> Select Expression -> Insert the expression -> Click on OK.

skip(variables('Text'),1)

4. Now, it’s time to Save and Test -> Click on Save -> Test it Manually -> Then expand the compose flow action to display the output below.

Output:

The output will display the string by removing the first character.

This is how to remove the first character from a string using Power Automate.

You may also like: Remove Special Characters from a String in Power Automate.

Power Automate remove specific characters from a string

Let us see how to remove specific characters from a string using Power Automate flow.

In this example, I will show you how to remove characters from a string using flow

Example:

1. Create an instant clod flow with a manual trigger and add a text input.

2. Add a compose data operation and pass the below expression, which helps to replace the [ ” “] extra characters.

replace(replace(replace(replace(triggerBody()['text'],'[',' '),']',' '),'''',' '),'"',' ')

3. Save and run the flow, take the input value, and click the Run flow option.

4. Once the flow runs successfully like below, we can see that it removes the unwanted characters from the given value as shown below:

This is how to remove specific characters from a string using Power Automate flow.

Power Automate Remove Multiple Characters from the String

Now, I will discuss how to remove multiple characters from the string in Power Automate.

Follow the below steps:

1. Create an instant cloud flow and add a text input.

2. Take a Compose flow action and pass the below characters you want to remove from the input string.

"!","@","[","]","&"

3. Next to that, add select data operation from action triggers in the form section and pass the below expression:

range(0, length(triggerBody()['text']))

In the Map section, pass the below expression, which removes the character and returns the string value.

if(contains(outputs('Compose'),substring(triggerBody()['text'],item(),1)), '',substring(triggerBody()['text'],item(), 1))

5. Add another data operation and use the below expression to join the expression.

join(body('Select'),'')

6. Save and Run the flow. I have taken the Input value as shown in the screenshot below.

Click the Runflow button.

7. Once the flow runs successfully, we can see that it removes the characters and returns the string value.

This is how to remove multiple characters from the string using Power Automate functions.

How to Remove the Last Characters from a String in Power Automate

Let us see how to remove last character from string in Power Automate.

Follow the below steps:

1. Create a Power Automate Instant cloud flow with the text input.

2. Take the Compose flow action and pass the below expression in the Inputs section.

substring(triggerBody()['text'], 0, sub(length(triggerBody()['text']), 2))

3. Then, Save and Run the flow. I have provided the input value as given below:

4. Once the flow runs successfully, you can see that it removes the last characters from a given string.

This way, you can remove last character from string in Power Automate.

Power Automate Remove Last ‘N’ Number of Characters from String

Now, I will show you how to remove the last ‘n’ number of characters from a given string value using Power Automate.

Example:

Follow the below given steps:

1. Add a Compose flow action to give the expression.

Inputs: Add the code that is given below.

substring(variables('Text'),0,sub(length(variables('Text')),10))

In the above expression, Replace the number of characters you wanted to remove.

2. After that, save and test the flow. In the Runflow window, I’m taking the below text value.

Then, click Runflow.

Output:

This is how to remove the last ‘n’ number of characters from a given string with Power Automate.

Power Automate remove first and last character from string

Now, I will show how to remove the first and last character from a string using Power Automate.

Check out the steps:

1. Create an instant cloud flow with a manual trigger and add a text input.

2. Add a compose data operation and pass the below expression:

substring(triggerBody()['text'],1, sub(length(triggerBody()['text']),2))

After that, save and test the flow manually.

3. In the Runflow window, take the Input value. Click the Run flow option.

4. When the flow runs successfully, it will display the output of a string, eliminating the first and last characters.

Refer to the image below:

Here’s how to remove the first and last characters from a string using Power Automate.

Conclusion

I hope this Power Automate tutorial is helpful and guides you through remove character from a strin in Power Automate and the below related examples.

• Remove characters from string in Power Automate
• Remove the last character from a string in Power Automate
• Delete the last character from a string in Power Automate
• Remove everything after a character in Power Automate
• Remove the first character from a string in Power Automate
• Remove the first and last character from a string in Power Automate

You may also like:

• Remove Duplicate items from SharePoint List using Power Automate
• How to Remove Quotes from String in Power Automate?
• Remove line breaks from text in Power Automate
• Send a Message When a New Post is added in Microsoft Teams Team Channel in Power Automate

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.