Sorting a dropdown list in a canvas app

Like (1) Share

Report

Posted on 20 Aug 2024 16:08:44 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 component framework

All responses (2)

Answers (1)

Simon Dowse 146 on 27 Aug 2024 at 16:53:19

Like (0)

Report

Sorting a dropdown list in a canvas app

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
Verified answer

Michael E. Gernaey 42,048 Super User 2025 Season 1 on 20 Aug 2024 at 21:11:44

Like (1)

Report

Sorting a dropdown list in a canvas app

Hi

Let's pretend you have 2 columns

Foo and SortOrder

And they are in Table School

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

And done