Power Platform Community Forum Thread Details

Hi all,

I'm having trouble filtering a gallery with Dataverse data using a lookup column and thought someone here could help me (or at least tell my it is not working).

I have a Dataverse table with "Clients", with a lookup column called "Sales Manager". Sales Manager is optional, so some clients have no value, while others have a Lookup value from the "Employee" table. In my canvas app, I inserted a gallery displaying items from "Client" which I hope could be filtered by "Sales Manager" using a combo box with values from the "Employee" table.

I set the filter on my gallery as follows:

Filter(Client, 'Sales Manager'.'ID' = CB_SalesManager.Selected.'ID')

where CB_SalesManager is my combo box with values from the "Employee" table.

On selection of a value in the Combo box, the filter does nothing, even though if I insert labels pointing at the two values being compared, the values are displayed and match.

If I remove blanks in my formula the filter works:

Filter(Client, 
Not(IsBlank('Sales Manager')) 
&& 'Sales Manager'.ID = CB_SalesManager.Selected.'ID'
)

I seem to hit a delegation barrier with the 'IsBlank' function though, and not all values are returned, but whichever are returned are now correctly filtered.

Do you have any idea where the problem might be here and what could be a solution (if any)?

Thanks for your help!

Categories:

Building Power Apps