Quotation mark in Text Filter

[User777]

I am having trouble to filter data in new column:

I have new column which i want to be filled like 

Column 2 = if( [Retailer] = """KDK""", "YES", "NO")

The data i am looking for in column Retailer is "KDK"

Above syntax doesnt work for me for some reason, please give better solution

Thanks in advance.

[nandukrishnavs · Accepted solution]

@User777 

Another method

Column2 = 
VAR _text =UNICHAR(34)&"KDK"&UNICHAR(34)
VAR _result = IF([Retailer]=_text,"Yes","No")
return _result

[SamInogic]

Hi @User777 

It should work with your expression as shown in below screenshot,

Could you please provide any screenshot of your incorrect output or error message ?

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/