[SalesForce] Process Builder error : The element has an invalid reference

I have a process builder on Account that updates values of its child record from Address object.

Field Zip in address need to be updated with concatenate value of Zip_vod__c + '_xxx'.
Formula :

[Account].Address_vod__c.Zip_vod__c & '_XXX'

But in the formula to set this updated value error the following error occurs :

'The element has an invalid reference to
"Account.Address_vod__c.Zip_vod__c". '

This formula allows to select field from Account object but not from its child object on which record update is needed. Please let me know if it is at all possible or not.

Please find my Process builder screenshot :

Best Answer

Simply use zip formula = zip_vod__c & '_XXX'

As if I can understand correctly both zip and zip_vod__c reside in same Address object which you are trying to update.

Related Solutions

[SalesForce] Process Builder Error with Bulk API

So it appears that if Process Builder fails on any record, it currently causes the entire batch to rollback.

The official workaround from Salesforce is to set the batch size to 1. The claim this will only cause a minimal impact to sync times... I beg to differ.

In my cases I was getting Unable to Lock Row exceptions because the Flow was updating related records (and two flows tried to update the same one). Turning off parrellel processing can help this, but no guaranteed you won't run into Row Lock issues due to users.

[SalesForce] how to pass prior and current value to apex when record changes through process builder

This can be achieved using below Class and Process Builder:

public class PrintInvocable {

public class MyInvocableVariable {
    @InvocableVariable(label='Id' required=true)
    public Id recId;

    @InvocableVariable(label='Old Value' required=true)
    public String oldVal;

    @InvocableVariable(label='Current Value' required=true)
    public String currVal;
}

@InvocableMethod(label='Old and Current Value' description='Print Old and Current Values')
public static void printOldAndCurrentValues(List<MyInvocableVariable> myInvocableVariableList) {

    for(MyInvocableVariable myInvocableVariable : myInvocableVariableList) {
        system.debug('recId=' + myInvocableVariable.recId + ', oldVal=' + myInvocableVariable.oldVal + ', currVal=' + myInvocableVariable.currVal);            
    }
}

}

Best Answer

Related Solutions

[SalesForce] Process Builder Error with Bulk API

[SalesForce] how to pass prior and current value to apex when record changes through process builder

Related Topic