Microsoft List Formatting choice field with multiple selections

Hatrak, Jessica 0 Reputation points
2024-07-09T16:42:43.4333333+00:00

I have created a list with a choice field that allows multiple selections (Image 1). when I go to filter directly on the column it looks fine (Image 2), however when I go to the sheet filter, every choice combination selected is available in the filter (Image 3). How do I adjust that column so that all filters display the original 3 choices and not unique values for every selection combination?

CHOICE FIELD (Image 1)

User's image

COLUMN FILTER (Image 2)

User's image

SHEET FILTER (Image 3)

User's image

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,181 questions
{count} votes

1 answer

Sort by: Most helpful
  1. RaytheonXie_MSFT 33,401 Reputation points Microsoft Vendor
    2024-07-10T06:10:19.2566667+00:00

    Hi @Hatrak, Jessica,

    Per my test, I am unable to reproduce your issue. In my sharepoint, I get the same result in sheet filter.

    User's image

    User's image

    You could try to clear your browser cache or change the browser to operate. You could refer to the following issue similar with yourshttps://answers.microsoft.com/en-us/msoffice/forum/all/filtering-a-choice-column-that-allows-for-multiple/412c6367-dd84-4f1a-b7b1-61194584fb0d


    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.

    0 comments No comments