How to identify if a field contains a word from an attached list

[chickenlicken]

I'm trying to work out a good way of building a workflow that looks at a list and identifies whether a field contains a value from that list.

My attached workflow works ok for short terms but in reality there might be 10+ words in the Name field and I don't want to have to configure lots of select fields.  Any ideas?

[atcodedog05 · Accepted solution]

Hi @chickenlicken 

You can find and replace to check contains like below

Hope this helps : )

[chickenlicken]

Just thinking a transpose tool might work better than the select and union.. but still doesn't feel quite optimal!

[Emil_Kos · Accepted solution]

Hi @chickenlicken,

I would suggest using find and replace tool:

With this configuration, it will match only words and not fields. If you would like to match the entire field you would need to click the entire field option:

[messi007 · Accepted solution]

@chickenlicken,

Find and replace 🙂 

Attached the workflow,

Regards

[chickenlicken]

Ahhhhhhh of course!! Thank you!

[atcodedog05]

Happy to help : ) @chickenlicken 

Cheers and have a nice day!