How to get the list of folders that are empty in SharePoint?

SharePoint is a document management and collaboration platform. There may be times and Instances where you would need to check for folders that have no files in them. One approach is to manually open each folder in a document library. This approach might suffice if you have just a handful of folders. But what if you have more than 100 folders? Checking each one of them is definitely going to be time consuming.

SharePoint has something called as views which control and determine how you would like your files or folders to be represented in the Document Library. For Instance you could have a view which shows only files that were modified in the past 15 days. Or you could show files that were created yesterday. The filtering criteria gives one a lot of options to play around with.

As one knows a document has a certain set of properties associated with it. Like Creation Date, Modified Date, Author etc. There is one property that would help in getting us the list of folders that are empty. The property is called Item Child Count. Item Child count displays the number of files in a folder. In order to achieve our goal, we would have to create a view that displays only folders whose Item Child Count=0.

Follow these steps on creating a view and setting the value of Item Child Count.

  1. Go to your Document Library.
  2. Then goto your Library Settings. Screen Shot 2018-02-01 at 8.29.18 PM.png
  3. Scroll Down and Click on Create viewScreen Shot 2018-02-01 at 8.29.38 PM
  4. On the View Type, select Standard View.
  5. Scroll down to the Filter Section
  6. Under “Show the Items when column”, choose the value Item Child Count.
  7. Set the value equal to 0.
  8. Scroll Down and click OK.


This would create a view that displays folders which are empty.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s