solving single quote issue in expression builder

Question

I have a map drifted column that i have to convert to string. but the filed name has a single quote in it. The source is from a json file. I tried adding additional quotes or even ''. but it doesnt work. PLease advise on how to resolve this conversion when there is a single quote in the column name.

toString(byName('Lse's Intu(abrupted)'))

Answer 1

Hi sam nick,

Thank you for posting query in Microsoft Q&A Platform.

I believe your expression is in dataflows. Please correct me if I am wrong. If yes, then kindly try to use double quotes for string as shown here

> toString(byName("Lse's Intu(abrupted)"))
> 
> ```

If you are planning have expression in pipeline expression, then check below suggestion.

> Try to have a variable create and store single quote as value in it. And then use `concat` function to build your string. 


Hope this helps. Please let me know how it goes.


---
Please consider hitting `Accept  Answer` button. Accepted answers help community as well.