cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tested1
Level: Powered On

Hiding one choice in a drop down column

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Hiding one choice in a drop down column

@tested1 

Might also try:

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

 

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

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Hiding one choice in a drop down column

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
Level: Powered On

Re: Hiding one choice in a drop down column

HI @timl 

 

Thank you for the reply, 

 

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

tested1
Level: Powered On

Re: Hiding one choice in a drop down column

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

Super User
Super User

Re: Hiding one choice in a drop down column

@tested1 

Might also try:

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

 

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

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Super User
Super User

Re: Hiding one choice in a drop down column

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?

 

 

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (4,448)