0

I am updating an assignment node by adding a formula for the Premise County field but since the field is a Picklist, I am getting the below error:

IF( not(isblank({!Existing_Contact_Loop.Premise_County__c})), {!Existing_Contact_Loop.Premise_County__c}, {!$Record.Premise_County__c} )

Please assist with how to edit this formula. Thanks.

5
  • Hi Makena , is Premise County picklist field on Existing_Contact_Loop object? Jun 13 at 8:42
  • Premise County is a Picklist field on the Contact object
    – makena
    Jun 13 at 8:49
  • Can you please send the error?
    – Raphael D
    Jun 13 at 8:50
  • I am using a Formula in the Flow to check if the Premise County is already populated on the existing Contact and if so, leave it as is, otherwise populate it.
    – makena
    Jun 13 at 8:53
  • Here is the error: "The formula expression is invalid: Field Existing_Contact_Loop is a picklist field. Picklist fields are only supported in certain functions"
    – makena
    Jun 13 at 8:53

3 Answers 3

0

You can try that:

IF( ISPICKVAL({!Existing_Contact_Loop.Premise_County__c},''), {!Existing_Contact_Loop.Premise_County__c}, {!$Record.Premise_County__c} )

if you want to check that picklist field is empty use ISPICKVAL({!Existing_Contact_Loop.Premise_County__c},'')

1
  • I want to check that the picklist field is not blank that is populated with "{!Existing_Contact_Loop.Premise_County__c}" or if blank (not populated then use "{!$Record.Premise_County__c} "
    – makena
    Jun 13 at 8:57
0

You can try Text() to convert the picklist value and check Not(ISBLANK()) function to check it.

When you use the Picklist field to check or populate the values you have to use TEXT() or ISPICKVAL() functions .

IF(Not(ISBLANK(TEXT({!Existing_Contact_Loop.Premise_County__c}))),{!Existing_Contact_Loop.Premise_County__c},{!$Record.Premise_County__c})

Please find the trailhead module for the same.

2
  • I had tried this previously but got the same error
    – makena
    Jun 13 at 9:02
  • Is the flow record triggered on Contact object ? Jun 13 at 9:04
0

Thank you everyone for your help. Adding "TEXT" converted the picklist values to text hence I was able to use this expression:

IF( NOT(ISBLANK(TEXT({!Existing_Contact_Loop.Premise_County__c}))),
TEXT({!Existing_Contact_Loop.Premise_County__c}), 
TEXT({!$Record.Premise_County__c}) ) 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.