Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

The lookup reference could not be resolved

Posted on by Microsoft Employee

I want to import records where the entity has a lookup field as a required field.

The value in the import file which should be used to match the record in the lookup field is an option-set field in the referenced entity.

I only have one record for each option set value in this referenced entity, but still everytime I got this error message:

The lookup reference could not be resolved

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The lookup reference could not be resolved

    Hi Rickard,

    that was it. I had to use the key (int)

    I didnt know this, since I can use the label of option set if importing directly into the entity

    Thanks.

  • Verified answer
    RE: The lookup reference could not be resolved

    Hi Donny,

    I don't know if I'd use an optionset as key for an object, but that's not something we need to discuss :)

    What are you entering as the key in the import file? If you are entering the label I don't think you can get a hit, but if you are using the key (an int) you should be able to get a hit on the optionset.

    Regards

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: The lookup reference could not be resolved

    Hi Rickard,

    it is a custom entity, lets say Entity A and there is a field called Key (Option-Set)

    The lookup field is referenced to Entity A

    In the import file I have the value of field Key and this should be used to match the referenced lookup record.

    There is only one record for each Key value in Entity A

  • RE: The lookup reference could not be resolved

    Hi,

    What entity are you referencing and how are you doing the import?

    If I'm reading you right you are trying to do an import where you use an optionset value as a key, isn't there a slight possibility that there are multiple records with the same optionset value set?

    Regards

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans