Working with a very large Sharepoint list

%3CLINGO-SUB%20id%3D%22lingo-sub-1192455%22%20slang%3D%22en-US%22%3EWorking%20with%20a%20very%20large%20Sharepoint%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1192455%22%20slang%3D%22en-US%22%3EHello%20I%20am%20new%20to%20Sharepoint%2C%20I%20am%20currently%20trying%20make%20a%20shatepoint%20list%20linked%20powerapps.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20a%20long%20list%20that%20was%20exported%20to%20Sharepoint%20via%20Excel%20table%2C%20there%20are%2030000%2B%20items%20in%20the%20list.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20list%20is%20going%20to%20act%20as%20a%20source%20for%20autocomplete%20(i.e.%20fill%20in%20an%20Item%20ID%2C%20and%20the%20rest%20of%20the%20info%20will%20be%20fetched%20from%20this%20list)%20and%20I%20think%20I%20need%20to%20Index%20and%20make%20the%20ID%20column%20unique%20to%20start%20with.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20problem%20is%20when%20I%20try%20to%20set%20ID%20column%20unique%2C%20i%20got%20error%20that%20the%20list%20exceed%205000%20view%20thersold%20but%20I%20cant%20trim%20the%20list%20down.%3CBR%20%2F%3E%3CBR%20%2F%3EWhats%20the%20best%20practice%20for%20working%20with%20such%20a%20large%20list%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1192455%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor
Hello I am new to Sharepoint, I am currently trying make a shatepoint list linked powerapps.

There is a long list that was exported to Sharepoint via Excel table, there are 30000+ items in the list.

The list is going to act as a source for autocomplete (i.e. fill in an Item ID, and the rest of the info will be fetched from this list) and I think I need to Index and make the ID column unique to start with.

The problem is when I try to set ID column unique, i got error that the list exceed 5000 view thersold but I cant trim the list down.

Whats the best practice for working with such a large list?
1 Reply
I am using Online Sharepoint