Re-order a general list alphabetically

Joelarkins · 2025-02-13T09:49:38+00:00

There was an error rendering this rich post.

Hi,

I'm trying to re-order a general list into alphabetical order. Its a hierarchal list and I'm not sure what steps to take. The list is a dimension for many modules and performs as a drop down menu for UX pages. Any guidance on this would be appreciated!

Thank you

Joe

Accepted answers

andrewtye

Hi @Joelarkins - if you add a text line item into the hierarchy's system module and have as the formula name(item([list name])) or the use the display name field if it's a numbered list and then create a sort action using that list.

This used to be only actionable by workspace admins - not sure if end users can now run this update.

It's a handy action to run after you've updated any hierarchy

SriNitya

Hi
Using reorder action, you can achieve it.
If the list is numbered list use display name to sort alphabetically and if list is general list use List item Name to reorder. Upon running the action created the data gets ordered and wherever the list is used it will be displayed alphabetically
Hope it helps.

All comments

andrewtye

This used to be only actionable by workspace admins - not sure if end users can now run this update.

It's a handy action to run after you've updated any hierarchy

SriNitya

Joelarkins

Thanks both,

Using the reorder action is my preferred route but the 'select line item' is confusing me. I'm not sure what role this is playing? In my mind, all I would need to select is the list to order alphabetically and in what way. Heres a screenshot…

SriNitya

Select Line item → You need to select the line item with which you want to reorder the list.
If the list is numbered list use display name to sort alphabetically and if list is general list use List item Name to reorder

devrathahuja

Hi @Joelarkins ,
You need a line item for it to be able to sort the list in any order.

Sort it using the member's name.

Hope this helps! :)

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…