question

MICHELRodric-9271 avatar image
0 Votes"
MICHELRodric-9271 asked MICHELRodric-9271 commented

Sharepoint List Multiple choice Column Filter AND

Hello all,

I have got multiple choice column with 9 Choices on a microsoft list : Choice1, Choice2, Choice3.

My problem concerns the filter fucntion : On multiple choice column, the filter is working on a 'OR' request.

For example : If I filter on Choice1, Choice2 the filter will return all itemes containing Choice1 or Choice2

I would like the filter work with and 'AND' request

For example : If I filter on Choice1,Choice2 the filter return only items that contains Choice1 and Choice2

Is there a solution to this problem please ?

I'm looking forward for your answers :)

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered MICHELRodric-9271 commented

@MICHELRodric-9271,

This is how modern filter pane works in SharePoint Online, currently there is no OOB way to meet your requirement.


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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MICHELRodric-9271,

Is there any progress on this issue?

Please feel free to reply.

0 Votes 0 ·

Hello @JulieWang-MSFT ,

Thank you for your answer,

The only solution I found is to create other 8 columns (for the nine choices) to filter on each column.

Have a good day :)

0 Votes 0 ·