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 :
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 :
My Sharepoint list for the second dropdown :
My Sharepoint list or the third dropdown :
Solved! Go to Solution.
@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
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.
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
@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
@s44 ,
I can assure you it does - example from one of my lists below.
I think your issue is the identical list and field names.
User | Count |
---|---|
263 | |
110 | |
92 | |
55 | |
41 |