Hi@ajhstn,
Based on the issue that you mentioned, do you want to sort a custom order in a nested table?
Could you please share a bit more about your collection?
In general, we sort using the following formula:
SortByColumns( Table, ColumnName, SortOrderTable )
You could not directly sort a nested table, you should add a column to store the "_links.priority.title" values and sort based on this added column.
I have a test on my side, please take a try as below.
I create a nested collection as below:
ClearCollect(
MyTasks,
{
ID: 1,
_links: {priority: {title: "high"}}
},
{
ID: 2,
_links: {priority: {title: "low"}}
},
{
ID: 3,
_links: {priority: {title: "medium"}}
}
)
Add a Gallery to display this collection. To sort the custom order, set the Items property of the Gallery as below:
SortByColumns(
AddColumns(
MyTasks,
"SortColumn",
_links.priority.title
),
"SortColumn",
[
"high",
"medium",
"low"
]
)
Hope this could help you.
Best Regards,
Qi
