I am trying to sort the content of a SharePoint calculated column in a Power Apps Combo Box.
If I filter the SP column content it all comes through without issue, but it is not sorted.
When I replace 'Filter' with 'Sort' (see below) I get errors.
It is my understanding that SP calculated columns are not searchable in a Power Apps Combo Box?
Is this true, and does the same restriction apply to the sorting of SP calculated column content in a
Power Apps Combo Box?
What am I missing?
First Attempt:
If(Role_DataCardValue.Text = "Subcontractor",Sort(Staking_Collection,Cost_Type = "Subcontractor" && Title =
Location_Dropdown.Selected.Value).Billing_Unit_and_Description,SortOrder.Ascending),
If(Role_DataCardValue.Text = "Technician",Sort(Staking_Collection,Cost_Type = "In House" && Title =
Location_Dropdown.Selected.Value).Billing_Unit_and_Description,SortOrder.Ascending)
Second Attempt:
If(Role_DataCardValue.Text = "Subcontractor",Sort(Staking_Collection,Cost_Type = "Subcontractor" && Title =
Location_Dropdown.Selected.Value).Billing_Unit_and_Description,SortOrder.Ascending,
If(Role_DataCardValue.Text = "Technician",Sort(Staking_Collection,Cost_Type = "In House" && Title =
Location_Dropdown.Selected.Value).Billing_Unit_and_Description,SortOrder.Ascending))