Sort(
Filter(
FinanceContentTables,
(IsBlank(drpTransformationArea.Selected.Value) ||
'Transformation Area' = drpTransformationArea.Selected.Value)
&& (IsBlank(drpTechnologyplatform.Selected.Value) ||
'Technology Platform' = drpTechnologyplatform.Selected.Value)
&& (IsBlank(drpTechnologydetails.Selected.Value) ||
'Technology Details' = drpTechnologydetails.Selected.Value)
&& (IsBlank(drpFinanceprocess.Selected.Value) ||
FinanceProcess = drpFinanceprocess.Selected.Value)
&& (IsBlank(drpFinanceOrganization.Selected.Value) ||
FinanceOrganization = drpFinanceOrganization.Selected.Value)
&& (IsBlank(drpComptencylevel.Selected.Value) ||
CompetencyLevel = drpComptencylevel.Selected.Value)
&& (IsBlank(drpContenttype.Selected.Value) ||
ContentType = drpContenttype.Selected.Value)
),
If(
drpSort.Selected.Value = "ContentViews",
ContentViews,
If(
drpSort.Selected.Value = "ContentUploadDate",
ContentUploadDate,
If(
drpSort.Selected.Value = "ContentRating",
ContentRating,
ContentViews // Default to ContentViews if none match
)
)
),
If(
drpSort.Selected.Value = "ContentViews" ||
drpSort.Selected.Value = "ContentRating" ||
drpSort.Selected.Value = "ContentUploadDate",
SortOrder.Descending,
SortOrder.Ascending // Default sort order if none of the above match
)
)