cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PJBruen
Resolver I
Resolver I

Display a dropdown list excluding certain values

Hi, 

 

I have a button that I want to use to create a collection that a dropdown box will be populated from (unless there's a way to do this in the dropdown itself),

 

The data for the dropdown is in a Sharepoint list and I want the dropdown to display the list, excluding certain items though.

 

For example: The Sharepoint list has:

ID    TITLE

1      -

2      ABC

3      DEF

4      HIJ

 

So, in the dropdown, I would like to not display ID=1.

 

So far I have this, but it's failing. Can anyone advise where I'm going wrong?

 

ClearCollect(colDropdown, Filter(Choices(SPList.Title), Not(Value(="-")));

 

Many thanks

Paul.

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@PJBruen 

You can do all of this in the Items property of the DropDown list.

Please consider the following Formula in the Items property:

Filter(
   SPList,
   !(Title = "-")
).Title

 

I hope this is helpful for you. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

2 REPLIES 2
RandyHayes
Super User
Super User

@PJBruen 

You can do all of this in the Items property of the DropDown list.

Please consider the following Formula in the Items property:

Filter(
   SPList,
   !(Title = "-")
).Title

 

I hope this is helpful for you. 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Many thanks @RandyHayes 

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,260)