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.
Solved! Go to 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.
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.
User | Count |
---|---|
252 | |
104 | |
94 | |
50 | |
39 |