Suggested Values Expression Help

[Tim1]

Hello, I’m having trouble getting an expression to work as desired.

I have an ENUM column that I need to see previous values as an option, with the ability to add new option.

This expression works for that in the suggested values:
SORT(UNIQUE(addresses[street]))

The problem is I’d like to use ISNOTBLANK to keep a blank entry from showing up in the suggested values. I have tried several ways to do that but non are work. Thanks in advance!

[1minManager]

SORT(UNIQUE(Select(addresses[street],ISNOTBLANK([Street]))))

but someone else may know a more elegant way to do it

Simon@1minManager.com

[Steve · Accepted solution]

Gives the same result using a quirk of list subtraction:

SORT(addresses[street] - LIST(""))

[Tim1]

I marked yours as the solution because oh how compact the expression is to accomplish the same result. Thank you!