Set value into lookup field

(0) Share

Report

Posted on by Community Member

I need to set a value to a lookup field but I don't know how to do that

this is the code I have

var entity = context.GetEntityFromContext().ToEntity<pwc_contract>();

var aircraftid = aircraftRetrieved.Entities[0].Attributes["pwc_aircraftid"];
var aircraftGuid = new Guid(aircraftid.ToString());
entity.Attributes["pwc_aircraftid"] = new EntityReference("pwc_aircraft", aircraftGuid);
                                
service.Update(entity);

the lookup field is "pwc_aircraftid"

I hope you can help me

thanks

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

necsa 3,455 on at

Like (0)

Report

Hi,

Which way do you want use. Using javascript or C#?

please let me know also

are you trying to read value from another entity or you want to set a value as you wish?

thanks

Happy CRM

Was this reply helpful? Yes No
Tobias Koller on at

Like (0)

Report

what exactly is not working? are you using this code inside a plugin?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The code is c#

and I'm doing a query to the same entity pwc_aircraft and I want to set the result value to the field

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes is a plugin

Was this reply helpful? Yes No
Verified answer

necsa 3,455 on at

Like (0)

Report
Lookup fields in CRM 2011 are EntityReference, this means you need to know the LogicalName of the entity the lookup is pointing and the Id of the record.

as example:

Account acc = new Account(); acc.Attributes["name"] = "Ram"; // this values got inserted acc.Attributes["age"] = "22"; // this values got inserted acc.Attributes["lookupfieldid"] = new EntityReference("contact", contactId); // if lookupfieldid is pointing to contact entity
service.Create(acc); // to create account

if you want to update;

as example:

Entity recordToUpdate = service.Retrieve("contact", contactId, new ColumnSet(true)); recordToUpdate["parentcustomerid"] = new EntityReference("account", accountId); service.Update(recordToUpdate);

first get the record to update, after set the lookup field with an EntityReference and after you save the record.

thanks

Happy CRM

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have the same code

entity.Attributes["pwc_aircraftid"] = new EntityReference("pwc_aircraft", aircraftGuid);

but the lookup field seems to be null, is that because I need to set the Name with the ID in the entityReference?

Was this reply helpful? Yes No
necsa 3,455 on at

Like (0)

Report

Yes you need always id.

thanks

Happy CRM

Was this reply helpful? Yes No
Tobias Koller on at

Like (0)

Report

I don't know exactly what you are doing with "context.GetEntityFromContext" (I get my context a liitle bit different) but I don't think this is a Problem here ;)

are you using earlybindings ?

if you want to set the lookup inside the entity for which the plugin is running and you registered it in "pre"-step, the plugin runs before the record is updated and you don't have to call "Service.Update(entity).

You only need to call the Update-Method manually when you want to update other entities or your plugin is running in Post-Mode.

Was this reply helpful? Yes No
necsa 3,455 on at

Like (0)

Report

please give more detail and add your code section where do you want to update.

thanks

happy CRM

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok the code is working now

but the problem the Name is displayed as null

Was this reply helpful? Yes No