Skip to main content
Nintex Community Menu Bar
Solved

List lookup filter based on specific value

  • August 11, 2020
  • 2 replies
  • 119 views

Forum|alt.badge.img+4

I have a list containing 'Name', 'ID' and 'Status' columns. In 'Status' column, I have three values "Pass","Fail","NA".

Now my requirement is, I want the 'Name' of students in a drop-down whose 'ID' lies between 15 to 20 and 'Status' is not "NA".

 

Any help will be much appreciated. 

Best answer by kunalpatel

@AmanG ...Try to create a view in your list using your filter parameters (unless your filter parameters are not dynamic) and use that view in list lookup control on your form.

2 replies

Forum|alt.badge.img+12
  • Rookie
  • Answer
  • August 11, 2020

@AmanG ...Try to create a view in your list using your filter parameters (unless your filter parameters are not dynamic) and use that view in list lookup control on your form.


Forum|alt.badge.img+4
  • Author
  • Rookie
  • July 14, 2021
Thanks @kunalpatel , filters are actually dynamic.