Solved

List lookup filter based on specific value

  • 11 August 2020
  • 2 replies
  • 82 views

Badge +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. 

icon

Best answer by kunalpatel 11 August 2020, 17:29

View original

2 replies

Badge +12

@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.

Badge +4
Thanks @kunalpatel , filters are actually dynamic.

Reply