Hi @EmilyWinonaIT ,
Regarding the needs that you mentioned, I think it is not necessary to set up a collection to achieve your needs, it's complex. As an direct solution, you could add a extra "All" option to each ComboBox using the Concat function and Split function.
I have made a test on my side, please try the following workaround:
My Product Type Table data structure as below (only contains one column):
| Type |
| ----- |
| ERP |
| Dev |
| Test |
| Analyze |
The original options shown up inside the ComboBox as below:
If you want to add a "All" option to above ComboBox, please set the Items property to following:
Filter(
Split(
"All;" & Concat(ProductType, Type & ";"),
";"
),
!IsBlank(Result)
)
then set the DefaultSelectedItems property of the ComboBox to following:
{
Result: "All" // Result represents the column name you used as Display column name in your ComboBox
}
you could try above solution, then apply same logic to other rest of ComboBox.
In addition, if you want to filter your Galley Items based on multiple ComboBox selections, please try the following formula:
Filter(
'Your Data Source',
If(
IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = "All",
true,
Field1 = ComboBox1.Selected.Result
),
If(
IsBlank(ComboBox2.Selected.Result) || ComboBox2.Selected.Result = "All",
true,
Field2 = ComboBox2.Selected.Result
),
...
...
)
If you select "All" option within all ComboBoxes, the above Gallery would display "All" items without any filtering automatically, you do not need to set up a collection to store the filtered result, and bind it to the Gallery.
Please try above solution, hopes it could solve your problem.
Best regards,
