web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

The lookup reference could not be resolved

(0) ShareShare
ReportReport
Posted on by

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

  • Rickard Norström Profile Picture
    on at

    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

  • Community Member Profile Picture
    on at

    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

  • Verified answer
    Rickard Norström Profile Picture
    on at

    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
    on at

    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.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans