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?