Announcements
Hi folks,
I've created a SharePoint List from an excel spreadsheet and to a certain extent customised the view/edit via PowerApps. One of the fields I pulled in via the excel was a list of names (field titled LCO). On importing via the excel I selected this column to be a Choice field. When creating or editing this field by selecting the drop-down the list of names were appearing in alphabetical order (yay). However, since adding a new item to the list [Column Settings -> Edit Column -> Under Choices enter a new Name] that latest entry appears first. Is there a way to force the sort into alphabetical A-Z? Provided a screenshot to illustrate. The field is called LCO_DataCard1.
Thanks in advance for any help - I wouldn't have been able to get this far without the community!
@Stokiedez
You would add this to the Items property of your dropdown. I assume you are using the Choices formula in that property to get the choices for the column in your list.
So, the formula should be this:
Sort(yourExistingItemsPropertyFormulaHere, Value)
I hope this is helpful for you.
Great that's worked! Thanks 😁
thanks for sharing. this works for me as well.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 393 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 278 Most Valuable Professional
