SOLVED

Multi-select SFDC field sync to Marketo creating different values

Go to solution
Devraj_Grewal
Level 10 - Champion Alumni

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.

1 ACCEPTED SOLUTION
SanfordWhiteman
Level 10 - Community Moderator

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.

View solution in original post

11 REPLIES 11