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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Using a Gallery as a f...
Power Apps
Answered

Using a Gallery as a filter for Switch & Choice Fields

(0) ShareShare
ReportReport
Posted on by AdamH 580

Hi All, 

I have a gallery that I am using as a 'Filter Buttons' for my main gallery which was setup to filter records depending if a switch was on or off within a persons record.

 

I need to change this to incorporate some choice fields that are within the records. As an example:

Choice Fields from a dropdown field:

- Group1

- Group2

- Group3

Code I was using for far is:

With(
 {WMST: 'NC MST Tracker'}, Sort(
 Filter(
 WMST,
 Or(IsBlank(TextInput1.Text),
 TextInput1.Text in 'Employee Name',
 StartsWith(
 'Employee Name',
 TextInput1.Text
 )) && Switch(
 Gallery1_1.Selected.Value,
 "Mentor",
 Mentor,
 "AET",
 'AET Instructor',
 "MST",
 'MST Assessor',
 true
 )
 ),'Employee Name',If(Sort, Descending,Ascending))
)

Anyone able to advise me with this?

 

Thanks

 

Categories:
Building Power Apps
  • WarrenBelz Profile Picture
    WarrenBelz 156,714 Most Valuable Professional on at

    Hi @AdamH ,

    A couple of things - what are you trying to do with the Switch statement

    Switch(
 Gallery1_1.Selected.Value,
 "Mentor",
 Mentor,
 "AET",
 'AET Instructor',
 "MST",
 'MST Assessor',
 true
)

    You have not specified which field you are filtering, so that bit does nothing presently.

    This part

    Or(
 IsBlank(TextInput1.Text),
 TextInput1.Text in 'Employee Name',
 StartsWith(
 'Employee Name',
 TextInput1.Text
 )
)

    if you use the second one, you do not need the third, however if you are happy with StartsWith() and not in, the filter becomes Delegable and you do not need the With() statement (which only takes away the warning - it still only works on the first 2,000 items)

    Can you please explain a bit more what you are doing with the Choice fields

     

  • AdamH Profile Picture
    AdamH 580 on at

    @WarrenBelz 

    Regarding the switch statement: 

    With(
 {WMST: 'NC MST Tracker'}, Sort(
 Filter(
 WMST,
 Or(IsBlank(TextInput1.Text), // SEARCH BAR
 TextInput1.Text in 'Employee Name',
 StartsWith(
 'Employee Name',
 TextInput1.Text
 )) && Switch(
 Gallery1.Selected.Value,
 "Mentor",
 Mentor,
 "AET",
 'AET Instructor',
 "MST",
 'MST Assessor',
 true
 )
 ),'Employee Name',If(Sort, Descending,Ascending))
)

    This is the [items] property of my main gallery [browsegallery1] on my [BrowseScreen1] that shows all the staff records. At the top of the screen, there is another gallery [Gallery1] which I've formatted to look like and act as buttons. 

    2021-11-13 14_54_45-Window.png

    (i think you helped me with this before...)

    Within each staff record, I have toggle true/false switches - Example, My record will have MST switched to true, therefor on [BrowseScreen1] which is my main screen, if press 'MST' it will filter all the records with 'MST' toggle switch set to true. So the [Items] property of [Gallery1] is: ["All","Mentor","AET","MST"]

     

    What I want to do is expand [Gallery1] and have this filter a LIST field and Combobox on my app as well as the existing toggle fields. 

    2021-11-13 16_14_32-Window.png

    2021-11-13 16_15_16-Window.png

  • WarrenBelz Profile Picture
    WarrenBelz 156,714 Most Valuable Professional on at

    Thanks @AdamH ,

    I remember the code now, but you had it in amongst the filter rather than the sort (which you had further down). Please look at the below for suggested structure

    With(
 {WMST: 'NC MST Tracker'}, 
 Sort(
 Filter(
 WMST,
 (
 Len(TextInput1.Text) = 0 || 
 TextInput1.Text in 'Employee Name'
 ) && 
 StartsWith(
 'Employee Name',
 TextInput1.Text
 ) &&
 (
 Len(YourGradeDD.Selected.Value) = 0 ||
 Grade = YourGradeDD.Selected.Value
 )
 ),
 Switch(
 Gallery1.Selected.Value,
 "Mentor",
 Mentor,
 "AET",
 'AET Instructor',
 "MST",
 'MST Assessor',
 'Employee Name'
 ),
 If(
 Sort, 
 Descending,
 Ascending
 )
 ) 
)

     

    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

     

  • AdamH Profile Picture
    AdamH 580 on at

    Hi @WarrenBelz 

     

    Yes I thought it was yourself that may have helped with this previously. 

     

    Looking at your code, so if I wanted apply those principles in my [Gallery1], where would I insert the additional items? Basically, I make new buttons on my [Gallery1] which filter the grade

    Example...

    2021-11-13 14_54_45-Window.png

     

    Would it be something like?

    Len(YourGradeDD.Selected.Value) = 0 ||
 Grade = Grade1.Selected.Value ||
 Grade = Grade2.Selected.Value ||
 Grade = Grade3.Selected.Value ||

     

  • WarrenBelz Profile Picture
    WarrenBelz 156,714 Most Valuable Professional on at

    @AdamH ,

    Is this a new gallery ? Gallery 1 is sorting, not filtering.

    If you have a new gallery (Gallery2) for those controls with the Items

    [
 "Grade 1",
 "Grade 2",
 "Grade 3",
 "Grade 4"
]

    it would be something like this

    With(
 {WMST: 'NC MST Tracker'}, 
 Sort(
 Filter(
 WMST,
 (
 Len(TextInput1.Text) = 0 || 
 TextInput1.Text in 'Employee Name'
 ) && 
 StartsWith(
 'Employee Name',
 TextInput1.Text
 ) &&
 Grade = Gallery2.Selected.Value
 ),
 Switch(
 Gallery1.Selected.Value,
 "Mentor",
 Mentor,
 "AET",
 'AET Instructor',
 "MST",
 'MST Assessor',
 'Employee Name'
 ),
 If(
 Sort, 
 Descending,
 Ascending
 )
 ) 
)

     

    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

     

  • AdamH Profile Picture
    AdamH 580 on at

    @WarrenBelz 

    Sorry for the late reply on this, I was unwell with a chest infection and have only come back to the world of the living.

     

    This is not with a new gallery, I have just added to the [ITEMS] of the existing Gallery1 - sorry for the confusion between sorting and filtering which has made you think I've added a new gallery - I'll be careful with my choice of words next time.

     

    Gallery1 is sorting and I wanted to add the ability to sort with the switch statement (toggle switches for Mentor, AET & MST

     

    and

     

    also the grade field (LIST) Grade 1, Grade 2 and Grade 3. 

     

     

  • AdamH Profile Picture
    AdamH 580 on at

    Hi @WarrenBelz 

    I've had some time to review your code and I do manage to get the grade [LIST] sort to work, but the switch sort has stopped working. I noticed that the true is missing from the end of the switch section:

     'MST Assessor',
 true
 )
 ),'Employee Name',If(Sort, Descending,Ascending))

    I tried to re-insert the 'Employee Name' true), with your version and I cannot get it to work. 

    app buttons.pngapp buttons1.png

  • WarrenBelz Profile Picture
    WarrenBelz 156,714 Most Valuable Professional on at

    @AdamH ,

    How are you determining the Grade sort and how does that mix with the gallery determined sort at the bottom?

  • WarrenBelz Profile Picture
    WarrenBelz 156,714 Most Valuable Professional on at

    Hi @AdamH ,

    I cannot test it presently, but the Switch code should work on the basis that 'Employee Name' should apply if none of the others are chosen. You could go back to

    If(
 Gallery1.Selected.Value = "Mentor",
 Mentor,
 Gallery1.Selected.Value = "AET",
 'AET Instructor',
 Gallery1.Selected.Value = "MST",
 'MST Assessor',
 'Employee Name'
)

    but it is the same thing

  • AdamH Profile Picture
    AdamH 580 on at

    Hi @WarrenBelz 

     

    Spent a good couple of hours on this and have managed to get 98% working

    With(
 {WMST: 'NC MST Tracker'}, Sort(
 Filter(
 WMST,
 Or(IsBlank(TextInput1.Text),
 TextInput1.Text in 'Employee Name',
 StartsWith(
 'Employee Name',
 TextInput1.Text
 )) && Switch(
 Gallery1_1.Selected.Value,
 "Mentor",
 Mentor,
 "AET",
 'AET Instructor',
 "MST",
 'MST Assessor',
 true
 && Grade.Value = Gallery1_1.Selected.Value)
 ),'Employee Name',If(Sort, Descending,Ascending))
)

    The code above allows me to use the toggle switch and grade value to sort by, however the only thing I have not managed to get working at this stage is my button for showing [All Records] 

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 352 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 323

#3
Mohsin Ali Profile Picture

Mohsin Ali 226

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans