Forum Discussion

User777's avatar
User777
Regular Visitor
3 years ago
Solved

Quotation mark in Text Filter

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 Retai...
  • nandukrishnavs's avatar
    nandukrishnavs
    3 years ago

    User777 

     

    Another method

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

     

SamInogic's avatar
SamInogic
Icon for Super User rankSuper User
3 years ago

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 [email protected]

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

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