0

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?

Improve this question
2
  • Do you want to skip Commerce Cloud if the title contains B2B Commerce Cloud?
    – Rahul Gawale
    Commented Jan 29, 2020 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
    Commented Jan 29, 2020 at 11:47

1 Answer 1

Reset to default
2

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
7
  • 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
    Commented Jan 29, 2020 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
    Commented Jan 29, 2020 at 11:57
  • @CalinBostan can you update the new code in the question?
    – Rahul Gawale
    Commented Jan 29, 2020 at 11:57
  • 1
    I have updated my answer please check now. @CalinBostan
    – Rahul Gawale
    Commented Jan 29, 2020 at 12:09
  • 1
    It is perfect, thank you
    – Calin Bostan
    Commented Jan 29, 2020 at 13:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .