Multi-select SFDC field sync to Marketo creating different values | Community
Skip to main content
Devraj_Grewal
Devraj_Grewal
New Participant
January 10, 2018
Solved

Multi-select SFDC field sync to Marketo creating different values

  • January 10, 2018
  • 2 replies
  • 6224 views

Hi Community,

I have a multi-select field in SFDC entitled "Job Function" and in SFDC the values are listed in alphabetical order like this: "Executive; Operations" or "Finance; HR". However, when that field is synced to Marketo, some records have the value "Executive;Operations" and others have "Operations;Executive". I attempted to mass update all of the "Operations;Executive" to "Executive;Operations" but every time the sync occurs, the value is reverted back to "Operations;Executive". "Finance; HR" syncs over in the correct alphabetical order, so some combination of values must lead to the issue.

Any idea as to why this is? It is making filtering by this field difficult since I need to accommodate two different values.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman

Yeah, by definition picklist values do not have a defined de/serialization (i.e. stringification) order -- so you must never filter on them as such.

2 replies

Victoria_Chu
Victoria_Chu
New Participant
July 13, 2018

Hi Devraj, I was poking around the community to see if anyone knows if Marketo supports syncing the values of a multi-select field to a multi-select field in SFDC, so the opposite of your current sync. How would that display on the SFDC side? I can't imagine SFDC would be able to take the multiple values and properly display them in SFDC. (Unless I just use a string field and concatenate the selections by a semicolon.) Let me know if you have any thoughts, thanks!

SanfordWhiteman
SanfordWhiteman
New Participant
July 13, 2018

if Marketo supports syncing the values of a multi-select field to a multi-select field in SFDC, so the opposite of your current sync.

That's not the opposite, that's exactly what Devraj has.

Unless I just use a string field and concatenate the selections by a semicolon.

A multi-select field is stored as a semicolon-delimited field in Marketo.

Victoria_Chu
Victoria_Chu
New Participant
July 13, 2018

Hey Sanford, I'm looking to sync the data only from Marketo to Salesforce, never the other way around.

How would a semicolon-delimited value in Marketo be displayed in Salesforce?

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
January 11, 2018

Yeah, by definition picklist values do not have a defined de/serialization (i.e. stringification) order -- so you must never filter on them as such.

Devraj_Grewal
Devraj_GrewalAuthor
New Participant
January 11, 2018

Thanks Sanford. That's unfortunate. What's odd is that some are in the correct order and others are not, even when it is the same value.

Devraj_Grewal
Devraj_GrewalAuthor
New Participant
January 11, 2018

I'll just have to use the workaround to ensure I capture all people meeting the criteria:

"Job Function: contains: Executive"

AND

"Job Function: contains: Operations"

Terms & ConditionsAccessibility statement

Loading footer...