Filter Collection question

[JohnPerry]

Im trying to create a filter for a collection but using multiple criteria. For example, I'm trying to get it to find data from Field 1 that has either Criteria 1 or Criteria 2. I can get it to work with just 1 criteria and if I do it with another Filter collection item it doesnt work. I'm not that good with SQL language myself so any help would be great.

Forgot to mention i'm filtering an existing collection by the Filter action

[PvD_SE]

Hi JP,

What kind of filtering are you using:

• Filter data from an XL into a collection
• Filter an existing collection by the Filter action
• Filter an existing collection by using a Loop action

Happy coding!
---------------
Paul
Sweden

[kirtimaantalwar]

Hi John,

You can try "OR" operator in your Filter Collection expression. Please find below sample expression for your reference - 

"[Field1] like 'Criteria 1' or [Field1] like 'Criteria 2' "

Many Thanks!!
KirtiMaan Talwar