How to get the option set from a field in an entity in CRM 2011 using crm sdk and C#

Question

How to get the option set from a field in an entity in CRM 2011 using crm sdk and C#? I just want to share with you guys a direct approach on getting the option set of a field in an entity.

possible duplicate of [how to get value/text from a OptionSet?](http://stackoverflow.com/questions/15479487/how-to-get-value-text-from-a-optionset) — Daryl, Apr 28 '14 at 12:47

score 13 · Accepted Answer · answered Apr 29 '14 at 01:35

The proper way to retrieve metadata information in Dynamics CRM is to retrieve only the information required. We should only retrieve the option set values based on the original question. Retrieving all the metadata for an entity when all the requirement specifies is the values for an Option Set is unnecessary and will create unnecessary overhead.

Here is the correct way to get the list of options for an Option Set.

    public static void GetOptionSet(string entityName, string fieldName, IOrganizationService service)
    {

        var attReq = new RetrieveAttributeRequest();
        attReq.EntityLogicalName = entityName;
        attReq.LogicalName = fieldName;
        attReq.RetrieveAsIfPublished = true;

        var attResponse = (RetrieveAttributeResponse)service.Execute(attReq);
        var attMetadata = (EnumAttributeMetadata)attResponse.AttributeMetadata;

        var optionList = (from o in attMetadata.OptionSet.Options
            select new {Value = o.Value, Text = o.Label.UserLocalizedLabel.Label}).ToList();


    }

Thanks @Nicknow. I got to say, this works better than my code. This is what i love in SO, someone can always share a better approach does helping each other to improve their standard in coding. — Romeo, Apr 29 '14 at 04:34

score 1 · Answer 2 · answered Apr 27 '14 at 13:36

This method needs the entity name, name of the field which contain the option set and the instantiated IOrganizationService.

using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Messages;
using Microsoft.Xrm.Sdk.Metadata;

    public void GetOptionSet(string entityName, string fieldName, IOrganizationService service)
            {
                RetrieveEntityRequest retrieveDetails = new RetrieveEntityRequest();
                retrieveDetails.EntityFilters = EntityFilters.All;
                retrieveDetails.LogicalName = entityName;

                RetrieveEntityResponse retrieveEntityResponseObj = (RetrieveEntityResponse)service.Execute(retrieveDetails);
                EntityMetadata metadata = retrieveEntityResponseObj.EntityMetadata;
                PicklistAttributeMetadata picklistMetadata = metadata.Attributes.FirstOrDefault(attribute => String.Equals(attribute.LogicalName, fieldName, StringComparison.OrdinalIgnoreCase)) as PicklistAttributeMetadata;
                OptionSetMetadata options = picklistMetadata.OptionSet;
                var optionlist = (from o in options.Options
                                   select new { Value = o.Value, Text = o.Label.UserLocalizedLabel.Label }).ToList();

                //from here you can do anything you want now with the optionlist

            }

Reference:
http://guruprasadcrm.blogspot.ae/2011/12/retrieve-optionset-text-in-crm-2011.html

I hope this will help some of you guys with your project.

You are retrieving too much information since you only need the available values you shouldn't need to retrieve all the Entity metadata. — Nicknow, Apr 29 '14 at 01:36

score 0 · Answer 3 · answered Apr 28 '14 at 05:18

0

Hey why not use this ??

OptionSetValue CountryOptionSet = Contact.Attributes.Contains("gr_address2_country") ? Contact["gr_address2_country"] as OptionSetValue : null;
 if (CountryOptionSet != null)
                     string Country = CountryOptionSet.Value.ToString();

answered Apr 28 '14 at 05:18

Dot_NET Pro

2,095
2
21
38

1

This will give you the integer value of the field. It will not give you a list of possible Values and their associated Label which is what the original question stated as the requirement. – Nicknow Apr 29 '14 at 01:37
But I am seeing the questions is: How to get the option set from a field in an entity :P he did'nt asked for possible list of values and their associated Label :/ – Dot_NET Pro Apr 29 '14 at 04:48
@Dot_Net Pro - When I code "Contact." I do not get the "Attributes" property you have above. What do I need to add so I can get that so I can use your code? – DeveloperM Jul 17 '15 at 15:29
@DeveloperM I have `Entity Contact = new Entity()` `Entity have Attributes property.` – Dot_NET Pro Jul 22 '15 at 06:16
@Dot_Net Pro: Sorry - I was thrown off by the color of the text - thought your "Contact" was the entity name, not an instance of the Contact entity. – DeveloperM Jul 22 '15 at 14:39

score 0 · Answer 4 · answered May 17 '16 at 17:10

depends if it's local or global. If it is local then:

string optionsetText = entity.FormattedValues["new_optionset"];

if its global then you need a lot more code:

        public static string GetoptionsetText(string entityName, string attributeName, int optionSetValue, IOrganizationService service)
    {
        string AttributeName = attributeName;
        string EntityLogicalName = entityName;
        RetrieveEntityRequest retrieveDetails = new RetrieveEntityRequest
        {
            EntityFilters = EntityFilters.All,
            LogicalName = EntityLogicalName
        };
        RetrieveEntityResponse retrieveEntityResponseObj = (RetrieveEntityResponse)service.Execute(retrieveDetails);
        Microsoft.Xrm.Sdk.Metadata.EntityMetadata metadata = retrieveEntityResponseObj.EntityMetadata;
        Microsoft.Xrm.Sdk.Metadata.PicklistAttributeMetadata picklistMetadata = metadata.Attributes.FirstOrDefault(attribute => String.Equals(attribute.LogicalName, attributeName, StringComparison.OrdinalIgnoreCase)) as Microsoft.Xrm.Sdk.Metadata.PicklistAttributeMetadata;
        Microsoft.Xrm.Sdk.Metadata.OptionSetMetadata options = picklistMetadata.OptionSet;
        IList<OptionMetadata> OptionsList = (from o in options.Options
                                             where o.Value.Value == optionSetValue
                                             select o).ToList();
        string optionsetLabel = (OptionsList.First()).Label.UserLocalizedLabel.Label;
        return optionsetLabel;

I got that from Guido on another similar question but rcados is missing the 3rd parameter. To get the text you just set

var foo = GetoptionsetText("lead", "picklist", 1234 , service)

assuming you have already declared IorganizationService

score 0 · Answer 5 · edited Feb 14 '18 at 05:27

There are two way to get text of OptionSet:

First:

OptionSetValue opProductType = new OptionSetValue();
opProductType = (OptionSetValue)item.Attributes[attributeName];
var optionValue = opProductType.Value;

Second:

var StatusString = TermAndCon.FormattedValues[attributeName].ToString();

(Set) Post OptionSet Value :

newSalesOrder[attributeName] = new OptionSetValue(Convert.ToInt32(optionValue));

How to get the option set from a field in an entity in CRM 2011 using crm sdk and C#

5 Answers5

Linked