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
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.
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156