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.
Solved! Go to 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)
Hi @Martin_W ,
Can you share the current code you have for the Items property of dropdown2?
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)