Filter Out Blanks using Choices

[caruso1058]

Hello, 

I have a Combo Box dropdown in a Form that populates my data from a SharePoint LookupColumn:
Choices([@'L11 - PFAM List Duplicate'].Building_x0020_Blocks)

However, the code above also returns a lot of blank values because there are a lot of blank values in the SP List.
I have attempted to use the Filter function to remove the Blank Vales but I can't seem to get this to work:
Filter(Choices([@'L11 - PFAM List Duplicate'].Building_x0020_Blocks), [@'L11 - PFAM List Duplicate'].Building_x0020_Blocks <> Blank()) 

Any help would be appreciated. 

[gabibalaban · Accepted solution]

Hi @caruso1058 ,

Can you try:

Filter(Choices([@'L11 - PFAM List Duplicate'].Building_x0020_Blocks),Len(Value)>0)  ?

[caruso1058]

That works great!!
Thank you for your help with this!