Also, I realized you may run into issues since you have two separate buttons for Approved/Pending. If you are modeling this interaction based on the sort order, the primary difference is that sorting has two states, ascending and descending. So, the button simply toggles between these two. However, your approved/pending filtering actually has three states that are related to each other. no filtering, approved only, pending only.
In order to properly handle this, it won't be sufficient to use the same interaction as the Sort button. Instead, you may want to have a dropdown that chooses between one of the three states. You can then change the Filter based on this dropdown's value with the Switch() function.
This could look like
Filter(
ECTCR_Tracking,
Switch(
ApprovalStatus.Selected.Value,
"Approved Only", CP_x0020_Status.Value = "Approved",
"Pending Only", CP_x0020_Status.Value = "Pending",
"Any", true
)
)
When this is nested into the entire function, it would look like the following:
SortByColumns(
Filter(
Filter(
ECTCR_Tracking,
Switch(
ApprovalStatus.Selected.Value,
"Approved Only", CP_x0020_Status.Value = "Approved",
"Pending Only", CP_x0020_Status.Value = "Pending",
"Any", true
)
),
StartsWith(Title, SearchInput.Text) ||
StartsWith(Text(ID, "[$-en-US]##"), SearchInput.Text)
),
"ID",
If(
SortDescending1,
Descending,
Ascending
)
)
