Unable to sort with Choices field

(0) Share

Report

Posted on by simms7400

829

Hello Folks -

I currently have a field in SP that has a list of values. I'm levraging it in PowerApps with the following syntax:

Choices(rdTargetChangeReq.nIpOwner)

However, I want to be able to sort this column alpabetically. I tried this with no success:

Sort(rdTargetChangeReq,nIpOwner.Value, Ascending)

Any ideas? Do I need to combine both of those functions?

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@simms7400

Because that is a Choice column, you'll need to pull the value into a text column that you can sort on.

Try this formula:

SortByColumns(AddColumns(rdTargetChangeReq, "columnValue", nIpOwner.Value), "columnValue", Ascending)

I hope that helps you some.

Was this reply helpful? Yes No
simms7400 829 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes Thank you!

I added the formula in the "Items" box on my form but there is an error saying "The specified column 'Value' does not exist".

Am I doing anything wrong?

Was this reply helpful? Yes No
simms7400 829 on at

Like (0)

Report
Copy link

Link copied!

In your suggested formula, should I be replacing "columnvalue" with anything?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@simms7400

Where are you seeing the error for the "Value"? The formula should be used exactly as it was. You can change the "columnValue" name to whatever you want, but you can also just leave it as-is.

Was this reply helpful? Yes No
simms7400 829 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes - here you go:

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (5)

Report
Copy link

Link copied!
@simms7400

OH~!!!! You're doing this on a DataCard. My misunderstanding, thought you had a Gallery you were sorting.

In that case, you need to change the Items property of the Combo Box in your datacard to :

Sort(Choices(rdTargetChangeReq.nIpOwner), Value, Ascending)

Sorry I misunderstood.

Was this reply helpful? Yes No
simms7400 829 on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes That worked perfectly!!!!

Thank you so much - have a great weekend!!!

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

Like (1)

Report
Copy link

Link copied!

None of this worked for me. For anyone struggling with the same, ultimately what worked for me was to go in the Solution area -> Classic View -> locate your Option List. Go into the Option list and sort it alphabetically in that Classic view area and the Publish that Choices list again. I tried everything and more in this thread and nothing worked except doing this.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

That is because you are using dataverse and not SharePoint. Choices columns in SharePoint can be sorted as mentioned in this thread.

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

Like (0)

Report
Copy link

Link copied!

Thank tou @RandyHayes . I had the same issue.
Also, i have found this great article Power Apps Choices Function with Examples - SPGuides.

Was this reply helpful? Yes No