Sorting by Ascending

(0) Share

Report

Posted on by Miik

Hi Guys,

I am having problems sorting my 'Practice Name' Column in Ascending order.

I have tried the following, but it is still random:

Distinct( Sort( 'GP Site Details', Trim('Practice Name'), SortOrder.Ascending ),'Practice Name')

SortByColumns('GP Site Details',"Practice_x0020_Name", SortOrder.Ascending)

Nothing works.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Miik 94 on at

Like (0)

Report

Also, my list in sharepoint is Ascending.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @Miik ,

Try below formula:

Distinct(Sort(AddColumns('GP Site Details',"PN",Trim(ThisRecord.'Practice Name')), PN,SortOrder.Ascending),'Practice Name')

Best regards,

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report

Hi, thanks for your feedback, but it is still random.

Am I using the collect option "OnSelect"

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Miik ,

No, you should use the formula in Items of a Gallery.

Best regards,

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report

Thanks, my drpBox is not in a gallery. I am using a form and the drpBox is outside the boundary. Its on its own, so maybe this function will not work the same.

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report

I found out that if I change the Item of the sharepointform1, the Ascending work, but I loose my source and no data is displayed in PowerApps

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Miik ,

What's this Dropdown for? Anyway, its Items need the formula I provided.

Best regards,

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report

I use the drpBox to select records from the sharepoint list.

Was this reply helpful? Yes No
Miik 94 on at

Like (0)

Report

If I can get it into Ascending, users can select surgeries better.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @Miik ,

It's a SharePoint customize form, so the record should be selected from in the list and then display in the Form for viewing or editing. If you want to select another record from the dropdown which has the same data source as the form and do the same thing, try below steps:

1. Items of Dropdown:

Sort(AddColumns('GP Site Details',"PN",Trim(ThisRecord.'Practice Name')), PN,SortOrder.Ascending)

2. Set primary field of the Dropdown as Practice Name.

3. Item of SharePointForm1

coalesce(Dropdown.Selected, SharePointIntegration.Selected)

Best regards,

Was this reply helpful? Yes No