Filtering blank values from a dropdown

[Martin_W]

Hello again.

Is there an easy way of filtering blank value from a dropdown box items list?

Suppose I have a table or collection (Fruit) that looks like this;

Apple, Granny Smith, Green

Apple, Pink Lady, Red

Apple, , Pink

Plum, Victoria, Green

Plum, Cherry, Purple

Plum, , Black

The idea is that dropdown1 would select Apple or Plum.

Dropdown 2 items is filled with Column2 where Column1='Apple'. and dropdown3 is filled with column3 where Column1 = 'Apple'

I have got the dependencies working ok, so that dropdowns 2 and 3 only display what's appropriate for the selected fruit.

The problem is that where the options in columns 2 and 3 are not the same number of rows, the blanks appear in the dropdown. So, for example, there are only two options for the type of apple, (Granny Smith and Pink Lady) but three colours. This means that there will be a blank in dropdown2 after Pink Lady.

I have tried the Filter command with !IsBlank but to no avail.

[BCBuizer]

Hi @Martin_W ,

Can you share the current code you have for the Items property of dropdown2? 

[Martin_W · Accepted solution]

I finally got this working!

So this is now the code that's in the second dropdown (remember it's dependent upon the value in the first)

Filter(Collection2, !IsBlank(RecordValue ), iParentId = ddDropdown1.Selected.ParentId)