cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
LouisC
Level 8

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 Smiley Happy

 

Louis

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 40 members 4,976 guests
Please welcome our newest community members: