+ Start a Discussion
Christian TJuul MikkelsenChristian TJuul Mikkelsen 

Integration is able to load values that are not in the Picklist

Hi,

We have some integrations that loads data intosalesforce. These integrations some times load values into the Picklist that are not in the picklist.
HOw do you normally handle this? Is the only way to control this by creating reports and track it and correct it you self? Or can we force salesforce only to accept picklist values that are in the picklist? (I know that this would mean that we loose a lot of data)

Thank you for you help.

Best regards,
Christian
Best Answer chosen by Christian TJuul Mikkelsen
buyan thyagarajanbuyan thyagarajan
Hi Christian,
There is a recent release in winter 16 in pilot which should address it.
http://docs.releasenotes.salesforce.com/en-us/winter16/release-notes/rn_forcecom_general_restricted_picklists.htm
This would prevent unwanted values in picklists from populating in salesforce. Now for the existing records, you can do the following
1. Create a summary report and summarize by picklist values. You would find records with just odd picklist values which you can take action on later for your admins.
Does this help? If it helps, please click answer or like on my answer. Just curious.. How is the external application connecting to salesforce and what is the impact of it now?
Buyan