Filter a Combobox by a choice

(0) Share

Report

Posted on by Lynch66

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

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (2)

Sort by

FMontesRNX1 147 on at

Like
a
(0)

Report
Copy link

Link copied!
Did you tried this?

Filter(Staff, Department.Value = "Warehouse")

Use Properties Controls to show only names

Was this reply helpful? Yes No
Lynch66 84 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately this does not work

Was this reply helpful? Yes No
WarrenBelz 156,127 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Lynch66 84 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
WarrenBelz 156,127 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Lynch66 ,

If Department is a single Choice field in SharePoint, then Department.Value is the correct reference.

Was this reply helpful? Yes No
Lynch66 84 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

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

Was this reply helpful? Yes No
WarrenBelz 156,127 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Lynch66 ,

What is your Data Source (I am assuming SharePoint here)

Was this reply helpful? Yes No
Lynch66 84 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz I am using Dataverse tables

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,127 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Verified answer

Lynch66 84 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz THanks for the link, i was able to get it to work

The answer was:

Filter(Staff,Department = [@Department].Warehouse)

Was this reply helpful? Yes No