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.
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!

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,485)