Topic
This was a Salesforce change;
In the Spring ’17 release, they changed this behavior to protect your picklist integrations. From now on, each picklist value is represented with a label and an API name (similar to the name-value pair data representation):
- Picklist value’s label – displayed in a record through UI.
- Picklist value’s API name – used internally on metadata level.
Instructions
Solutions for this behavior are:
1. Use the Tolabel() SOQL function: https://community.nintex.com/t5/How-To/Drawloop-SOQL-aggregate-and-toLabel-fields-in-a-DocGen-Package/ta-p/213297
2. Create Excel as Middleware logic to Take the Value of Salesforce and push out the value desired.: https://community.nintex.com/t5/How-To/Drawloop-Excel-as-middleware-Connected-Data-and-Named-Ranges/ta-p/120828
3. Change the API Value to Match the Label Value. (This option will need to be reviewed with the environments Internal Salesforce Team)
Related Links
Keeping Picklist Integrations Safe by Using API Names - Salesforce Developers Blog
Allow Picklist Value Labels in Formulas
Allow Picklist Value Labels in Formulas