Microsoft Dynamics CRM (Archived)

How to retrieve multi select option set field from crm using C#?

(0) Share

Report

Posted on by Community Member

Hello all!

How do I retrieve multi select option set field from crm using C#?

I tried this but it doesn't seem to work and it's a bit too advanced to me to debug.

http://www.itaintboring.com/dynamics-crm/dynamics-365-v9-multi-select-option-sets-c-and-sdk-versioning/

Can anyone show me how it's done?

Thank you!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Mahendar Pal 45,095 on at

Like (0)

Report

You share your code here so someone can look into that.

Was this reply helpful? Yes No
Verified answer

Justinjose 2,707 on at

Like (0)

Report
Hi Heimmu,

try something like this

QueryExpression queryAccount = new QueryExpression(); queryAccount.EntityName = EntityName; queryAccount.ColumnSet.Columns.Add("new_multiselectoptionset"); queryAccount.Criteria.AddCondition("name", ConditionOperator.Equal, "account name"); EntityCollection ec = _orgService.RetrieveMultiple(queryAccount); foreach (var item in ec.Entities) { OptionSetValueCollection op= (OptionSetValueCollection)item["new_multiselectoptionset"]; foreach (var options in op) { int i = options.Value; } }

Thanks

Justin Jose

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Hi Heimmu,

The article that was written by Alex Shlega was to provide the ability to query multiselect optionsets prior to the availability of the SDK, which contains the OptionSetValueCollection collection. Building it at this point, while the SDK provides you with that functionality is completely unnecessary.

At this point, you can use:

OptionSetValueCollection ovc = (OptionSetValueCollection)result["new_myOptionset"];

This will return the Collection of Values in the OptionSet.

You can the loop through the values in the collection to retrieve the individual values.

Hope this helps.

Was this reply helpful? Yes No
Verified answer

Inogic 709 on at

Like (0)

Report

You have to use latest 9.0 SDK dll i.e (include refer Microsoft.Crm.Sdk.Proxy.dll and Microsoft.Xrm.Sdk.dll in your c# Project)

To get 9.0 sdk from nuget use this link.

By using below code you will get the collection from MultiSelect Option set as shown in below screen shot:

Thanks!

Was this reply helpful? Yes No
Saddamk206 777 on at

Like (1)

Report

Hi,

Please try this:-

http://saddamk.blogspot.com/2018/09/insert-and-get-value-in-multiselect.html

Was this reply helpful? Yes No