Hi All,
I have a simple gallery with 2 Filter 1 Search and 3 Checkboxes
- 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
Hi @PatilChetan ,
Thank you for your reply
It's working see below
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?
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:
Regards,
Chetan