I'm receiving a delegation warning for an if statement in an application I'm working on. I believe that part of the problem is resulting from my use of the "in" operator which isn't delegable. I also seem to be getting delegation warnings for each and operator I'm using throughout as well. I would greatly appreciate any assistance in resolving my inquiry.
Here is the code I'm using:
SortByColumns(
Filter(
'TestRequestForm-UAT',
StartsWith(Title, txtTRTitle) && StartsWith(Requestor, txtRequestor) && StartsWith(TestRequestNumber, txtTRNum) && StartsWith(TestMainName, txtTestMain)
&&
(
Status = ddpStatus_4.Selected.Result ||
ddpStatus_4.Selected.Result = "Select Status"
) &&
(
If(
ddpStatus_9.Selected.Value = "Open",
Not(Status in ["Deleted", "Completed", "Cancelled"]),
If(
ddpStatus_9.Selected.Value = "Closed",
Status in ["Deleted", "Completed", "Cancelled"],
ddpStatus_9.Selected.Value = "Select Status"
)
)
) &&
(
'Test Type'.Value = ddpTestType_4.Selected.Result ||
ddpTestType_4.Selected.Result = "Select Test Type"
) &&
(
'Sub Type'.Value = ddpSubType1.Selected.Result ||
ddpSubType1.Selected.Result = "Select Sub Type"
) &&
(
ddpEngAsset.Selected.Result in 'Engineering Asset'.Value ||
ddpEngAsset.Selected.Result = "Select Eng Asset"
) &&
(
'Business Unit' = ddpBusinessUnit.Selected.Result ||
ddpBusinessUnit.Selected.Result = "Select Business Unit"
) &&
(
'ProjectPhase (ProjectPhase0)'.Value = ddpProjPhase.Selected.Result ||
ddpProjPhase.Selected.Result = "Select Project Phase"
) &&
(
'Department Number' = ddpDeptNum.Selected.Result ||
ddpDeptNum.Selected.Result = "Select Department Number"
) &&
(
ProjectNumber = ddpProjNum.Selected.Result ||
ddpProjNum.Selected.Result = "Select Project Number"
)
&& Not(Status in ["Draft","Deleted"])
),
"TestRequestNumber",
varSortDirection
)
