You need to sign in to do that
Don't have an account?
Dave The Rave
Process Builder - Formula Problem with Picklist fields
Process Builder - Formula Problem with Picklist fields
Within the formula section of the 'Immediate Actions' on the Process Builder, how can I join the text values together of the following 2 fields:
case.suppliedcompany
case.webproduct__c (picklist)
[Case].SuppliedCompany & TEXTVALUE([Case].WebProduct__c )
Expected Result: Case.Description = 'Salesforce Product123'
Error Message:
'The formula expression is invalid: Field Case is a picklist field. Picklist fields are only supported in certain functions'
See screenshot also
Within the formula section of the 'Immediate Actions' on the Process Builder, how can I join the text values together of the following 2 fields:
case.suppliedcompany
case.webproduct__c (picklist)
[Case].SuppliedCompany & TEXTVALUE([Case].WebProduct__c )
Expected Result: Case.Description = 'Salesforce Product123'
Error Message:
'The formula expression is invalid: Field Case is a picklist field. Picklist fields are only supported in certain functions'
See screenshot also
Your query is answered here,
https://salesforce.stackexchange.com/questions/203205/the-formula-expression-is-invalid-field-case-is-a-picklist-field-picklist-fiel
https://developer.salesforce.com/forums/?id=906F0000000Ba3FIAS
Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Thanks.
i'm not familiar with Textvalue as a formula.
regards
Andrew