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

Show values on a drop down according to a filter

Hi there, 

 

I have a sharepoint list with my drop down (as Title) ,  i have a column called 'Valid' and if that is set to YES then it shows that column in my drop down, and if it is set to NO then it doesnt show. 

 

I am trying to come across the working formula for this : 

 

I use : 

 

Sort('List'.Title,Title)

- and this gives the drop down all Title columns within the list but i want it to filter if Valid is "YES" so i have done this : 

 

Sort('List'.Title,Filter('List', Valid = true))

 

This does not seem to work , any ideas?

 

 

 

 

1 REPLY 1
Anonymous
Not applicable

Re: Show values on a drop down according to a filter

Hi,

 

Your column Valid is a type boolean or a type text ? 

I ask you that because you say values are "YES" and "NO" but in your function you put "= true"

 

If it's not the problem, you should try with that conception :

Sort(Filter(List;Valid = true).Title;Title)

Or :

Sort(Filter(List;Valid = "YES").Title;Title)

Best regards 🙂

 

Louis

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 Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,562)