I have a gallery that is based on the following. What I would like is for the gallery to NOT display completed items unless the "Completed" Radio Button is selected. How should I modify "Items" portion. I have included a pic of the FilterPane at the end of this posting.
With(
{
_items:
Filter(
'Safety Good Catch Items',
(
IssueType.Value = Dropdown2.Selected.Value ||
Dropdown2.Selected.Value = Blank()
) &&
(
AssignedToDN = Dropdown1.Selected.FullName ||
Dropdown1.Selected.FullName = "---"
) &&
(
Status.Value = statusRadio.Selected.Value ||
statusRadio.Selected.Value = Blank()
) &&
(
!Checkbox1.Value ||
CreatedByEmail = User().Email
)
)
},
Filter(
_items,
DaysOldRadio.Selected.Value = Blank() ||
Switch(
DaysOldRadio.Selected.Value,
"0-30",
DaysOld = 0 || DaysOld <= 30,
"31-60",
DaysOld > 31 && DaysOld <= 60,
"61-90",
DaysOld > 61 && DaysOld <= 90,
"91-120",
DaysOld > 91 && DaysOld <= 120,
">120",
DaysOld > 121)))
