Unanswered

Drop Down in Power App have Blank Value or Row

(0) Share

Report

Posted on by fishtail

Hi All,I face an issues in my power app that there are some Blank Value or Blank Row in the drop down list of my Power App and the default choice that I set also not showing for some Item I selected. You all may refer in the below screenshot.

Default Choice - Laptop 1 - Showing but with Blank Value and Row

Default Choice - Monitor 1- Not Showing but with Blank Value and Row

Default Choice - Lenovo 65W Type C - Not Showing but with Blank Value and Row

Below are my code of Items in my DropDown

Ungroup(
Table(
{Dropdown2: If(varItem ="Laptop", Choices('LDM Item Selection'.LaptopSelection))},
{Dropdown2: If(varItem ="Monitor", Choices('LDM Item Selection'.MonitorSelection))},
{Dropdown2: If(varItem ="Power Adapter", Choices('LDM Item Selection'.PowerSelection))},
{Dropdown2: ["Others"]}
),
"Dropdown2"
)

Kindly advise.

Best Regards

Newbie of Power App

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Geeks_D 1,169 on at

Like (0)

Report

Hi
Can you check if the collection the dropdown is picking from is not having any empty rows?
If they have you can remove it with the RemoveIf

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @fishtail , To remove the blank choices from dropdown, you can try this code:
Ungroup( Table( {Dropdown2: If(varItem ="Laptop", Filter(Choices('LDM Item Selection'.LaptopSelection),!IsBlank(Value)))}, {Dropdown2: If(varItem ="Monitor", Filter(Choices('LDM Item Selection'.MonitorSelection),!IsBlank(Value)))}, {Dropdown2: If(varItem ="Power Adapter", Filter(Choices('LDM Item Selection'.PowerSelection),!IsBlank(Value)))}, {Dropdown2: ["Others"]} ), "Dropdown2" )

This will remove the blanks from the dropdown if there are any.

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.

Thanks,
ANB

Was this reply helpful? Yes No
Abelokobylka 25 on at

Like (0)

Report

Can we have a screenshot of 'LDM Item Selection' list? And the options for those columns?

Was this reply helpful? Yes No
fishtail 38 on at

Like (0)

Report

Hi Geeks,
I am using a SharePoint list to link my DropDown Value and the column I am using is Choices.

Was this reply helpful? Yes No
fishtail 38 on at

Like (0)

Report

Hi Abelokobylka,
Kindly find the screenshot below:
Thanks

Was this reply helpful? Yes No
fishtail 38 on at

Like (0)

Report

Hi ANB,
The code you provided is not worked and the blank value and row is still there.
I might think that my issues might due to the DropDown value is get from a column in my SharePoint List.
The concept of my app are as below:
1. I have a slection screen for user to choose which Item to borrow.

2. After user selected one of the Item, the drop down value will appear the choice value based on the item user selected. I had set my choice value at the column of the SharePoint list.
3. Below is the column value I set in my SharePoint List, the Item Selection and Dropdown Value Co;umn are in the same Share Point lIst.

Hope this information may help you all have more idea to help resolve my issues.

Best Regards,
WHK

Was this reply helpful? Yes No