Specific value NOT in multiple choice field

(0) Share

Report

Posted on by armiv

Hi ,

I want to filter a table based on values not selected from a multiple choice field.

So if the table has 10 rows where the field Number ranges from 1-10, if in the multipleChoice field the user has selected the numbers 3,4,5, the table should show all other rows but not the ones containing these numbers.

I know that to filter for specific values there is the logic: 'Number' in 'multipleChoice'.Value, but how do I filter for values who are not in the selection, is there any way?

Thank you in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

QuentinDURIEZ 547 Moderator on at

Like (0)

Report
Hi,

Maybe by using a negation with your logic :

Not('Number' in 'multipleChoice'.Value)

You will get the reverse result, so elements where Number is not in [3,4,5]

Regards,

Was this reply helpful? Yes No