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 :
Power Platform Community / Forums / Power Apps - Building Power Apps / Adding 2nd Gallery Fil...
Power Apps - Building Power Apps
Unanswered

Adding 2nd Gallery Filter Selection

(0) ShareShare
ReportReport
Posted on by RJF61 1,221
I have the following for the Items of a gallery filter.  This is for the selection in "green" of CABNTMKR, CAPITAL, etc.).  I want to add similar for the items in the "red" box but am struggling with where/how to include.
 
 
Sort(
   Filter(
       ShortFormII,
       Or(
           IsBlank(cbGrps.SelectedItems),
           IsEmpty(cbGrps.SelectedItems),
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,1)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,2)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,3)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,4)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,5)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,6)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,7)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,8)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,9)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,10)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,11)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,12)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,13)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,14)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,15)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,16)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,17)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,18)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,19)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,20)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,21)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,22)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,23)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,24)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,25)).WrkCtr,
           WorkCenter = Last(FirstN(cbGrps.SelectedItems,26)).WrkCtr
       ),
       (
       Active = tglActive.Value And
       StatusChoice.Value = ddStatusChoice.Selected.Value
       ),
       (
        IDWBSENo = ddWBSE.Selected.Title ||
        ddWBSE.Selected.Title = "---"
       ),
       (
        WorkOrder = drpdwnWO.Selected.Value ||
        drpdwnWO.Selected.Value = Blank()
       ),
       (
        Location = drpdwnLoc.Selected.Value ||
        drpdwnLoc.Selected.Value = Blank()
       )
),
   ProjectTitle,
   SortOrder.Ascending
)
 
Essentially...
 
ShortForm,
Or(
     IsBlank(cbSChoice.SelectedItems),
     IsEmpty(cbSChoice.SelectedItems),
     StatusChoice = Last(FirstN(cbSChoice.SelectedItems,1)).SFStatus,
     StatusChoice = Last(FirstN(cbSChoice.SelectedItems,2)).SFStatus,
     StatusChoice = Last(FirstN(cbSChoice.SelectedItems,3)).SFStatus,
     StatusChoice = Last(FirstN(cbSChoice.SelectedItems,4)).SFStatus,
     StatusChoice = Last(FirstN(cbSChoice.SelectedItems,5)).SFStatus
Categories:
General Questions
I have the same question (0)
  • MS.Ragavendar Profile Picture
    MS.Ragavendar 4,013 Super User 2025 Season 2 on at
    Adding 2nd Gallery Filter Selection
     
    I believe the checkbox which you added will be inside the gallery, compare the item property of both gallery controls( checkbox) and copy the relevant values in the Items property of the gallery now the red gallery will also have the data of the green gallery as well.
     
    If you need help in filtering of items in the gallery too ?
     
  • RJF61 Profile Picture
    RJF61 1,221 on at
    Adding 2nd Gallery Filter Selection
     
    Is this what you are suggesting?
     
    Filter(
           ShortFormII,
           Or(
               IsBlank(cbGrps.SelectedItems),
               IsEmpty(cbGrps.SelectedItems),
               IsBlank(cbSChoice.SelectedItems),
               IsEmpty(cbSChoice.SelectedItems),
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,1)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,2)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,3)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,4)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,5)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,6)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,7)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,8)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,9)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,10)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,11)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,12)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,13)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,14)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,15)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,16)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,17)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,18)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,19)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,20)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,21)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,22)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,23)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,24)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,25)).WrkCtr,
               WorkCenter = Last(FirstN(cbGrps.SelectedItems,26)).WrkCtr,
               StatusChoice.Value = Last(FirstN(cbSChoice.SelectedItems,1)).SFStatus,
               StatusChoice.Value = Last(FirstN(cbSChoice.SelectedItems,2)).SFStatus,
               StatusChoice.Value = Last(FirstN(cbSChoice.SelectedItems,3)).SFStatus,
               StatusChoice.Value = Last(FirstN(cbSChoice.SelectedItems,4)).SFStatus,
               StatusChoice.Value = Last(FirstN(cbSChoice.SelectedItems,5)).SFStatus,
               StatusChoice.Value = Last(FirstN(cbSChoice.SelectedItems,6)).SFStatus
           ),
           (
           Active = tglActive.Value
           ),
           (
            IDWBSENo = ddWBSE.Selected.Title ||
            ddWBSE.Selected.Title = "---"
           ),
           (
            WorkOrder = drpdwnWO.Selected.Value ||
            drpdwnWO.Selected.Value = Blank()
           ),
           (
            Location = drpdwnLoc.Selected.Value ||
            drpdwnLoc.Selected.Value = Blank()
           )
    ),
       ProjectTitle,
       SortOrder.Ascending
    )

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
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 839 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 489

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 397 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

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

Product updates

Microsoft Power Platform Community release plans