function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sean Carr 6Sean Carr 6 

Multiple Equals Criteria

I am trying to create a process and I need to evaluate multiple criteria the way I would in a workflow.  In this example I'm trying to evaluate if the state is a Canadian province.  I've tried State/Province EQUALS NB,NL,NS,ON,PE,QC,AB,BC,MB,SK,NT,NU,YT as well as using a formuala with contains such as CONTAIN( [Account].StateProvince,NB:NL:NS:ON:PE:QC:AB:BC:MB:SK:NT:NU:YT) but neither seems to work.  What format is process builder expecting to recieve in that field?
PratikPratik (Salesforce Developers) 
Hi Sean,

I just tried it in my Dev org. If you  try providing condition as 
State/Province EQUALS State/Province EQUALS NB,NL,NS,ON,PE,QC,AB,BC,MB,SK,NT,NU,YT the it will consider "NB,NL,NS,ON,PE,QC,AB,BC,MB,SK,NT,NU,YT" as one string.

Please provide one condition at a time and then OR all the conditions, it works.

Snapshot:
User-added image

Please try it and let me know if you face any issues.

Thanks,
Pratik

P.S. If this answers you question, please mark it as "Best Answer" so it will help other community members too.
 
Madhanprabhu Thangadurai 1Madhanprabhu Thangadurai 1
Hi Sean,

Try this. You should enclose the State Values list inside double quots "". 
CONTAIN( [Account].StateProvince,"NB:NL:NS:ON:PE:QC:AB:BC:MB:SK:NT:NU:YT")
https://help.salesforce.com/apex/HTViewSolution?id=000004749&language=en_US (https://help.salesforce.com/apex/HTViewSolution?id=000004749&language=en_US)

Please let me know if it doesn't work for you. Thanks.