Are you trying to replace a double quote with a single quote using Power Automate?
I will help you with this.
In this tutorial, I will explain how to replace double quotes with single quotes using Power Automate.
Replace Double Quote with Single Quote using Power Automate
To explain this example, I will manually take a text string surrounded by double quotes. Below, you can see the string with double quotes:
"Product Name" : "Laptop", "Price" : "75000", "Warranty" : "2 Years"Now, I wanted to replace the double quotes in the string mentioned above with single quotes using Power Automate.
Check out the steps below to know how to do it:
- Open the Power Automate Home page by typing make.powerautomate.com in the browser. Click on “+ Create” and then select “Instant Cloud Flow.” Select ‘Manually trigger a flow,’ and then click the Create button.
- Then, declare a text string value in a variable that can be used in the following steps. So, add an ‘Initialize variable‘ action and set the name for the variable, type as ‘String‘, and value with the text mentioned above.
- After that, take a ‘Compose‘ action to use the replace() expression that replaces double quotes with single quotes.
- Inputs: Insert the expression placed in the code below.
replace(variables('VarProducts'),'"','''')Note:
To replace the double quotes with single quotes in a string, you need to use two single quotes in the replace expression.
The flow is completed now.
- Next, click on the save icon to save the flow. Test the flow. On the Runflow window, select the Manual radio button, and click on the Runflow button.
- When the flow is executed, check the compose outputs for the result obtained. Refer to the image below.
Output: Replaced string with single quotes
Now you know how to replace double quotes with single quotes in a string using Power Automate!
If you found this guide helpful, feel free to share your feedback or suggestions in the comments below.
You might also be interested in these Power Automate tutorials:
- Replace String in JSON Power Automate
- Replace Value in an Array in Power Automate
- Replace Commas With New Lines in Power Automate
- Replace Special Characters in a String Power Automate
- How to Replace New Line with <Br> using Power Automate?
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.
