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?
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 :-)