Hi,
is it really not possible to filter a lookup column to another table for empty items in Teams Dataverse?
For example, this returns a delegation warning:
Filter(Users; IsBlank(LookupField))
Other options like this also don't work:
Filter(Users; LookupField = Blank())
What is also strange is that when using the first example, I get a table containing the correct rows (when looking at the result inside the powerfx field) but when displaying them to a combobox or table control, all values are empty.
When i change the code to this, I get the data in the control, but only this one field. Why is that?
Filter(Users; IsBlank(LookupField)).Name
Thanks
I solved it by creating a view for the table which filters for the column "containing data".
No, same result with a collection
Try to create a collection to have the list of the data. I believe in that way you gonna have all fields.
If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as solution ✔️. This is help the community.