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)?
@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)
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
|
mmbr1606
22
Super User 2025 Season 1
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1