Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

default blank value for cascading dropdown with ascending sort

I have a canvas app that is pulling data from a sharepoint list.  I've got two cascading dropdowns which are pulling info from the same list.  Column1 is a numeric field and Column 2 is single line of text.   I've set the first entry in the list to a blank value, however, it's still not defaulting to the blank value.  I have to have Column 1 in 'ascending' order so the numbers are in order.  how can I set a blank default value for Column 1 [which filters Column 2 to blank as well] while still keeping Column 1 in ascending order?


Here is what I currently have on the Items properties.

Column 1:  Items Property:  Sort(Distinct('SPLIST', Column1), Result, Ascending)
Column 2: Items Property:  Sort(Distinct(Filter('SPLIST', Column1 = Column1.Selected.Result), Column1), Result&Blank())


default is set to no value on both fields.  I have searched extensively but can't seem to find a solution for my specific scenario.


Super User
Super User


Hmmm....I hate when things get stuck like that.  There are some "signs" that you start to learn over time of when to close and re-open, cut and paste, redo, etc.

The unfortunate part is that if you don't know them yet, you will spend tons of time trying to get something to work that should "just work"!


I am glad you got to the next level.

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.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

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

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,736)