cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JAWL
Super User
Super User

Sort collection based on two columns

Dear Experts,

 

I have a hard time to sort below gallery items based on two columns (namely crd55_to and crd55_item1) in a collection. I have used Sort and SortByColumns but to no avail.

 

Sort

JAWL_0-1647832126169.png

 

SortByColumns will not work when I try to convert crdd_item1 (text) to number:

JAWL_1-1647832455554.png

 

I'd be obliged if you can share some insights on the workable sorting method.

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
EddieE
Super User
Super User

@JAWL 

Swap crd55_to to the OUTER Sort of your code.

View solution in original post

2 REPLIES 2
EddieE
Super User
Super User

@JAWL 

Swap crd55_to to the OUTER Sort of your code.

Adrian_Celis
Super User
Super User

@JAWL 

Maybe you can try SortByColumns like this:

SortByColumns(
Search(colNewPickList,TextSearchBox1_1.Text,"crd55_to","crd55_storagebin","crd55_sourcestoragetype"),
"crd55_to",
Descending,
"crd55_item1",
Descending
)

Note: You don't have to convert your column to number

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (3,738)