I have the following entry criteria in the Process Builder

!ISBLANK([Material_Request__c].Out__c.Email_Address__c )&&
   NOT(ISBLANK([Material_Request__c].Out__c) )&&
     [Material_Request__c].Returnable_Flag__c == true &&

The problem with this is that the Process builder is not supposed to execute when material_request__c.out__c is null. However, this is not happening and it is entering the Execution Actions and throwing an error. I have tried various permutation combinations of NOT(ISBLANK([Material_Request__c].Out__c) ).

Material_Request__c].Out__c is a lookup field

Can someone tell me what I am doing wrong?

  • Have you tried ISNULL instead? – Adrian Larson May 1 '17 at 15:29
  • I did try isnull. It is still not working. – Rimii May 1 '17 at 15:30
  • try to do !ISBLANK([Material_Request__c].Out__c) validation prior to !ISBLANK([Material_Request__c].Out__c.Email_Address__c) – o-lexi May 1 '17 at 17:01
  • You are a life saver. Thanks @Oleksiy. Please put this as answer so that I can accept this. – Rimii May 1 '17 at 17:27

Try to do !ISBLANK([Material_Request__c].Out__c) validation prior to any field validation(s) from this related record:

[Material_Request__c].Returnable_Flag__c &&
!ISBLANK([Material_Request__c].Return_Date__c) &&
!ISBLANK([Material_Request__c].Out__c) &&
| 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.