Filter a lookup by multiple values

  • 3 January 2017
  • 3 replies
  • 0 views

Badge +4

Hi, I'm trying to filter a lookup by multiple values (E.g. where the year column is 2016 or 2017) but nothing i can think of seems to work. I've tried putting 'fn-Or("2017","2016")' in the filter value box but it's not working. Filtering by a single value is fine but otherwise i can't build any kind of logic into it.

Thanks for any help.


3 replies

Userlevel 5
Badge +14

this functionality is unfortunately not available.

lookup is able to filter just by equality to a single value or other control content.

Badge +4

Thanks for the answer, perhaps you can help me with another list lookup filtering question.

I am able to set a list lookup A to be filtered by named control list lookup B, however if i try to set A to be filtered by a named control calculated value C where the formula is simply B, the filter doesn't work. Why is that and is there  a way to fix it?

Userlevel 5
Badge +14

I think I've already answered here  

Reply