Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Gallery Filter by Multiple Check boxes

(0) ShareShare
ReportReport
Posted on by 37

Hi All,

 I have a simple gallery with 2 Filter 1 Search and 3 Checkboxes

 

hackondor_0-1619047076055.png

 

- My Collection (MasterLocalCollection)

- SBU ( Combobox Single choice)

- Manager (Combobox Multi-choices)

- Search (For 2 column: "Project_x0020_Name", "Project_x0020_Description"  )

- Prepare & Execute & Close Are simple checkboxes

 

I'm trying to combine all those filters, so far everything works well but I'm struggling to combine the Multi-select for my 3 checkboxes

 

NB: I'm using Left() to check the 2 first characters for the Current_x0020_Project_x0020_Phas column

 

 

Ungroup(
 ForAll(
 RenameColumns(
 FilterByManager.SelectedItems,
 "Result",
 "CurrentFilterValue"
 ),
 {
 ItemsGroupedByFilterValue: Search(Filter(
 MasterLocalCollection,
 FilterByManager.Selected.Result="All" Or IS_x0020_Project_x0020_Manager_x = CurrentFilterValue,
 FilterBySBU.Selected.Value="All" Or Main_x0020_Sub_x0020_Business_x0.Value=FilterBySBU.Selected.Value,
 //Checkboxes
 Checkbox_Prepare.Value=false Or Left(Current_x0020_Project_x0020_Phas.Value,2) = "P1" || Left(Current_x0020_Project_x0020_Phas.Value,2) = "P2" || Left(Current_x0020_Project_x0020_Phas.Value,2) = "P3",
 Checkbox_Execute.Value=false Or Left(Current_x0020_Project_x0020_Phas.Value,2) = "PW" || Left(Current_x0020_Project_x0020_Phas.Value,2) = "PA",
 Checkbox_Close.Value=false Or Left(Current_x0020_Project_x0020_Phas.Value,2) = "P6"
 ),SearchByNameAndDesc.Text, "Project_x0020_Name", "Project_x0020_Description")
 }
 ),
 "ItemsGroupedByFilterValue"
)

 

 

 

 

How can I achieve that?

 

Thank you

  • hackondor Profile Picture
    hackondor 37 on at
    Re: Gallery Filter by Multiple Check boxes

    Hi @PatilChetan ,

    Thank you for your reply

    It's working see below 

    hackondor_0-1619127054647.png

    hackondor_1-1619127100126.png

     

    I want to compare with the first characters like: 

    Left(Current_x0020_Project_x0020_Phas.Value,2) = "P1"

     

    Is there any way to achieve that, I've tested with Left, Starwith but nothing work.

     

    Any ideas?

     

     

     

     

  • Verified answer
    PatilChetan Profile Picture
    PatilChetan 126 on at
    Re: Gallery Filter by Multiple Check boxes

    @hackondor 

     

    Refer the post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Checkbox-as-search-refiners/m-p/891444/highlight/true#M283008 

     

    Updated code, added ComboBox Selected Values condition:

    App - Saved (Unpublished) - Power Apps - Personal - Microsoft​ Edge 4_22_21 11_56_22 AM.png

     

    Regards,

    Chetan

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard