Is it possible to filter multiple properties in an objectset

When passing an object set to filter list, I want to filter on multiple property. And these properties should be filtered on a text which will be entered in a text input, through which I get the text string which the user has entered.

Now the requirement is to check multiple properties if a match of this entered text exists. I tried different combinations of includes with (is, contains) and (All, Any). But nothing helps.

Currently I only get an output when I filter one property on the text entered.
Is it even possible to get the desired result or should I create a TS function and just call it?

I think you can do this directly using an Object Set variable. Create an objectSet that unions the object with a filter on each propertry one baed on the string param and then outputs all the matches.

For example, below we can output all matches where the id or new column is exactly equal to the string. You can also change it to match on each one that contains etc.

2 Likes

Thanks for the solution. I wanted to also know if this is computationally efficient as we are doing Union. Does this increase cost?