I have a calculated column with the below formula
If(Is New Mode,lookup("List","Id",fn-GetQueryString("Id"),"Title"), Child Title)
In the new mode, it fetches value from the Parent list and for other modes it fetches value from the child list "Child Title" column value.
in all scenarios works fine, but in one scenario it is failing. When the "Child Title" contains values with the single quote it is failing.
eg: Child Title column value is Bharathi's Demo. Works fine if value is Bharathis Demo
Please provide your help on this.