Sharepoint 2019 on prem - lookup sort order

%3CLINGO-SUB%20id%3D%22lingo-sub-1303887%22%20slang%3D%22en-US%22%3ESharepoint%202019%20on%20prem%20-%20lookup%20sort%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1303887%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20you%20sort%20a%20document%20library%20lookup%20in%202019%3F%20I%20just%20need%20it%20Desc%20instead%20Asc.%20I%20must%20be%20missing%20something.%3C%2FP%3E%3CP%3Ea%3C%2FP%3E%3CP%3Eb%3C%2FP%3E%3CP%3Ec%3C%2FP%3E%3CP%3E-------%3C%2FP%3E%3CP%3Ec%3C%2FP%3E%3CP%3Eb%3C%2FP%3E%3CP%3Ea%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20great.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1303887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1304270%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%202019%20on%20prem%20-%20lookup%20sort%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1304270%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EIf%20I%20understood%20your%20query%20correctly%2C%20you're%20looking%20to%20sort%20the%20lookup%20column%20in%20your%20document%20library.%20If%20you%20would%20like%20to%20modify%20the%20existing%20view%20only%2C%20you%20can%20select%20the%20header%20of%20your%20lookup%20column%20and%20select%20Descending%20and%20then%20you%20could%20save%20the%20current%20view%20for%20it%20to%20persist.%20If%20you%20would%20like%20create%20a%20new%20separate%20view%20with%20Desc%20sort%20configured%20of%20your%20lookup%20column%2C%20you%20can%20create%20a%20new%20view%20and%20configure%20the%20sort%20as%20per%20your%20need.%3CBR%20%2F%3EPlease%20refer%20to%20this%20link%20which%20will%20help%20you%20in%20locating%20the%20sorting%20configurations%20in%20views%20and%20you%20could%20select%20your%20lookup%20column%20as%20per%20your%20need%20-%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Farticle%2Fuse-sorting-to-modify-a-sharepoint-view-1e85d6e7-bdb3-4176-b1cb-62c5fbd3ef98%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Farticle%2Fuse-sorting-to-modify-a-sharepoint-view-1e85d6e7-bdb3-4176-b1cb-62c5fbd3ef98%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20helps.%3CBR%20%2F%3EThanks.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

How do you sort a document library lookup in 2019? I just need it Desc instead Asc. I must be missing something.

a

b

c

-------

c

b

a

 

 

Any help would be great.

1 Reply
Highlighted
Hi,
If I understood your query correctly, you're looking to sort the lookup column in your document library. If you would like to modify the existing view only, you can select the header of your lookup column and select Descending and then you could save the current view for it to persist. If you would like create a new separate view with Desc sort configured of your lookup column, you can create a new view and configure the sort as per your need.
Please refer to this link which will help you in locating the sorting configurations in views and you could select your lookup column as per your need - https://support.microsoft.com/en-us/article/use-sorting-to-modify-a-sharepoint-view-1e85d6e7-bdb3-41...

Hope this helps.
Thanks.