web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : aGf/4opujAgGNv5zOs7Lys
Power Apps - Building Power Apps
Answered

Filter a Combobox by a choice

Like (0) ShareShare
ReportReport
Posted on 12 Apr 2022 15:58:39 by 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

  • Verified answer
    Lynch66 Profile Picture
    84 on 20 Apr 2022 at 11:32:26
    Re: Filter a Combobox by a choice

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

     

    The answer was:

     

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

  • Verified answer
    WarrenBelz Profile Picture
    148,894 Most Valuable Professional on 20 Apr 2022 at 10:33:53
    Re: Filter a Combobox by a choice

    @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 Profile Picture
    84 on 20 Apr 2022 at 08:36:55
    Re: Filter a Combobox by a choice

    @WarrenBelz I am using Dataverse tables

  • WarrenBelz Profile Picture
    148,894 Most Valuable Professional on 19 Apr 2022 at 20:00:41
    Re: Filter a Combobox by a choice

    @Lynch66 ,

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

  • Lynch66 Profile Picture
    84 on 19 Apr 2022 at 13:06:24
    Re: Filter a Combobox by a choice

    @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

  • WarrenBelz Profile Picture
    148,894 Most Valuable Professional on 19 Apr 2022 at 11:12:52
    Re: Filter a Combobox by a choice

    @Lynch66 ,

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

  • Lynch66 Profile Picture
    84 on 19 Apr 2022 at 09:59:55
    Re: Filter a Combobox by a choice

    @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

  • WarrenBelz Profile Picture
    148,894 Most Valuable Professional on 16 Apr 2022 at 05:30:43
    Re: Filter a Combobox by a choice

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

  • Lynch66 Profile Picture
    84 on 13 Apr 2022 at 10:29:40
    Re: Filter a Combobox by a choice

    Unfortunately this does not work

  • FMontesRNX1 Profile Picture
    147 on 12 Apr 2022 at 18:45:11
    Re: Filter a Combobox by a choice

    Did you tried this?

     

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


    Use Properties Controls to show only names

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2