Forum Discussion
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...
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
Is this SPO? If so, there is not much you can do here in the list to avoid the threshold limit...as an alternative you could try either to use search to create your view or some custom development
Thanks, Juan.
It would be nice to use a specific list view that will be used by a lookup column.
It would be nice to use a specific list view that will be used by a lookup column.
