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
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 RegardsGunnar
Go to Solution.
Filter(choices([@'Datasource].ColumnName) ,Value <> "")
where datasource - your data source name
columnName - your lookup column name
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
View solution in original post
thank you for your help.
Your solution work and it is a nice and simply soltution.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.