web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Hiding one choice in a...
Power Apps
Answered

Hiding one choice in a drop down column

(1) ShareShare
ReportReport
Posted on by tested1 265

Hello

 

I have a column called test with a drop down list. I have a sharepoint list for users to fill in to request something.

 

I want to manually put in older requests so one option in column 'test' drop down is 'Legacy'. This is used for all old requests.

 

I want to hide this 'Legacy' choice in the drop down. So: from choice 1, choice 2, legacy it should only show choice 1 and choice 2. Legacy will be hidden

 

Before:             After

Choice 1          Choice 1

Choice 2          Choice 2

Legacy             Blank - Legacy option will be hidden from user)

 

 

Is there any way to hide this one single choice in a drop down column? The items are choices in the powerapps field. so Choices.Listname.Column name

 

Thank you 

Categories:
Building Power Apps
I have the same question (0)
  • timl Profile Picture
    timl 37,269 Super User 2026 Season 1 on at

    Hi @tested1 

    You should be able to filter out your Legacy choice by calling the Filter function. The Items property of your drop down control would look like this:

     

    Filter(Choices(Listname.Fieldname), Value <> "Legacy")

    With SharePoint, the Choices function returns a table with 2 fields - Id and Value. That's the reason why we filter on Value.

     

  • tested1 Profile Picture
    tested1 265 on at

    HI @timl 

     

    Thank you for the reply, 

     

    Brilliant! I believe it works. Just testing it out now

  • tested1 Profile Picture
    tested1 265 on at

    Hi @timl 

     

    For some reason my form is being weird and it has stopped working. I am using look up columns. 

     

    So I added the choice 'Legacy (LEG)' to my look up master list, and then refreshed the data source.

     

    The legacy (LEG) choice shows when I click new item and select the drop down.

     

    I added the formula you said in the Items box on the choices data card. It all accepts but for somereason it does not filter and Legacy (LEG) still shows. Any ideas :)? I put a pic below of what I have. I think the data sources /choices is messing up . very strange.

     

     

    image.png

  • Verified answer
    RandyHayes Profile Picture
    RandyHayes 76,299 Super User 2024 Season 1 on at

    @tested1 

    Might also try:

       Filter(Choices(yourDataSource.Brand, !StartsWIth("Legacy"))

     

    Just in case there are some "non-space" characters in that space.

     

  • timl Profile Picture
    timl 37,269 Super User 2026 Season 1 on at

    Hi @tested1 

    This is strange.  In addition to @RandyHayes's suggestion......

     Filter(Choices(yourDataSource.Brand, !StartsWIth("Legacy"))

    I would also try to diagnose this by adding a temporary data table onto your screen. If you set the Items property of this to .....

    Filter(Choices(Listname.Fieldname), Value <> "Legacy (LEG)")

    Does it filter out the "Legacy (LEG)" choice in the data table?

     

     

  • Karl G. Schneider Profile Picture
    Karl G. Schneider 54 on at

    This is working for one Choice value, but i have to conditionally hide some value from the choice.

    The Status-Value "Closed" in my Status-Column "bimStatus" (SharePoint Choice) should only be available when the actual status of the Item is "Solved"

     

    bimStatus.Items:

     

    If(bimStatus.Value<>"Solved",Filter(Choices([@Incidents].bimStatus),Value<>"Closed"))

     

     

    This does not work in Preview and FormMode

     

  • liniv Profile Picture
    liniv 27 on at

    Hello!

    I am trying to implement the solution here in my customized form for Sharepoint. It doesn't work, I need some help.

     

    I have 2 Choice columns and I want to to the following:

    If a value different than "other" is selected in column 1, hide value "Done" from the choices in column to, so it can't be selected.

     

    In Items in Column 2 I entered:

    If(DataCardValue21.Selected.Value<>"other",Filter(Choices([@DTPs].Workingstatus),Value<>"Done"),Choices([@DTPs].Workingstatus)

     

    It looks OK to me, but when I test it, the drop down for column 2 stops working at all. Can someone advise me? Thanks very much in advance

     

    KR

     

     

     

  • Karl G. Schneider Profile Picture
    Karl G. Schneider 54 on at

    Try to use the Columns.Value instead of DatacardValueXX.Selected.Value

    If(bimStatus.Value<>"Solved",Filter(Choices([@Incidents].bimStatus),Value<>"Closed"))

     

    If(Workingstatus.Value<>"other",Filter(Choices([@DTPs].Workingstatus),Value<>"Done"))

  • Karl G. Schneider Profile Picture
    Karl G. Schneider 54 on at

    Try to use the Columns.Value instead of DatacardValueXX.Selected.Value

    If(Workingstatus.Value<>"other",Filter(Choices([@DTPs].Workingstatus),Value<>"Done"))

    This also could be done in an conditional Matrix Order to Show/hide some Status in Conditional Order.

    But then you could no use the  <> / Not() Condition. Instead you have to use a If()-Matrix with inclusion of all relevant Status-Values like this example
    bimStatus.Items: 
    If(
    bimStatus.Value = "Neu",
    Filter(
    Choices([@Incidents].bimStatus),
    Value = "In Bearbeitung" || Value = "Information angefordert" || Value = "Information geliefert" || Value = "Gelöst"
    ),
    bimStatus.Value = "In Bearbeitung",
    Filter(
    Choices([@Incidents].bimStatus),
    Value = "In Bearbeitung" || Value = "Information angefordert" || Value = "Information geliefert" || Value = "Gelöst"
    ),
    bimStatus.Value = "Information geliefert",
    Filter(
    Choices([@Incidents].bimStatus),
    Value = "In Bearbeitung" || Value = "Information angefordert" || Value = "Information geliefert" || Value = "Gelöst"
    ),
    bimStatus.Value = "Information angefordert",
    Filter(
    Choices([@Incidents].bimStatus),
    Value = "In Bearbeitung" || Value = "Information angefordert" || Value = "Information geliefert" || Value = "Gelöst"
    ),
    bimStatus.Value = "Gelöst",
    Filter(
    Choices([@Incidents].bimStatus),
    Value = "Information angefordert" || Value = "Geschlossen"
    ),
    bimStatus.Value = "Geschlossen",
    Filter(
    Choices([@Incidents].bimStatus),
    Value = "In Bearbeitung" || Value = "Information angefordert"
    ),
    Choices([@Incidents].bimStatus)
    )
     
  • powereduser0620 Profile Picture
    powereduser0620 6 on at

    Legend, thank you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans