I’m trying to configure this Filter node to keep only contacts whose Department contains ANY of the keywords I’ve listed in the condition value (in other words, it should be OR logic). However, I keep getting the error “Filter Failed! No value output for ‘output1’ as input ‘input1’ was filtered out."
I’ve checked to make sure that there are inputs into the Filter node that should make it through the filter (see screenshot below), but my run still fails every time with the same error. I’ve tried separating my keywords in the condition value with new rows, commas, “OR”, but none of them work.
Hi! This behavior is expected with the Filter node.
The main issue is that the “Contains” condition treats the entire condition value as one single string, not as multiple keywords combined with OR logic. When you enter several values on new lines (for example: Public Works, Streets, Stormwater), the Filter node checks whether the Department field contains that entire block of text at once, which will never match. As a result, every input gets filtered out and the run fails with the “Filter Failed” error.
At the moment, the Filter node does not support a native “contains any of” (OR) condition within a single field. Separating values with new lines, commas, or the word “OR” will not change this behavior.
The recommended workaround is to use a Router node instead. The Router allows you to define multiple conditions joined by OR logic (for example: Department contains “Public Works” OR “Streets” OR “Stormwater”). Any record that matches at least one of those conditions will be routed correctly, and you can add a second route to handle non-matching records if needed.
Using a Router for this scenario is more flexible and avoids the “no output” failure you’re seeing with the Filter node.