I've created a process to update a multi-picklist (Cloud Name) based on some words contained in a text field (Title) - it works but due to the pick values I am getting false positive.

enter image description here

if(Contains([Contact].Title , "Marketing Cloud"), "Marketing Cloud;", "") +if(Contains([Contact].Title , "Commerce Cloud"), "Commerce Cloud;", "") +if(Contains([Contact].Title , "B2B Commerce Cloud"), "B2B Commerce Cloud;", "")

My problem is, if the Title Contains B2B Commerce Cloud, the process populates with both "B2B Commerce Cloud" and " Commerce Cloud". Is there a way around this?

  • Do you want to skip Commerce Cloud if the title contains B2B Commerce Cloud? – rahul gawale Jan 29 at 11:24
  • If contains B2B Commerce Cloud, I want the picklist to populate only with B2B Commerce Cloud and not also with Commerce cloud. A title can contain both Commerce Cloud and B2B Commerce cloud, than the picklist should be updated with Commerce Cloud and B2B Commerce cloud. – Calin Bostan Jan 29 at 11:47

You will need to add the condition below. While checking for Commerce Cloud you can get rid of B2B Commerce Cloud from the title, using the SUBSTITUTE method.

if(Contains([Contact].Title , "Marketing Cloud"), "Marketing Cloud;", "") + 
if(Contains(SUBSTITUTE([Contact].Title, "B2B Commerce Cloud", "") , "Commerce Cloud"), "Commerce Cloud;", "") +
if(Contains([Contact].Title , "B2B Commerce Cloud"), "B2B Commerce Cloud;", "")
| improve this answer | |
  • still the same result ... If I put B2B Commerce Cloud in the Title, the multi-picklist is populated with both Commerce Cloud and B2B Commerce Cloud – Calin Bostan Jan 29 at 11:51
  • Correction: your formula partially works: if contains B2B Commerce Cloud it will update only with B2B Commerce Cloud, but if contains both B2B Commerce Cloud and Commerce Cloud it will only update with B2B Commerce Cloud. – Calin Bostan Jan 29 at 11:57
  • @CalinBostan can you update the new code in the question? – rahul gawale Jan 29 at 11:57
  • 1
    I have updated my answer please check now. @CalinBostan – rahul gawale Jan 29 at 12:09
  • 1
    It is perfect, thank you – Calin Bostan Jan 29 at 13:49

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.