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?

2
  • Do you want to skip Commerce Cloud if the title contains B2B Commerce Cloud? 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. Jan 29, 2020 at 11:47

1 Answer 1

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