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?
@Anonymous
You could also drag and sort the choice items from the Choices menu in Modern View.
Yes, you can do such a sort, but you need to sort by an alternative means. For example, the alphabetical is good to sort on, but you need an additional column to sort as well. Then you would use the SortByColumns and provide but columns for sorting.
Is there a way to place one of the items in the list at the end but keep the remaining items in alphabetical order?
This worked great. Thank You for the clarification
Same/similar issues. First off, please forgive my lack of knowledge.
I have created a list in "lists" that is on sharepoint.
I had the system try and build an app that i have been modifying/adding to.
On the home screen, i have a button navigating to a list view screen. On said list view screen, i want to have drop down choices that will filter results accordingly. When/if no choice is made, it will show everything.
Thanks for the help!
If you are using Dataverse Choices then you can refer this piece of code
Sort(Choices('int type'),Left(Value,1),Ascending)...
Thank tou @RandyHayes . I had the same issue.
Also, i have found this great article Power Apps Choices Function with Examples - SPGuides.
@Anonymous
That is because you are using dataverse and not SharePoint. Choices columns in SharePoint can be sorted as mentioned in this thread.
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.