Power Platform Community Forum Thread Details

Hi! I have some problem with modern combobox. I use the same formulae to classic combobox ,there is no error notification. The gallery is normally shown. But when I filter by the combobox, the gallery disappears. I don't know what's wrong 😭

And another problem is I want to filter Status that is text field by using toggle. When the toggle is checked, I want the gallery show only items have "Open" status. And when it is unchecked,the gallery show "Closed" status. I have tried the formulas from Mr. JimmyBecks but it does not work. I might lack of understanding the toggle.

This is my data base from excel. I want to filter the status with other multiple filter

Any one can help or suggest,please?

Categories:

Building Power Apps

If(StatusToggle.Checked,
 SortByColumns(
 Search(
 Filter(
 OPL_EV6,'Status'="Open",
 'Person In Charge' = cbxPerson.Selected.Value || IsBlank(cbxPerson.SelectedItems.Value)|| IsEmpty(cbxPerson.SelectedItems),
 Station = cbxStation.Selected.Value || IsBlank(cbxStation.SelectedItems.Value)||IsEmpty(cbxStation.SelectedItems),
 And(
 Or(
 IsBlank(dpkStartDate.SelectedDate),
 'Issue Date' >= dpkStartDate.SelectedDate
 ),
 Or(
 IsBlank(dpkEndDate.SelectedDate),
 'Issue Date' <= dpkEndDate.SelectedDate
 )
)),
 SearchInput.Value,
 "OPL Description",
 "Person In Charge",
 "Station"
 )),
 SortByColumns(
 Search(
 Filter(
 OPL_EV6,'Status'="Closed",
 'Person In Charge' = cbxPerson.Selected.Value || IsBlank(cbxPerson.SelectedItems.Value)|| IsEmpty(cbxPerson.SelectedItems),
 Station = cbxStation.Selected.Value || IsBlank(cbxStation.SelectedItems.Value)||IsEmpty(cbxStation.SelectedItems),
 And(
 Or(
 IsBlank(dpkStartDate.SelectedDate),
 'Issue Date' >= dpkStartDate.SelectedDate
 ),
 Or(
 IsBlank(dpkEndDate.SelectedDate),
 'Issue Date' <= dpkEndDate.SelectedDate
 )
)),
 SearchInput.Value,
 "OPL Description",
 "Person In Charge",
 "Station"
 )))

I have already fixed my combobox filter, I change " " to ' ' . But the toggle is not worked.