List option lookup for CRM Online
Manny asked 7 years ago
Hello,
I’m having trouble importing one specific field from GP to CRM Online. The source is a string text field in GP and the destination is a CRM lookup field (AKA Option Set). The lookup only allows one selection on the CRM side. When I try to run the integration in SmartConnect, I get the following error:
Failed to set column [name] to a List Option lookup column : Sequence contains no matching element.
The field data on the GP side is text that matches the display name of one of the lookup options in CRM.
I’m having trouble importing one specific field from GP to CRM Online. The source is a string text field in GP and the destination is a CRM lookup field (AKA Option Set). The lookup only allows one selection on the CRM side. When I try to run the integration in SmartConnect, I get the following error:
Failed to set column [name] to a List Option lookup column : Sequence contains no matching element.
The field data on the GP side is text that matches the display name of one of the lookup options in CRM.
I restarted the eOne SmartConnect Service and it mysteriously started working…hmm.
OK, one more thing…. If the source (GP) data field is blank… Is SmartConnect able to send a “blank” record to the CRM option set? I have the List Option Lookup in SmartConnect configured to “Return blank if no match”. However, I’m getting an error for records that have “null” data in the GP source field. It’s the same error as I was getting before (Sequence contains no matching element).