Forum Discussion

Fred Y's avatar
Fred Y
Iron Contributor
Sep 06, 2017

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

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 colum...
  • John Aage Andersen's avatar
    Sep 07, 2017

    Not a fix for the 5000 items issue, but an alternative to your current solution.

    Can I assume that Purchase Orders and Invoices are not being changed ever, when the Purchase Order has status Closed? (I assume that)!

    Move all Purchase Orders and Invoices into archive lists - Purchase Order Archive and Invoice Archive - thus keeping your active lists item count lower, hopefully below the limit.

    Kind regards

    John

Share