Is sharepoint index needed for Filter or just for sort

(0) Share

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

I have a sharepoint test list named Test, and it contain 10,000 items and i did not add any index to the sharepoint list. now when i write this formula, i were able to filter:-

Filter(Test,Num=Value(TextInput1.Text))

but when i wrote this formula to filter and sort, i did not get any item:-

Sort(Filter(Test,Num=Value(TextInput1.Text)),names)

so can i conclude that creating a SharePoint index is only needed for sorting and not for filtering? as seems the filter is working without having any index..

any advice?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 153,049 Most Valuable Professional on at

Like (1)

Report

@johnjohnPter ,

You should index any column in SharePoint that is used in any query (Filter/LookUp/Sort by) as good practice, however once you reach 5,000 items it is basically essential.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No