cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

power automate replace single quote with space

trying the below function two replace single quote(') with space("")

 

replace(variables('Testcomments'),"'","")

 

not working.Any suggestions please?

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @Anonymous,

Please modify you formula as below:

replace(variables('Testcomments'),'''','') // Replace the single quote with nothing

vqiaqimsft_1-1629264824713.png

 

vqiaqimsft_0-1629264797118.png

Further, if you want to leave space for the place where you put the single quote, you should use ' ', there should be a space between the single quotes:

replace(variables('Testcomments'),'''',' ')//Replace the single quotes with a space

And if you want a space to replace instead, you could get as below:

vqiaqimsft_2-1629264894163.png

Use the above formula according to your real needs

Best Regards,
Qi

View solution in original post

2 REPLIES 2
v-qiaqi-msft
Community Support
Community Support

Hi @Anonymous,

Please modify you formula as below:

replace(variables('Testcomments'),'''','') // Replace the single quote with nothing

vqiaqimsft_1-1629264824713.png

 

vqiaqimsft_0-1629264797118.png

Further, if you want to leave space for the place where you put the single quote, you should use ' ', there should be a space between the single quotes:

replace(variables('Testcomments'),'''',' ')//Replace the single quotes with a space

And if you want a space to replace instead, you could get as below:

vqiaqimsft_2-1629264894163.png

Use the above formula according to your real needs

Best Regards,
Qi
Anonymous
Not applicable

It Works Thank You

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,873)