@Digital_Admin
That should also work.
Please double check syntax.
SortByColumns(
With(
{
_Letters_List_Url:
'Letters List url'
},
Filter(
_Letters_List_Url,
And(
Or(
And(
From.Value = varUserDepartment,
(Status.Value = "In Progress" || Status.Value = "Approved" || Status.Value = "NEW" || Status.Value = "Completed" || Status.Value = "Delivered" || Status.Value = "Rejected")
),
And(
varUserDepartment in TO.Value,
(Status.Value = "Completed" || Status.Value = "Delivered")
),
And(
Status.Value = "Draft",
'Created By'.Email = varUser.Signer.Email
)
),
Or(
IsBlank(Date_From.Value),
Created >= Date_From.Value
),
Or(
IsBlank(Date_To.Value),
Created <= Date_To.Value
),
Or(
IsBlank(DDDept.Selected.Value),
From.Value = DDDept.Selected.Value,
DDDept.Selected.Value in To.Value
),
Or(
IsBlank(DD_Status.Selected.Value),
Status.Value = DD_Status.Selected.Value
),
Or(
IsBlank(SB_Home_Ref.Text),
CalRef = Value(SB_Home_Ref.Text)
),
Or(
IsBlank(SB_Home.Text),
StartsWith(
Title,
SB_Home.Text
),
StartsWith(
'Subject To',
SB_Home.Text
)
),
Or(
IsBlank(Radio_Filter.Selected.Value),
Radio_Filter.Selected.Value = "OUT",
varUserDepartment in To.Value
),
Or(
IsBlank(Radio_Filter.Selected.Value),
Radio_Filter.Selected.Value = "IN",
From.Value = varUserDepartment
)
)
)
),
"ID",
If(
SortDescending1,
SortOrder.Ascending,
SortOrder.Descending
)
)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
