List view lookupfiled filter is not working

Jerry Xu-MSFT 7,921 Reputation points
2020-10-27T07:29:03.797+00:00

Hi Team,

I have a list view and in that view i have a lookup column and when i am trying to filter items using out of box sharepoint feature in that column all items is working but the last one item filter is not working.Please help me.Thanks in advance.

Regards,

Praveen

Source link from TechNet

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,706 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,812 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Itch Sun-MSFT 2,556 Reputation points
    2020-10-28T03:05:14.763+00:00

    Hi

    Does the field connected to this look up column exceed List View Threshold 5000?

    If the field connected to the look up column exceeds 5000 items, the filter on the lookup column will fail and no value will be returned.

    If this fits your situation, I suggest that you modify the view of the field connected to the look up column to control it within 5000.

    If this does not suit your situation, please provide some screenshots and data samples.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.

    0 comments