I'm trying to search a single value of Column A in comma separated list in Column B. But unfortunately Contains doesn't work with the format "Contains([Procedure], [HCPCS])
Hi @monish_chandra
Not to diminish the utility of the solutions provided by @bpatel or @JShankman , but your initial Contains function had the fields reversed
"Contains([Procedure], [HCPCS])
The syntax is actually "Contains([Field to search in], [Value to find]) . if you change it to "Contains([HCPCS], [Procedure]), you'll find it returns true for the 1st record and false for the second
Dan
Try using the attached workflow. Hope this helps!
If you want to flag the record, I took what bpatel did and made a minor change to make it a bit more dynamic.
