MS Dynamics Lookup Fields Display Unique IDs in Marketo

A document by on behalf of 9bbab3ec0a572302bfd523ca8d7abc5e747191b7 on Jun 1, 2017Last modified by Michelle Malkasian on Jun 1, 2017
Version 2Show Document
  • View in full screen mode

Issue Description

When data is synced to Marketo from lookup fields in Dynamics, the unique record GUID is put in the Marketo field rather than the name of the referenced record.


Issue Resolution
In Dynamics, the data stored in lookup fields is actually the unique ID of the referenced record. Since the record that is being referenced is also in Dynamics, the UI is able to display the name of the record rather than its unique ID. However, when the data for those fields is pushed to Marketo, it is still the unique IDs that are synced over, so you will see the long string of letters and numbers in the associated Marketo fields, and not the name of the records. A workaround for this behavior is to:

  1. Create custom fields in your CRM for each of the lookup fields that you intend to sync.
  2. Create a workflow in Dynamics that populates those fields with the name of the  referenced record, and stores it as a string of text. When those fields custom fields are synced to Marketo, the data will be displayed as the text that you want instead of the unique IDs.

Who This Solution Applies To

Customers with Dynamics integrations syncing lookup fields.