Removing blanks from suggested values

[JEast1993]

Hello! 

I am struggling to remove blanks from suggested values (see image of what appears in a form).

The suggested value formula is: SELECT(Components received[collection_cup_lot_number],true)

There are multiple components in the "Components received" table and each component has its own lot number column. This is so in the form above (for assembling an order) I can then select a lot number for each component in that order. 

Ideally in the example above I would only be able to see the collection_cup_lot_numbers and have blank buttons.

Thanks in advance

[AleksiAlkio]

Try with SELECT(Components received[collection_cup_lot_number],true) - LIST("")

[JEast1993]

Hi @AleksiAlkio thank you! I am afraid that didn't seem to change it. 

[JEast1993]

@AleksiAlkio - I found a work around using your "-List()" suggestion. 

I auto-filled the blanks with "N/A"

Then added -List("N/A") to my original formula.

Final formula: SELECT(Components received[collection_cup_lot_number],true) - LIST("N/A")

Final view: 

Thanks so much for the help! 

[MultiTech]

@AleksiAlkio For the past month or so, the `- LIST("")` thing hasn't been working.  Have you noticed this?

[JMPeterson]

Stumbling across this myself. @AleksiAlkio any insight?

[romulo_torres · Accepted solution]

How about:

SELECT(Components received[collection_cup_lot_number], [collection_cup_lot_number] <> "")

[JEast1993]

Thanks @romulo_torres this worked - and saved the work around I posted above. 

Final view: 

Do you know why I am getting the yellow '!'?