Answered

Sort not sorting

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have two collections that I want sorted but nothing seems to be working. I am building the collections based on other collections. The first collection is a list of customers with a 'Name' column. The second collection is of contact names (and other info) and also contains the customer name. I want to sort first by 'Customer' and the 'Name' so all contacts are in alpha order grouped by customer, which is also in alpha order.

These are my two Sort calls:

Sort(
 expCustCol,
 Name
);
Sort(
 Sort(
 expContCol,
 Customer
 ),
 Name
);

I then pass these to a Flow to create CSV files. I check the collections right after the sorts and then don't change.

I tried with the column names in quotes too, but no luck. I also tried switching tnhe Sort with SortByColumns abd no change.

Any ideas what I am missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Anonymous

To use multiple columns for sorting, you have to use the SortByColumns function.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-sort

Code would be something like this:

SortByColumns( expContCol, "Customer", SortOrder.Ascending, "Name",SortOrder.Ascending )

If i misunderstood your order, try this:

SortByColumns( expContCol, "Name", SortOrder.Ascending, "Customer",SortOrder.Ascending )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@cha_cha according to examples, Sort can work as I have it, but I had SortByColumns first and it didn't sort either. I have them as Sort because the SortBy didn't work, so tried this.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Just to make it easier to figure out I would place two vertical galleries on your screen and wokr out the syntax there first, but should be

SortByColums(expContCol, "Customer", SortOrder.Ascending, "Name", SortOrder.Ascending)

and

SortByColumns(expCustCol,"Name", SortOrder.Ascending)

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Oops we crossed haha

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @Anonymous

Maybe there is a type issue on your code? That's the most probable reason I can think of if the sorting is not working. This might be a type on the code or the data like extra spaces.

Was this reply helpful? Yes No
Verified answer

cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Ah!

You need to assign the sorted information to a collection.

ClearCollect(COL_ABC,Sort( Sort( expContCol, Customer ), Name );)

Then Export COL_ABC.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

thank you.

Was this reply helpful? Yes No