How to make ID searchable in large SP lists

Question

Hi,

I have a Sharepoint list with around 15000 items for a certain type of internal requests in my company. We use this list in a Powerapp and usually refer to these by ID, so sometimes I'll get asked to change some parameter on ID 12345.
Now here's the weird thing: If I search in the Powerapp for some older ID like 3245, it will show up. But I don't seem to have any way of searching for this directly in the sharepoint list. Entering the ID in the search bar will only work for the last 5000 items or so. I can't even filter for it because the filter only shows the last 5000 options.

What's going on here and how do I change this? I mean, ID is a standard column and definitely searchable. What do I have to do to make it REALLY searchable?

Answer 1

Hi @Toussaint, Alexander ,

From a SharePoint perspective, SharePoint lists have a limit of 5000 items that can be displayed in a view. This is why the user is unable to search for IDs beyond the last 5000 items. To make the ID column searchable for all items, the user can create a filtered view that has a column index. This can be done by creating a new view for the list or library or changing the existing view, and using indexed columns and filtering to keep the view size for the list to 5000 items or less. For more information about how to create a filtered view that has a column index, go to Manage large lists and libraries in SharePoint.

Regarding Power Apps, as Power Apps are currently not supported in the Q&A forum, you can post in the Power Apps community for discussion.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.