Forum Discussion

smithmrk's avatar
smithmrk
Copper Contributor
Feb 14, 2023
Solved

SharePoint People/Group Column sorting when adding People

Hello all.   When adding people to a "People/Group" column, I want the order to be in the same order as I add the people...however after adding them in the order I added them...it appears to re-sor...
SharePoint Online
  • SvenSieverding's avatar
    SvenSieverding
    Feb 14, 2023

    Hi smithmrk,

    i think the users are displayed in the order of their entries in the "User Information List" of your site collection (see https://mytenant.sharepoint.com/sites/mysite/_catalogs/users/simple.aspx).
    (Person fields are just references to that list and for multi person field SharePoint seems to resolve the information from that list in that order)

    I would create three separate one-person fields:

    • First Approver
    • Second Approver
    • Third Approver

     

    Best Regards,
    Sven


      

Jason_gagne's avatar
Jason_gagne
Copper Contributor
Mar 07, 2023

smithmrk Experienced the exact same issue recently. Had to revert to the classic experience for my ordering of people in the People field to be respected.

  • Gabriela_D's avatar
    Gabriela_D
    Copper Contributor
    Apr 19, 2023

    Jason_gagne 

    Could you kindly provide more details?

    I also have an "Approvers"column and cannot seem to find a way to sort them in the order they are added. The sorting is done by their ID.

    I cannot change the column type as I am using it for an approval flow.

    Thank you in advance for your response!

    • smithmrk's avatar
      smithmrk
      Copper Contributor
      Apr 19, 2023
      So what I ended up doing was not using the Approvers Column at all. I created another column called Approvers E-Mail...and in that column I just put in the E-Mail Address of all my approvers separated by semi-columns. For example: email address removed for privacy reasons;email address removed for privacy reasons;email address removed for privacy reasons and then I would pull this column and do a "Split" function on that column into an array so 0 = the first e-mail, 1 = the second e-mail, etc...

Resources