1

I have written the following formula in my process builder

[Lead].Source_Opportunity__c != null &&

(ISBLANK(TEXT([Lead].Source_Opportunity__r.Source_details__c)) &&

NOT(ISBLANK(TEXT([Lead].LeadSource))) &&

ISPICKVAL([Lead].LeadSource ,  'Trig') &&

NOT(ISBLANK(TEXT([Lead].Source_Opportunity__r.Business_Line__c))) &&

ISPICKVAL([Lead].Source_Opportunity__r.Business_Line__c , 'BL'))

Here there is a opportunity related to a lead. Now, if I try to create a new lead, without an opportunity, the Flow is throwing an error despite having the not null check. Is there anything wrong with the formula?

Source_Opportunity__c is a lookup

All other fields are picklist

  • as others have pointed out, the PB evaluation of conditions doesn't necessarily work from first-to-last with early exit. Hence, try putting in an initial decision block for null Lead.Opportunity__c (e.g. ISBLANK([Lead].Opportunity__c) ) and bail out early. – cropredy Nov 18 '19 at 19:06
1

based on doc you should try ISBLANK

AND(NOT(ISBLANK([Lead].Source_Opportunity__c)),

(ISBLANK(TEXT([Lead].Source_Opportunity__r.Source_details__c)) &&

NOT(ISBLANK(TEXT([Lead].LeadSource))) &&

ISPICKVAL([Lead].LeadSource , 'Trig') &&

NOT(ISBLANK(TEXT([Lead].Source_Opportunity__r.Business_Line__c))) &&

ISPICKVAL([Lead].Source_Opportunity__r.Business_Line__c , 'BL')))
| improve this answer | |

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.