You’re offline. This is a read only version of the page.
84
I would like to bring up a list of only the members of staff who work in a certain department
For example a list of employees who work in the "Warehouse"
I have tried using
Filter(Staff.Name, "Warehouse" in Department)
but as the department is a choice field this will not work
Can someone please show me how this is done
@WarrenBelz THanks for the link, i was able to get it to work
The answer was:
Filter(Staff,Department = [@Department].Warehouse)
@Lynch66 ,
Then you are dealing with an Option Set - this document may be useful.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
@Lynch66 ,
What is your Data Source (I am assuming SharePoint here)
I have checked and it is a Single choice but for some reason I am not given the option of using Depatrment.Value, when i type Department. no options come up
Do you have any idea why this might be
@Lynch66 ,
If Department is a single Choice field in SharePoint, then Department.Value is the correct reference.
@WarrenBelz I am no longer using Staff.Name
Department is a single choice field
What i would like is to have a list of only Staff who work in the warehouse
When i type "Department."no options come up after typing the dot
@Lynch66 ,
The response from @FMontesRNX1 is correct for what you posted, but why are you using Staff.Name ? What is the list name and field name you are wanting and is Department single or multiple choice?
Did you tried this?
Share
Report
All responses (
Answers (
Filter(Staff, Department.Value = "Warehouse")
Use Properties Controls to show only names
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
