cancel
Showing results for 
Search instead for 
Did you mean: 

Filter Collection question

JohnPerry
Level 3
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
2 REPLIES 2

PvD_SE
Level 12
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
Happy coding!
Paul, Sweden
(By all means, do not mark this as the best answer!)

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
KirtiMaan Talwar
IA Consultant
Deloitte USI