Alphabetically ordered list

Options
soukainawaraki
soukainawaraki Member, ALL USERS, Partner, Certified Model Builder Posts: 5 New Contributor
in Extensibility

Hello all,

 

I have a list of employees without alphabetical order in my model.

 

On the dashboard, I can create a new employee in the list but I want the whole list to become ordered alphabetically when displaying for example. Would it be possible to help me ?

 

Regards,

Tagged:

Comments

  • soukainawaraki
    soukainawaraki Member, ALL USERS, Partner, Certified Model Builder Posts: 5 New Contributor

    Thank you for your answer. 

    Very good tip. I manage to apply it to a module and it works. But, is there a way to apply this order on the list itself ?

    So that the order will be applied in all modules that contain the Employee list?

     

    Thank you !

  • MaryM
    MaryM Member, ALL USERS, Community Member Posts: 1 New Contributor

    There is a new feature: Order List action

    https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Order-list.html?_ga=2.136222710.635220381.1601650289-1152843459.1599592837

     

    Steps that have worked for me:

    1. create a new module based on the list you want to sort

    2. Create a line item with a formula that creates the value you want to use for sort (Ex: Last Name, First Name combination)

    3. Create a SORT line item  - Text format  - NO FORMULA

    this line item will be the one referenced in the action

    4. Either manually copy the values from item in (2) above and paste into item in (3) or create an action to do this

    5. Create and run the action using values in (3) for the sort

     

    It appears you cannot use an item with a formula that references your list as the item to sort by. Therefore you need a non-formula based item to sort with.

     

    Hope this helps!

     

     

Categories