Sort(
Filter(
Risk_Master,
(
(IsBlank(cmbListRiskBlock.SelectedItems) || IsEmpty(cmbListRiskBlock.SelectedItems) || Block_No.Value in cmbListRiskBlock.SelectedItems) &&
(IsBlank(cmbListRiskOwner.Selected) || IsEmpty(cmbListRiskOwner.SelectedItems) || Issue_Owner.DisplayName = cmbListRiskOwner.Selected.Result) &&
(IsBlank(cmbListRiskSite.Selected) || IsEmpty(cmbListRiskSite.SelectedItems) || Site.Value = cmbListRiskSite.Selected.Value) &&
((cmbListRiskStatus.Selected.Value = "All Status") || (IsBlank(cmbListRiskStatus.Selected) || IsEmpty(cmbListRiskStatus.SelectedItems) || Issue_Status.Value = cmbListRiskStatus.Selected.Value)) &&
(IsBlank(txtKeyword.Value) || txtKeyword.Value in Title & Resolution_Month & Resolution_Year & Funding_Type.Value)
)
),
Value(Block_No.Value),
SortOrder.Ascending
)
BlockNo.Value in cmbListRiskBlock.SelectedItems.Value
With(
{
_Data:
Filter(
Risk_Master,
(
Len(cmbListRiskOwner.Selected.Result) = 0 ||
Issue_Owner.DisplayName = cmbListRiskOwner.Selected.Result
) &&
(
Len(cmbListRiskSite.Selected.Value) = 0 ||
Site.Value = cmbListRiskSite.Selected.Value
) &&
(
cmbListRiskStatus.Selected.Value = "All Status" ||
Len(cmbListRiskStatus.Selected.Value) = 0 ||
Issue_Status.Value = cmbListRiskStatus.Selected.Value
)
)
},
Sort(
Search(
Filter(
AddColumns(
_Data,
BlockNo,
BlockNo.Value,
FundingType,
Funding_Type.Value,
LRPFunding,
Long_Range_Plan_Funding.Value
),
Len(cmbListRiskBlock.Selected.Value) = 0 ||
BlockNo in cmbListRiskBlock.SelectedItems
),
txtKeyword.Value,
Title,
Resolution_Month,
Resolution_Year,
FundingType,
LRPlanFunding
)
)
)
Sort(
Filter(
Risk_Master,
(
(Len(cmbListRiskBlock.Selected.Value)=0 || Block_No.Value in cmbListRiskBlock.SelectedItems) &&
(Len(cmbListRiskOwner.Selected.Result)=0 || Issue_Owner.DisplayName = cmbListRiskOwner.Selected.Result) &&
(Len(cmbListRiskSite.Selected.Value)=0 || Site.Value = cmbListRiskSite.Selected.Value) &&
((cmbListRiskStatus.Selected.Value = "All Status") || (IsEmpty(cmbListRiskStatus.SelectedItems) || Issue_Status.Value = cmbListRiskStatus.Selected.Value)) &&
(IsBlank(txtKeyword.Value) || txtKeyword.Value in Title & Resolution_Month & Resolution_Year & Funding_Type.Value & Long_Range_Plan_Funding.Value)
)
),
Value(Block_No.Value),
SortOrder.Ascending
)