Filter gallery based on lookup field

[sdedic]

Hi,

I want to filter the gallery to show only those employees that are not billable. I have two dataverse tables that are related: Employee and Resource, where Resource table is looking at the Employee table with the 'Employee' lookup field.

Inside Employee table there is a choice column 'Non-billable' with two choices: billable and non-billable.

Datasource of the gallery has to be Resource table.

This is what I have tried so far, but getting no results:

Filter(Resources, Employee.Name = 'Non-billable Choices'.'Non-billable')

'Name' in 'Employee.Name' is the primary name column inside Employee table.

Any advice would be appreciated.

Ty.

[MM_Factor · Accepted solution]

If there is a Dataverse table the easiest idea is to use views on Dataverse table - and filter this non billable employees.

Then in PowerApps you choose only this view in gallery and that's all.

[sdedic]

Thank you @MM_Factor !

Great idea. Working like a charm!