Answered

How to add a blank option on dropdown cascade?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have some options on a DropDown object, and they take the options from an Excel sheet. I want to also give users a blank field option, in case that field is optional. But I don't want to add the blank line inside my Excel. Is there a way to add in a blank option in dropdown?

Here: Family dropdown should have a blank option

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
HI @Anonymous ,
Do a Collection then add the rest of the code. I assume you are using a Distinct() function here? If so,
ClearCollect(colFamily,{Result:""}); Collect(colFamily,Distinct(YourListName,Family).Result
Your Items of the drop-down are then colFamily

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.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to add a "Blank" option within your Dropdown boxes?

Based on the needs that you mentioned, I think the Concat function and Split function could achieve your needs without set up collections. I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the Dropdown control to following:

Sort( Split( Concat(Distinct(StudentInfo, 'Stu Name'), Result & ","), "," ), Result )

On your side, you may need to type the following formula within the Items property of the Family Dropdown box:

Sort( Split( Concat(Distinct('Your Excel Table', Family), Result & ","), "," ), Result )

Please take a try with above solution, hope it could solve your problem.

Best regards,

Was this reply helpful? Yes No