Sorting a dropdown list in a canvas app

(1) Share

Report

Posted on by Simon Dowse

146

Hi All

I've been trying to work this out for a couple of hours with no luck.

I have a canvas app with a dropdown in it. The drop down gets its items from a dataverse table called

Paperwork Button Text 1 using a column called Text.
 
In the dropdown Properties pane Items is set to Paperwork Button Text 1S and Value is set to Text.
 
The items in the dropdown list don't seem to be sorted at all and I want a custom sort. I have added a column 
to the dataverse table called Sort Order and have given each entry a number to identify where they should be in the sort order.
 
What I can't do is work out how to tell the canvas app to sort the dropdown list using this column - I've tried using Sort in the Items box
but I can't get the syntax to work despite trying various options found on the web.
 
Can anyone help?
 
Thanks!
 
Simon

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

Hi

Let's pretend you have 2 columns

Foo and SortOrder

And they are in Table School

SortByColumns(School, "SortOrder", SortOrder.Ascending)

And done

Was this reply helpful? Yes No
Simon Dowse 146 on at

Like (0)

Report

Thanks so much @FLMike - it works perfectly.

One thing I had to do which might be useful for anyone else finding this post is that as my table name had spaces in it I had to enclose it in single inverted commas - so using FLMike's example but with a table name of I Hate School, it would be

SortByColumns('I Hate School', "SortOrder", SortOrder.Ascending)

Thanks again.

Simon

Was this reply helpful? Yes No