Answered

How to Sort by Choice Column Values in specific order

(0) Share

Report

Posted on by lardo5150 Microsoft Employee

I have a filter button that will filter data in a specific order.

OnSelect I have this:

ClearCollect(col_Engineers,SortByColumns(EngineersV2,"Total_x0020_Assigned",SortOrder.Descending));

So I grab all my engineers, and sort them by the number of assigned cases.

Depending on which filter (check box) I have selected, it will show me those records.

For example, if I choose to show all Available engineers, the code is:

If(
 l_available,
 ClearCollect(
 col_Engineers,
 Filter(
 col_Engineers,
 EngineerQueueStatus.Value = "Available" || 'EngineerQueueStatus'.Value = "Out of Queue Soon"
 )
 )
);

If I want to see who is in the office:

If(
 l_inoffice,
 ClearCollect(
 col_Engineers,
 Filter(
 col_Engineers,
 EngineerQueueStatus.Value <> "Unavailable"
 )
 )
);

The office one is the one i want to change.

I want to add some code to this piece, so that instead of sorting by total number of cases which is what the collection is set at, I would like to override that ONLY for this piece (inoffice).

I want to filter out the collection for ANYONE that has a queuestatus value of anything except Unavailable.

Then instead of showing me everyone in the office sorted by total cases, I want to sort it by the values in that Choice column.

So for me, I want it to sort like this..

Engineers in this order:

Available

Out of Queue Soon

Out of Queue

In Queue Soon

I keep running into errors.

I tried to add a SortByColumn into that inoffice piece of code, but it kept throwing up on me.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
I may have come up with a better way to do this with an if statement.
How would I setup the sorting the way I want it, when defining the collection.
example:
ClearCollect(col_Engineers,SortByColumns(EngineersV2,"Total_x0020_Assigned",SortOrder.Descending));
I have tried this a few ways, but I keep geting an error for SortByColumns.
Verified answer

lardo5150 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
I resolved this:

f(l_inoffice=true, ClearCollect( col_Engineers,SortByColumns( AddColumns( EngineersV2,"EngineerQueueStatus_value",EngineerQueueStatus.Value), "EngineerQueueStatus_value",["Available","Out of Queue Soon", "Out of Queue","In Queue Soon","In Queue Later","Assign No Cases", "Assign No Crits","Assign Only Crits"] ) ), ClearCollect(col_Engineers,SortByColumns(EngineersV2,"Total_x0020_Assigned",SortOrder.Descending ) ) );