I want to select multiple items in the combobox but I can't do it.
When selecting an item, the gallery filter gets.Example:
If I select one more item, it will show the newly selected item:
And here's my code:
Switch(
varSortColumn,
"ID",
SortByColumns(
Filter(
RestockProduct,
StartsWith(
Title,
txt_NameFilter_2.Text
) && ( Status.Value = cmb_StatusRestock.Selected.Value || cmb_StatusRestock.Selected.Value = Blank()), DateRestock >=dpFrom_1.SelectedDate && DateRestock <= dpTo_1.SelectedDate
),
"ID",
If(varSortDirection=SortOrder.Ascending,SortOrder.Ascending,SortOrder.Descending)),
"Title",
SortByColumns(
Filter(
RestockProduct,
StartsWith(
Title,
txt_NameFilter_2.Text
) && (Status.Value = cmb_StatusRestock.Selected.Value || cmb_StatusRestock.Selected.Value = Blank()), DateRestock >=dpFrom_1.SelectedDate && DateRestock <= dpTo_1.SelectedDate
),
"Title",
If(varSortDirection=SortOrder.Ascending,SortOrder.Ascending,SortOrder.Descending)),
"QuantityRestock",
SortByColumns(
Filter(
RestockProduct,
StartsWith(
Title,
txt_NameFilter_2.Text
) && (Status.Value = cmb_StatusRestock.Selected.Value || cmb_StatusRestock.Selected.Value = Blank()), DateRestock >=dpFrom_1.SelectedDate && DateRestock <= dpTo_1.SelectedDate
),
"QuantityRestock",
If(varSortDirection=SortOrder.Ascending,SortOrder.Ascending,SortOrder.Descending)),
"TotalPrice",
SortByColumns(
Filter(
RestockProduct,
StartsWith(
Title,
txt_NameFilter_2.Text
) && (Status.Value = cmb_StatusRestock.Selected.Value || cmb_StatusRestock.Selected.Value = Blank()), DateRestock >=dpFrom_1.SelectedDate && DateRestock <= dpTo_1.SelectedDate
),
"TotalPrice",
If(varSortDirection=SortOrder.Ascending,SortOrder.Ascending,SortOrder.Descending)),
"DateRestock",
SortByColumns(
Filter(
RestockProduct,
StartsWith(
Title,
txt_NameFilter_2.Text
) && (Status.Value = cmb_StatusRestock.Selected.Value || cmb_StatusRestock.Selected.Value = Blank()), DateRestock >=dpFrom_1.SelectedDate && DateRestock <= dpTo_1.SelectedDate
),
"DateRestock",
If(varSortDirection=SortOrder.Ascending,SortOrder.Ascending,SortOrder.Descending))
)
Please help me. I thank everyone very much.
