Answered

Filtering Out Select Options in a Choice Column for a Dropdown Menu

(0) Share

Report

Posted on by cmanning

228

I have a canvas app with a form and I have a dropdown that currently lists all items from the DV choice column (not a lookup column).

// Dropdown menu Items Propery (Current code - No Filtering)
Choices(Offerings)

I need to add a filter to Choices(Offerings) to exclude a list of select choices (e.g., Not In - list of choices to exclude "Choice 3", "Choice 5", etc.). How would I add a filter to Choices(Offerings)?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

AhmedSalih

6,680 Moderator on at

Like (2)

Report

Copy link

Link copied!

Hello, @cmanning, use this formula accordingly:

Filter(Choices(Offerings), Value <> "Choice 3",Value <> "Choice 5")

Note: Choices should be the ChoiceName.Choice3, etc..

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

cmanning 228 on at

Like (0)

Report
Copy link

Link copied!
@AhmedSalih - Thank you for providing a great answer! I am marking it as the solution. Thanks!

// My code per AhmedSalih Solution Filter(Choices(Offerings), Value <> Offerings.Analytics)

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (1)

Report
Copy link

Link copied!

@cmanning, Happy to help 🙂

Was this reply helpful? Yes No