Escaping Single Quotes in PowerAutomate



I had a requirement recently to remove a single quote from a string in one of my PowerAutomates.


Simple enough you might think. Just use the 'replace' expression, right?


e.g.,

replace(string to process, text to replace, text to replace with)

So, initially I used the expression below :

replace(item()?['Column Display Name'],''','')       <- WRONG!

BUT IT DIDN'T WORK!


Why? Because you need to escape the single quote you are replacing - which means placing an extra single quote in front of it.


So the correct expression is:

replace(item()?['Column Display Name'],'''','')      <- RIGHT!

Much better :-)

14 views0 comments
Otagem Logo Wider.png