Filtered Lookup Column - filtered value will not be saved.

[GunnarGillert]

Hi together,

I have a problem with filter lookup columns.
I have a list - List A - with text fields - some of them are empty/blank.

Now I will create an new item in list B - list B has a lookup column from list A.

PowerApps gave me 

choices([@'Datasource].ColumnName) 

here I found no workable code for filter values are not empty 
so I worked with distinct

Distinct(Filter('Listname,'.Column; !IsBlank(Column)); Column)

Now I see the correct filters values and I can selectes the values.

After saving the item - the value of the column is empty.

Any ideas?

Best Regards

Gunnar

[RezaDorrani · Accepted solution]

Hi @GunnarGillert 

Use

Filter(choices([@'Datasource].ColumnName) ,Value <> "")

where datasource - your data source name

columnName - your lookup column name

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[GunnarGillert]

Hi  RezaDorrani,

thank you for your help.

Your solution work and it is a nice and simply soltution.

Best regards

Gunnar