Is it possible to filter a lookup column using a specific criteria?

Iron Contributor

I have the following lists with a lookup column that has more than 5,000 items: 


  • Purchase Orders list 
    • PO Number - text
    • Status - Active or Closed

  • Invoices list
    • PO Number - lookup column from Purchase Order


Is it be possible to filter out items displayed in the lookup column based on (Status = Active) so that the app doesn't need to have too many items in the dropdown list and avoid the following error?


"This is a lookup column that displays data from another list that currently exceeds the List View Threshold defined by the administrator (5000)."


Note, I've tried to use a calculated column (IF(Status=Active,"PO Number","")) but this doesn't work. I saw a demo of custom InfoPath form with data filter but would like to investigate if there are other options first. 




20 Replies
this is genius thank you!