Nuriel_SGE
Rookie

Choice / Lookup / MM - Filtering by multiple choice with AND logic - possible?

Hello,

 

I want to be able to filter a column with multiple selection (whether it is a choice, lookup or managed metadata based) by the otherwise common logic of AND operator.

 

Example: I have a column with choices A, B and C

 

When I filter by A and B in choice or managed metadata currently sharepoint would show me all items which contains either A or B.

 

I would like to only get items, which contain A and B.

 

Until now I have found no possibility to do that, either with OOB nor Nintex Forms I am using.

 

Is there any way to accomplish that?

 

P. S.: I am currently using Sharepoint 2016 and Nintex Forms. The p

Labels: (1)
0 Kudos
Reply
2 Replies
MillaZ
Community Manager
Community Manager

Re: Choice / Lookup / MM - Filtering by multiple choice with AND logic - possible?

@cecilia-penha Could you please assist here?

0 Kudos
Reply
Nuriel_SGE
Rookie

Re: Choice / Lookup / MM - Filtering by multiple choice with AND logic - possible?

No one has an idea for a solution here?

 

In the mean time I have at least found a very clumsy workaround. I create multiple copies of the column from where the data is being looked up and then use these multiple columns to filter by. This works as intended, thus with AND condition, however you need X columns to filter by X values simultaneously, so we typically use 2 or 3.

 

This is better than nothing, but of course far from a real solution.

 

Thus, it would be great, if someone could come up with a brilliant solution here.

 

Thanks!

0 Kudos
Reply