How to add Lookup Value to form field using C#

(0) Share

Report

Posted on by Community Member

Hello,

I am trying to add a value to a lookup field on a CRM phone, via C# code.

The lookup field value already exists - I just want to populate the CRM form field (linked to the lookup) with this value.

The lookup is a custom entity with just one field and I know the value of the field but not the GUID.

Does anyone know how I can add it without knowing the GUID, using something like EntityReference??

Many thanks,

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (3)

Verified answer

Aiden Kaskela 19,696 on at

Like (1)

Report
Copy link

Link copied!

Hi Seamus,

If you're trying to set the value of a lookup, you need to have the ID of the record. You'll be able to get the ID by querying for the record where the Field Value equals your known Value. Your query should get back a single result (with the ID), and you'll set that on the lookup. An easy way to query is using the RetrieveMultiple request - msdn.microsoft.com/.../microsoft.xrm.sdk.iorganizationservice.retrievemultiple.aspx

Hope this helps! I'd appreciate if you'd mark this as a Verified answer.

Thanks,

Aiden

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Just FYI one of EntityReference's properties - Id with type of Guid. You have to have Guid to update a lookup field.

If you have value of a primary entity field you can get id by field name using RetreiveMultiple operation.

Was this reply helpful? Yes No
Seamus 1,577 on at

Like (0)

Report
Copy link

Link copied!

Thanks for this. This is for an import so rather than make 1000s of retrievemultiple calls would it be a viable alternative to populate a list with the lookup field values and do a linq query on the list using the (unique) attribute value?

Was this reply helpful? Yes No
Seamus 1,577 on at

Like (0)

Report
Copy link

Link copied!

I would like to mark this as verified answer but for the hell of me I cant see how to!???

Was this reply helpful? Yes No
Suggested answer

Seamus 1,577 on at

Like (0)

Report
Copy link

Link copied!

Thanks again

Was this reply helpful? Yes No
Verified answer

Aiden Kaskela 19,696 on at

Like (0)

Report
Copy link

Link copied!

Hi Seamus,

If you can do a single query to get back all your values and filter that, that would be a lot faster/better than making a thousand calls for the same data. To mark an answer verified, look at the posts you'd like to approve and on the right side of the post there should be a question "Was this post helpful?" or something, Yes/No. If you select yes, it will show as a Verified answer.

Thanks again!

Aiden

Was this reply helpful? Yes No
Seamus 1,577 on at

Like (0)

Report
Copy link

Link copied!

Access Denied

You do not have permissions to perform the requested action.

when I try to verify answer!! I will keep trying!

Was this reply helpful? Yes No
Saddamk206 777 on at

Like (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);

Was this reply helpful? Yes No