MODIFIED CONTAINS IN-LIST MACRO

[bb213]

This is a macro that @MarqueeCrew  made to find an item in a list.  However, the macro as it exists does not suit my purposes.  I need the "Target Terms" to be an optional field in my workflow. I need to modify the macro so that if the "Target Terms" are left blank, all the records are allowed to pass. It's driving me crazy.

Thanks. 

[AbhilashR]

Hi @bb213, judging by the macro's functionality, it looks like it filters the dataset based on the values provided by the user. Not necessarily getting into its inner workings, would the Filter tool work in what you are looking to do?

[bb213]

 @AbhilashR What you just showed me is a simple filter.  I need the macro edited to give me the functionality i described. 

[AbhilashR]

Hi @bb213, Is this the output you are looking to get? i.e. the user doesn't enter any value in the Target Term(s) field and yet the workflow passes the data out?

If yes, then delete the Error Message tool inside the macro and save it. The Error Message macro was meant to force the user to type values, but since you looking to keep it optional, it serves no purpose.

Let us know if this helps.

[bb213]

if target terms is blank, every single record should pass through.  If target terms is populated, it should work as a the filter was designed. 

[AbhilashR · Accepted solution]

@bb213 - I modified the macro to pass every record if the Target Field(s) is blank, or function as a filter if the user types-in relevant value.

Solution attached for your reference.