Filter Blank Lookup fields

(0) Share

Report

Posted on by ellbi

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

MichaelFP 1,892 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ellbi 8 on at

Like (0)

Report
Copy link

Link copied!

No, same result with a collection

Was this reply helpful? Yes No
ellbi 8 on at

Like (0)

Report
Copy link

Link copied!

I solved it by creating a view for the table which filters for the column "containing data".

Was this reply helpful? Yes No