Per-location view settings don't work at the folder level in Document Library

Copper Contributor

Hello, 

 

I'm trying to set up per-location view settings for nested folders in a Document Library. I used the following articles as a guide: 

 

How to create different Views for different folders

 

https://learn.microsoft.com/en-us/sharepoint/troubleshoot/lists-and-libraries/per-location-view-sett...

 

https://support.microsoft.com/en-us/office/configure-the-availability-of-views-for-a-location-in-the...

 

However, it's not working. The setup I'm looking for is:

 

Document Library

View 1 only:

→ Top Folder 1

→ Top Folder 2

→ Top Folder 3

                           View 2 only (within Folder 1):

                           ↳ Sub Folder 1a 

                           ↳ Sub Folder 1b

                           ↳ Sub Folder 1c                         

 

Here are links to screen captures from SharePoint.

Image 1 - Settings : Per-Location View Settings - For View 1: All Documents

Image 2 - Settings : Per-Location View Settings - For View 2: Year In Descending Order

 

What am I missing? 

 

Thanks,

Yasmeen

 

4 Replies

@YasmeenSK 

Hi Yasmeen!
Have you found a solution to this? I've been running into the same issue for a while now, and none of the guides I've found (incl. some of the ones you've mentioned) seem to help.

Best

@JHingst 

 

I got a response to this issue when I reposted it on the MS answer/question board, though I didn't find it helpful:

 

https://learn.microsoft.com/en-us/answers/questions/1102046/sharepoint-per-location-view-settings-do...

 

I found a workaround that solved for what I needed. Let me know if you're interested. 

 

 

@JHingst 

 

Sorry I missed seeing your follow-up messages.

 

My workaround addressed my goal of  - depending on if you're in the top folder or sub-folders -  ensuring the Document Library sorts in alphabetical ascending order (A to Z) and/or in chronological descending date order (3, 2, 1) with the latest dated folder appearing at the top, rather than sorting to the bottom. 

 

1. I found online a brief mention in an archived post that in order to sort dates so that the latest appears on top, to create a new column with Choice Type and then plug in the dates (number values): 

 

Screenshot 2023-04-24 122818.png

 

2. Then go to Edit View > First sort by the column: "Date" [choice number value column you just created] in descending order (C, B, A, or 3, 2, 1).

 

3. Then sort by the column: "Name" in ascending order (A, B, C, or 1, 2, 3):

 

Screenshot 2023-04-24 130852.png

 

Now the Document Library knows that sorting with the date is the first priority but if the date column is left empty, to then sort by name in ascending alphabetical order. 

 

Therefore when you go into the Document Library, the top folders sort in alphabetical order by name b/c the Date column is left empty at this top level: 

 

Screenshot 2023-04-24 131903.png

 

When you click into a sub-folder, since the date number values are plugged into the choice column, the Document Library knows to sort by the Date column first in descending order (3, 2, 1 - biggest number value first) than sort by name column if applicable:  

Screenshot 2023-04-24 132357.png

 

When I initially created the choice column, I plugged in year number values as shown in the first screen-capture b/c they were used for another top folder. But when I'm in a sub-folder I use the Edit in grid view to quickly plug in the year number values rather than wasting time or having too many choices appear in the drop down menu which is annoying for other users to navigate in the future:  

 

Screenshot 2023-04-24 133952.png

 

This is how I set up Document Libraries to sort by either a date number value or by name in alphabetical order, but if you have other data you want to sort by first, you can still use a choice column and figure out how it will read and sort the values. For example you can just plug in 1, 2, 3, 4, 5... and have the document library sort by that series. It worked for me b/c the date number values are listed back to front. Just keep in mind SharePoint document libraries only allow you to sort views by a maximum of two columns. 

 

Let me know if this was helpful and solved for your sorting issues. 

Yasmeen