How to Retrieve the value of a lookup field within a plugin

(0) Share

Report

Posted on by Alaa Ramadan

4,130

I am trying to retrive the Primary contact name within the account entity in a PlugIn so i can send to an external database, the flooiwng code return error regarding the key is not exist in the dictionary, do i miss any thing? could you help please?

Lookup contactLookup = (Lookup)entity.Properties["primarycontactid"];

string sPrimaryContact = contactLookup.name;

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

are you getting an error message like it?

"the property not fount in the current dictionary"

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

In CRM 2011

You can not use as you were using you can use in the following way

   targetEntity = (Entity)context.InputParameters["Target"];

   if (targetEntity.LogicalName == "account")

{

if (targetEntity.Attributes.Contains("primarycontactid"))

{

//// Get the primary contactid;

EntityReference contactId=(EntityReference) targetEntity.Attributes["primarycontactid"];

//// from there get the GUId of the Primarycontactid and again need a call to sdk to get the name of the contact for that particuar GUId.

/* there is no way to retrive the name vlaue of the lookup as we do in client sidescripting in plugins */

}

}

In CRM 4.0

DynamicEntity   targetEntity = (DynamicEntity)context.InputParameters["Target"];

if (targetEntity.Contains("primarycontactid"))

{

//// Get the primary contactid;

Lookup contactId=(Lookup) targetEntity["primarycontactid"];

//// from there get the GUId of the Primarycontactid and again need a call to sdk to get the name of the contact for that particuar GUId.

/* there is no way to retrive the name vlaue of the lookup as we do in client sidescripting in plugins */

}

}

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Alaa Ramadan,

This might be useful to you,

https://santoshmscrm.wordpress.com/2015/06/22/how-to-retrieve-lookup-name-and-id-through-plugin/

Was this reply helpful? Yes No
ashishkhanna 180 on at

Like
a
(2)

Report
Copy link

Link copied!

What version of CRM are you using? Is it 2011 onwards or 4.0?

If 2011 or later, then use this instead:

Guid ContactId = ((EntityReference)entity.Attributes["primarycontactid"]).Id;

string sPrimaryContact = ((EntityReference)entity.Attributes["primarycontactid"]).Name;

Was this reply helpful? Yes No
Suggested answer

Hamzeh Zawahreh 3,674 on at

Like
a
(0)

Report
Copy link

Link copied!

dear Alaa Ramadan

you can get lookup value from plugin using entity refrene likr this:

EntityReference
contactlookup = (EntityReference)targetEntity.Attributes["new_contact"];

see this:

https://social.microsoft.com/Forums/en-US/8a3af20a-fbe4-480e-892c-021fe9605672/crm-2011-get-lookup-text-value?forum=crmdevelopment

Was this reply helpful? Yes No
Suggested answer

Hamzeh Zawahreh 3,674 on at

Like
a
(0)

Report
Copy link

Link copied!

dear Alaa Ramadan

and this if you want to use it in javascript:

var lookupObject = Xrm.Page.getAttribute("yourlookupattributename");

   if (lookupObject != null)

{

       var lookUpObjectValue = lookupObject.getValue();

       if ((lookUpObjectValue != null))

     {

         var lookuptextvalue = lookUpObjectValue[0].name;

       var lookupid = lookUpObjectValue[0].id;

       }

}

Was this reply helpful? Yes No
Suggested answer

Hamzeh Zawahreh 3,674 on at

Like
a
(0)

Report
Copy link

Link copied!

hi

here is sample on how get product lookup guid and name:

Entity entity = (Entity)context.InputParameters["Target"];

if (entity.LogicalName == "new_producttaxrate")

{

if (entity.Attributes.Contains("new_product"))

{

EntityReference ownerLookup = (EntityReference)entity.Attributes["new_product"];

productName = ownerLookup.Name;

Guid productId = ownerLookup.Id;

}

}

Was this reply helpful? Yes No
Suggested answer

Aileen Gusni 44,524 on at

Like
a
(0)

Report
Copy link

Link copied!

Alaa,

You must change 'Lookup' to 'EntityReference'

And please be remember that if you use it on update plugin, you might need to register preimage (for pre and postimage for post) to get this record field, it is very important, especially when you update a record but didn't update this primarycontactid, you will get return error, object reference or string was not exists in the dictionary.

I think your case here is either because you still using lookup (which is CRM 4.0 syntax (I don't know what crm version you are currently using) and my suspect is because you don't have image to get the old value which is not changed when you run the plugin.

Hope this helps!.

Thanks.

Was this reply helpful? Yes No
Saddamk206 777 on at

Like
a
(1)

Report
Copy link

Link copied!

Get Value of Lookup fields

EntityReference entref = (EntityReference)item.Attributes[attributeName];

var LookupId = entref.Id;

var logicalName = entref.LogicalName;

Set Value of Lookup fields

newAccount[attributeName] = new EntityReference(logicalName, LookupId);

Set Null Value of Lookup fields

newAccount[attributeName] = Null;

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Refer Below link

aspsolutionkirit.blogspot.in/.../getting-vlaueidname-of-lookup-field-in.html

Was this reply helpful? Yes No