Hello
I tried to get the Text values of PickList using both the above methods and both worked for me:
1. using Retrieve method, i created a method for this (took help of one internet link). Paste this method and call it with input parameters to get the string value of picklist.
private string GetOptionsSetTextOnValue(IOrganizationService service, string entityName, string attributeName, int selectedValue)
{
try
{
RetrieveAttributeRequest retrieveAttributeRequest = new RetrieveAttributeRequest { EntityLogicalName = entityName, LogicalName = attributeName, RetrieveAsIfPublished = true };
RetrieveAttributeResponse retrieveAttributeResponse = (RetrieveAttributeResponse)service.Execute(retrieveAttributeRequest);
PicklistAttributeMetadata retrievedPicklistAttributeMetadata = (PicklistAttributeMetadata) retrieveAttributeResponse.AttributeMetadata;
OptionMetadata [] optionList = retrievedPicklistAttributeMetadata.OptionSet.Options.ToArray();
string selectedOptionLabel = string .Empty;
foreach (OptionMetadata oMD in optionList)
{
if (oMD.Value == selectedValue)
{
selectedOptionLabel = oMD.Label.UserLocalizedLabel.Label;
break;
}
}
return selectedOptionLabel;
}
catch (System.ServiceModel.FaultException ex1)
{
string strEr = ex1.InnerException.Data.ToString();
return null;
}
}
2. Using LinQ:
using System.Linq; // add this namespace
using (OrganizationServiceContext orgSvcContext = new OrganizationServiceContext (service))
{
var query1 = from c in orgSvcContext.CreateQuery<ENTITY_NAME>()
where c["crm attribute1 in lower case"].Equals("value in string")
&& c["crm attribute2 in lower case"].Equals("value in string")
&& c["crm attribute3 in lower case"].Equals("value in string")
select new
{
picklistStringValue = c.FormattedValues["picklist crm attribtue in lower case"] // formattedValues to get label string name
}
;
foreach (var q in query1)
{
string strPicklistStringValue = q.picklistStringValue.ToString();
break;
}
}
