@WarrenBelz
Just so save a wall of text, I removed the IF condition as it is quite cumbersome to read through. This condition is used in the items section of a gallery
SortByColumns(
IF(This condition does the item selection for the gallery via Filter())
//"["&SortColumnItems&"]",
//SortItems
"["&Concat(ComboBox3.SelectedItems, Char(34) &SortColumn &Char(34),",")&"]",
//Split(Concat(ComboBox3.SelectedItems, SortColumn,","),
//Dropdown3.Selected.SortColumn,
If(
Sort_Ascending,
SortOrder.Ascending,
SortOrder.Descending
)
)
The Combo box is outside of the gallery and the items are generated into a collection when the user loads the app. The table has 2 columns, one for Name and one for SortColumn. The Name is the display name shown to the user while the SortColumn is the name of the relevant column within the dataverse. I am able to sort if I used ComboBox3.Selected.SortColumn as it'll pull the last item selected, the combobox is a multi-selectable combobox
The issue is that SelectedItems is a table, while I have to feed a string into the 2nd parameter of SortByColumns()
