Filter function isn't working in SharePoint lists

Question

We have multiple SharePoint lists, ranging from about 45 to 2,500 items that we access almost exclusively through Microsoft Teams. We filter these many times a day to locate the entry that we need. As of about a month ago this function stopped working in the desktop app, mobile view, web browser, and in actual SharePoint. When we click "Filter By" the filter panel comes up, but the drop-down that usually shows the matching items does nothing. I've attached an example below. You can clearly see that two of the entries begin with the last name "Abel", but when I type that, nothing comes up in the drop-down. Also, if I click on the checkbox next to that entry in the filter panel, it doesn't open. We have to sort the entire list A-Z, then scroll, wait to load, scroll, wait to load, etc. until we find the entry we need.

We also have separate, smaller lists (250 items) that are also having this issue.

This issue is happening on all of our computers. I've tried deleting and reinstalling Teams, deleting both the Teams and Chrome caches, adding indexes to the columns, and I've had our IT department look into it, to no avail.

What can we do to fix this, as it's impeding out ability to work?

Answer 1

Hi Kate Shalap：

Thanks for coming back.

For Microsoft 365 for business of enterprise, only administrative users can raise a service raise a service request in Microsoft 365 admin center, because some settings such as group policies require administrator rights to be implemented.

Therefore, please wait patiently and thank you for your understanding.

Tin

Answer 2

I tried to contact Support as you suggested and it just comes up with my own IT company's contact information. I have already tried to get support through them. How do I contact IT at Microsoft?

Thank you.

Answer 3

Hi Kate Shalap：

Sorry for the problem you encountered. I tested it with us and did not find the same problem.

When I use the filter function, enter keywords in the input box, and the matching options will pop up：

![](https://learn-attachment.microsoft.com/api/attachments/41fad124-3824-47cc-a1ff-3a5402f6ce50?platform=QnA"https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fadmin%2Fcontact-support-for-business-products%3Fview%3Do365-worldwide%26tabs%3Donline&data=04%7C01%7Cv-zhangjian%40microsoft.com%7C49bfdbb8f21e46d8dce108d8d729b9ba%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637495921617251923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=zT8MbPFzUKYcvFYLYSRkbPBWt8BQriWCztYKlhb7Lnk%3D&reserved=0" rel="ugc nofollow">raise a service request in Microsoft 365 admin center, which the support there has the related permission and resource to help you check from the backend and see whether can help you.

Please understand the inconvenience caused to you.

I wish you all the best.

Tin