Remove rows blank in combobox from field lookup

[cvazquc3]

Hello everyone

- I need remove rows blank of a combobox from a field lookup of my list in sharepoint

- I attached a image

thank you

[v-xida-msft · Accepted solution]

HI @cvazquc3 ,

Could you please share a bit more about the formula typed within the Items property of the Computers ComboBox?

Do you want to remove the blank rows from the available options within the Computers ComboBox?

Further, which column does your Computers ComboBox relates to? Is it the TypeEquipment column?

I assume that your Computers ComboBox connects to the TypeEquipment column in your SP list. Based on the needs that you mentioned, I think the Filter function could achieve your needs.

If the TypeEquipment column is a Choice type column in your SP list:

Set the Items property of the ComboBox to following:

Filter(
       Distinct('20190211_case5',TypeEquipment.Value), 
       Result <> Blank()
)

On your side, you should type:

Filter(
       Distinct(Products, TypeEquipment.Value), 
       Result <> Blank()
)

If the TypeEquipment column is a Single line text type column in your SP list:

Set the Items property of the ComboBox to following:

Filter(
       Distinct('20190211_case5', TypeEquipment), 
       Result <> Blank()
)

On your side, you should type:

Filter(
       Distinct(Products, TypeEquipment), 
       Result <> Blank()
)

More details about Filter function in PowerApps, please check the following article:

Filter function

Best regards,

[cvazquc3 · Accepted solution]

Hello

Thank you for your time

I solved formula in this option

Filter(Products.TypeEquipment, Not(IsBlank(TypeEquipment)))

Regards

[kmw1130]

I'm creating a collection of the values from my column in my sharepoint list, would I use the filter function on the dropdown or when I create my collection?