Power Platform Community Forum Thread Details

Hi everyone. I asked this question last week, rather poorly, so I am giving it another shot!

I am trying to sort by columns a drop down using the code below:

SortByColumns(Filter(Game_view_powerappss,StoreID= Value(varUser.Department)),If(Toggle4_1.Value,"cr3db_seqorder","cr3db_gamenameandmodifier"),Ascending))

This code is working perfectly on a gallery, but only partially on a drop down. The 2 dataverse columns are seqorder (a decimal column) and gamenameandmodifier (a text column). The gamenameandmodifier column, when sorted, results in an alphabetical layout, which is exactly what I need. When I click the toggle in the other direction, the data is sorted by seqorder, which goes from 1-200 correctly. These both work in the gallery, but not in the dropdown. Only the alphabetical works in the dropdown. I am trying to show the data from the gamenameandmodifier in the dropdown. I have very similar code that works in a sharepoint list for the dropdown, but not in the dataverse. Not sure if thats my issue or I am missing something in my syntax.

Any help would be great, thank you!

Chris

Categories:

Building Power Apps