I have two lists. First list contains a lookup to another list, which has over 5000 items. When i try to create item in the first list, i see following error
Remove the column? Seriously Microsoft? I understand i can edit views to filter out items so that i over come treshold limit problem, but what am i supposed to do with this since we are talking about OOTB sharepoint new form? My collegue suggest me that i remove the Lookup column and save the reference into text field, but i really hate this idea, what is SharePoint good for then.
Is there any ootb sharepoint way to solve this issue? i must also mention that i will need to be able to use QuickEdit in this list, as users want to update multiple items quickly. When using QuickEdit, this appears in the lookup column cell
We are talking about SharePoint Online