How to check if an OptionSet in a CRM field has a certain value
I have to check if a value is contained in an OptionSet of a field in CRM Online.
Is there a way to do this utsing the LOOKUP function ?
Something like this :
Where "account" is the table and "revenue" is the field that contains the OptionSet.