web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Specific value NOT in ...

Power Apps

Answered

Specific value NOT in multiple choice field

(0) Share

Report

Report

Posted on by armiv

27

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

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

QuentinDURIEZ 577 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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,

Join the conversation