Forum Discussion
Solved
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
have you added an index to the Status column?
Hi, Dean.
I did add PO Number and Status as user-defined indices but unfortunately still resulted into the error. As a workaround, I temporarily increased the threshold limit until I implement the archiving functionality.
I did add PO Number and Status as user-defined indices but unfortunately still resulted into the error. As a workaround, I temporarily increased the threshold limit until I implement the archiving functionality.
- what version of sharepoint are you using?
- SP2013 Enterprise