I'm quite new to Honeycode and trying to customize the to-do app template. I'd like to have a filtered list of tasks ordered by their priority. I've created a priority table to populate the picklist and given it a 'sort order' column. However, in my filter function I get an error when trying to order by "Tasks[Priority][Sort Order]". I think it takes issue with trying to access the sort order through the 'priority' rowlink, but this syntax works fine when used as the filter condition "Tasks[Priority][Sort Order]=%".
Any ideas what I'm doing wrong? Does ORDER BY support accessing columns through row links? I'd prefer to avoid putting the sort order in the priority name if possible.