Greetings,
I have an app that filters the collection based on multiple (optional) fields when the data is loaded. This all working fine, until I attempt to an additional filter based on whether a 'Completed Date' field has been entered. The filter is ddEART_StatusFilter and has values of "Active, Completed, All". If Active is chosen, the filter should include all records with a blank completed date; Completed should filter all records with a completed date; and All should show all records. It works with the exception of all. I'm sure I'm overlooking something easy.
The filters for that dropdown are shown in orange text below. Appreciate any guidance!
Search(
Sort(
Filter(
colEngReq,
IsBlank(ddEART_GridFilter_ReqType.Selected.Value) || false || 'Request Type'.Value = ddEART_GridFilter_ReqType.Selected.Value,
IsBlank(ddEART_GridFilter_FO.Selected.Value) || false || 'Field Office' = ddEART_GridFilter_FO.Selected.Value,
IsBlank(ddEART_GridFilter_AssignedTo.Selected.Value) || false || AssignedTo.Value = ddEART_GridFilter_AssignedTo.Selected.Value,
ddEART_FiscalYearFilter.Selected.Value = "All" || 'Fiscal Year' = ddEART_FiscalYearFilter.Selected.Value,
If(
ddEART_StatusFilter.Selected.Value = "Active",
IsBlank('Completed Date'),
If(ddEART_StatusFilter.Selected.Value = "Completed",
!IsBlank('Completed Date'),"")
)
),
ID,
SortOrder.Descending
),
txtEART_GridFilter_Participant.Text,
"Participant"
)
