Dynamics Community Forum Thread Details

Unable to retrieve option-set

Hello Guys,

I am facing a peculiar problem, where I am trying to retrieve the option-sets (Code snippet added below) but I get an error saying "Could not find optionset".
This only happens on production instance but it works fine on the developer instance. I have verified that the option-set I am trying to retrieve is present in that instance and the solution is published.

var retrieveOptionSetRequest = new RetrieveOptionSetRequest() { Name = optionName }; var response = (RetrieveOptionSetResponse)org.Execute(retrieveOptionSetRequest);

Here are some methods I use to get option set by label or by value. There is 2 for local options set and 2 for global option set. 1 returns the label and one returns the value based on what you are trying to accomplish. Hope this helps with what you are looking for. If it does please high the verified answer button. Thanks.

public string GetLocalOptionSetLabel(string entityLogicalName, string optionSetName, int value, IOrganizationService service)
        {
            XrmServiceContext crmContext = new XrmServiceContext(service);
            RetrieveEntityRequest retrieveDetails = new RetrieveEntityRequest
            {
                EntityFilters = EntityFilters.All,
                LogicalName = entityLogicalName
            };
            RetrieveEntityResponse retrieveEntityResponseObj = (RetrieveEntityResponse)service.Execute(retrieveDetails);
            EntityMetadata metadata = retrieveEntityResponseObj.EntityMetadata;
            PicklistAttributeMetadata picklistMetadata = metadata.Attributes.FirstOrDefault(attribute => string.Equals(attribute.LogicalName, optionSetName, StringComparison.OrdinalIgnoreCase)) as PicklistAttributeMetadata;
            OptionSetMetadata options = picklistMetadata.OptionSet;
            IList<OptionMetadata> OptionsList = (from o in options.Options
                                                 where o.Value.Value == value
                                                 select o).ToList();
            string optionsetLabel = (OptionsList.First()).Label.UserLocalizedLabel.Label;
            return optionsetLabel;
        }

public string GetGlobalOptionSetLabel(string optionSetName, int value, IOrganizationService service)
        {
            XrmServiceContext crmContext = new XrmServiceContext(service);
            string optionSetLabel = "";
            RetrieveOptionSetRequest retrieveOptionSetRequest = new RetrieveOptionSetRequest { Name = optionSetName };
            RetrieveOptionSetResponse retrieveOptionSetResponse = (RetrieveOptionSetResponse)crmContext.Execute(retrieveOptionSetRequest);
            OptionSetMetadata retrievedOptionSetMetadata = (OptionSetMetadata)retrieveOptionSetResponse.OptionSetMetadata;
            OptionMetadata[] optionArray = retrievedOptionSetMetadata.Options.ToArray();
            foreach (var option in optionArray)
            {
                if(option.Value.Value == value)
                {
                    optionSetLabel = option.Label.LocalizedLabels[0].Label;
                }
            }
            return optionSetLabel;
        }

        public int GetLocalOptionSetValue(string entityLogicalName, string optionSetName, string label, IOrganizationService service)
        {
            XrmServiceContext crmContext = new XrmServiceContext(service);
            RetrieveEntityRequest retrieveDetails = new RetrieveEntityRequest
            {
                EntityFilters = EntityFilters.All,
                LogicalName = entityLogicalName
            };
            RetrieveEntityResponse retrieveEntityResponseObj = (RetrieveEntityResponse)service.Execute(retrieveDetails);
            EntityMetadata metadata = retrieveEntityResponseObj.EntityMetadata;
            PicklistAttributeMetadata picklistMetadata = metadata.Attributes.FirstOrDefault(attribute => string.Equals(attribute.LogicalName, optionSetName, StringComparison.OrdinalIgnoreCase)) as PicklistAttributeMetadata;
            OptionSetMetadata options = picklistMetadata.OptionSet;
            IList<OptionMetadata> OptionsList = (from o in options.Options
                                                 where o.Label.UserLocalizedLabel.Label == label
                                                 select o).ToList();
            int optionsetValue = (OptionsList.First()).Value.Value;
            return optionsetValue;
        }

        public int GetGlobalOptionSetValue(string optionSetName, string label, IOrganizationService service)
        {
            XrmServiceContext crmContext = new XrmServiceContext(service);
            int optionSetValue = 0;
            RetrieveOptionSetRequest retrieveOptionSetRequest = new RetrieveOptionSetRequest { Name = optionSetName };
            RetrieveOptionSetResponse retrieveOptionSetResponse = (RetrieveOptionSetResponse)crmContext.Execute(retrieveOptionSetRequest);
            OptionSetMetadata retrievedOptionSetMetadata = (OptionSetMetadata)retrieveOptionSetResponse.OptionSetMetadata;
            OptionMetadata[] optionArray = retrievedOptionSetMetadata.Options.ToArray();
            foreach (var option in optionArray)
            {
                if (option.Label.LocalizedLabels[0].Label == label)
                {
                    optionSetValue = option.Value.Value;
                }
            }
            return optionSetValue;
        }

Quick Links

Leaderboard