Forum Discussion
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-sort them NOT in the order I want them in!
I'm trying to create a list of approvers in a certain order...but it is re-sorting my approvers in the WRONG order.
Example (the order I want is Baby, Volpe, then Allen)...but I can't get it to stay in that order after I add these users!
What is happening???
Thanks,
Mark
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
5 Replies
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.
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!
- 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...
- Jason_gagne
Thanks for the tip!
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
