Collection Sorting in Power Apps

(0) Share

Report

Posted on by Sajith

182

I have a dropdown collection as shown below. How to get 130 first and 122 last in descending order ?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Krishna_R 525 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sajith

Have you tried
SortByColumns( collection, Column Name, Descending )

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Sajith ,
How do you create the collection? Could you please provide the formula about how do you create this collection?
Best regards,
Allen

Was this reply helpful? Yes No
Sajith 182 on at

Like (0)

Report
Copy link

Link copied!

Unable to use this and not sure how to use SortByColumns

Was this reply helpful? Yes No
Sajith 182 on at

Like (0)

Report
Copy link

Link copied!

The requirement is to have a blank selection. Hence I used the below formula - OnSelect of Dropdown
ClearCollect(ERCollection,{Name:""});Collect(ERCollection,Distinct(Request,ERNos))
Here Request is SharePoint List Name and ERNos is List Field Name.

Then assigned ERCollection to Items of Dropdown. Now I want to sort it descending.

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Sajith ,
Try this:
SortByColumns(ERCollection,"Result",Descending)
Best regards,
Allen

Was this reply helpful? Yes No
Sajith 182 on at

Like (0)

Report
Copy link

Link copied!

The formula -SortByColumns(EReqCollection,"Result",Descending) - works for items property of dropdown control.
However the blank selection is coming last - ClearCollect(ERCollection,{Name:""}); Any option to make it first. Please note that one more blank is actual value in the field.

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Sajith ,

I can understand what you mean now.

You can directly sort the distinct results when creating this collection(except the first blank value). So try to create the collection using this code:

ClearCollect(ERCollection,{Result:""},SortByColumns(Distinct(Request,ERNos),"Result",Descending))

Best regards,

Allen

Was this reply helpful? Yes No
Sajith 182 on at

Like (0)

Report
Copy link

Link copied!

The values are coming in New/Edit Form.
However in Edit, the value stored in list column is not getting selected on Page Load.
Dropdown Item - ERCollection
Dropdown OnSelect - ClearCollect(ERCollection,{Result:""},SortByColumns(Distinct(EngineeringRequest,ERNos),"Result",Descending))
Dropdown Default - ""

For default, ThisItem.ERRefNo is not getting selected while editing the form.

Was this reply helpful? Yes No