You’re offline. This is a read only version of the page.
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?
Share
Report
All responses (
Answers (
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.
846
