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?
Solved! Go to Solution.
Just thinking a transpose tool might work better than the select and union.. but still doesn't feel quite optimal!
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:
Ahhhhhhh of course!! Thank you!
Happy to help : ) @chickenlicken
Cheers and have a nice day!