cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
s44
Super User
Super User

cascading dropdown set default value blank

Hello,
I am creating a Power Apps application with cascading dropdown menus. I'd like these cascading dropdown menus to default to an blank value, but I can't seem to do that.
Could you help me please ? 😞 Thanks in advance !

 

My app is like this :

s44_0-1654692940485.png

 

For the first dropdown, I have this code : Items =  Sort(Distinct(Categorie;Categorie);Result)

For the second dropdown, I have this code : Items = Distinct(Filter(Filiere;Categorie.Value=Dropdown2.Selected.Result);Title)

For the third dropdown, I have this code : Items = Distinct(Filter('Sous-Filiere';Filiere.Value=Dropdown5.Selected.Result);'Sous-Filiere')

 

 

My Sharepoint list for the first dropdown :

s44_0-1654693852353.png

My Sharepoint list for the second dropdown :

s44_1-1654693904278.png

 

 

My Sharepoint list or the third dropdown :

s44_2-1654693938273.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@s44 ,

Two things - that actually should work (I use it regularly) and secondly, you have the field and list name the same (not a good idea), however another approach is to make a collection

ClearCollect(
   colCategorie;
   {Result: ""};
   Sort(
      Distinct(
         Categorie;
         Categorie
      );
   Result
)

then the Items of your drop-down would be colCategorie

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

View solution in original post

7 REPLIES 7
Adrian_Celis
Super User
Super User

Hi @s44 

Did you already try to make the Default property of all dropdowns blank? This will make the default value of your dropdowns blank.

WarrenBelz
Super User
Super User

Hi @s44 ,

Set AllowEmptySelection to true

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

I just tried but it doesn't change anything :c @WarrenBelz 

@s44 ,

Two things - that actually should work (I use it regularly) and secondly, you have the field and list name the same (not a good idea), however another approach is to make a collection

ClearCollect(
   colCategorie;
   {Result: ""};
   Sort(
      Distinct(
         Categorie;
         Categorie
      );
   Result
)

then the Items of your drop-down would be colCategorie

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Your formula don't work 😕  @WarrenBelz 

s44_0-1655117011677.png

 

@s44 ,

I can assure you it does - example from one of my lists below.

WarrenBelz_0-1655121368717.png

I think your issue is the identical list and field names.

Finally it's work !Thanks !! @WarrenBelz 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,879)