XRM tooling: Update pick list value to NULL

(0) Share

Report

Posted on by SavvyLuke

655

Folks, i'm stuck trying to set a picklist value to NULL using CRMServiceClient on a WPF form. Updating a picklist to another value works great, i'm just having trouble setting it to null or empty.

If i set it to something other than NULL, meaning a value that's not one in a picklist, then it displays empty null string correctly on the CRM form. But in the DB it's populated with that 'dummy' value which would sort of cause some confusion.

Here is what i have so far but it's throwing an error when i pass null in the wrapper. It works if i put "-1". Is this the value to use to reset the pick list to an unassigned value?

CrmServiceClient svcClient = ctrl.CrmConnectionMgr.CrmSvc;
Dictionary<string, CrmDataTypeWrapper> inData = new Dictionary<string, CrmDataTypeWrapper>();
inData.Add("new_srq",new CrmDataTypeWrapper(null, CrmFieldType.Picklist));

bool success = svcClient.UpdateEntity("account", "accountid", new Guid(guid), inData);

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

You should be able to set a field value to null using business rules if you have CRM 2015.

Was this reply helpful? Yes No
SavvyLuke 655 on at

Like (0)

Report

Jonathan, but wouldn't that only apply if the user opens a form? I need to update this field for about 15K records. And i can't set them to NULL or UNSELECTED.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have exactly the same problem as you; did you eventually find a solution?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I found the solution!

use CrmDataTypeWrapper(null, CrmFieldType.Raw)

Was this reply helpful? Yes No