Modify list view - Group by Lookup column's ID RRS feed

  • Question

  • Hi

    I have a main list that has a lookup column. The grouping works fine, but I want the sort order of the group to appear as the way the lookup value's ID is ...

    What are the ways to achieve this, I do not want to put a number in front of the values, is there another way to do this
    Thursday, October 9, 2014 3:13 AM


  • I understand that you don't want to add additional info in front of the lookup column values to keep the value exactly as expected.

    as SharePoint 2010 allows to lookup additional fields, I would suggest to lookup the item ID also with the lookup column.

    1. create a lookup column lookup your expected list.

    2. in the lookup column settings, "Add a column to show each of these additional fields", check "ID" column.

    3. group by the list view with the additional ID instead.

    There is an issue by doing this step, the groupby title value is the lookup ID column not the original lookup column, as we actually doesn't use the lookup columnn with grouping.

    For this, you can use SharePoint Designer to edit the list view, change the groupby row cell to the lookup column value instead.

    Qiao Wei <br/> My blog:

    Thursday, October 9, 2014 6:25 AM