I have a Text element. How can I check if the Text value is in a field of a list of Things?
Thing 1’s fieldA – def
Thing 2’s fieldA – ghi
Thing 3’s fieldA – jkl
Thing 4’s fieldA - mno
Result here should be: “not in list”
But if Text value: “def” then result “exists in list”
This is for an element condition.
The only approach I can find that might work for this is using the Condition:
Do a Search Things’ fieldA first item contains Element’s value or Do a Search Things’ fieldA second item contains Text value or… etc etc.
But this would be very longwinded as I have a large number of Things to check. Is there a better way?