How To Find Total Number of Documents In one SharePoint Online folder

Question

How To Find Total Number of Documents In one SharePoint Online folder

seb seb 36

Hello,

I'm looking for a way to get the total number of files in a single directory of a sharepoint library (with more than 5000 items).

can you help me ?

thanks

seb

Accepted answer

4 additional answers

Your answer

Answer 1

Paul de Jong 806

@seb seb
An alternative is to use tools that can handle LVT. For example, Explorer. It will make successive requests and show the results in a Windows Explorer like way in your browser. (Use the trial version)

Answer 2

Echo Du_MSFT 17,316

Hi @seb seb ,

Welcome to Q&A Forum!

Please run the below PowerShell script as an admin to get counts of files:

#Config Variables  
$SiteURL = "https://domain.sharepoint.com/sites/sitename"  
$ListName ="libraryname"  
#Any file under the given path  
$FolderServerRelativePath = "/sites/sitename/libraryname/foldername*" #Any file under the given path  
     
#Connect to PnP Online  
Connect-PnPOnline -Url $SiteURL -Credentials (Get-Credential)  
    
#Get all files from folder  
$Files = Get-PnPListItem -List $ListName | Where {$_.FieldValues.FileRef -like $FolderServerRelativePath -and $_.FileSystemObjectType -eq "File" }   
  
Write-Host "File Counts:" $Files.Count

Thanks,
Echo Du

====================================

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Echo Du_MSFT 17,316 Reputation points

2022-03-28T09:10:29.34+00:00
Hi @seb seb ,

Thanks for your reply.

You can use the -PageSize parameter.

PageSize: The number of items to retrieve per page request.

Please use the following command：

#Get all files from folder #You can customize the value according to your specific needs $Files = Get-PnPListItem -List $ListName -PageSize 6000 | Where {$_.FieldValues.FileRef -like $FolderSe

Reference: Get-PnPListItem

Thanks,
Echo Du
seb seb 36 Reputation points

2022-03-28T13:12:03.12+00:00

Hi,

OK, thanks.
but the problem is that with this script it searches the entire library. and since it contains more than 500,000 files it will take a lot of time. I want a script that counts the total number of files directly from the desired directory.

thanks,
seb
Echo Du_MSFT 17,316 Reputation points

2022-04-01T09:53:48.113+00:00

Hi @seb seb ,

This is normal phenomenon. Because the PowerShell command needs to traverse all documents or items under the specified location to return the relevant value. It takes a lot of time if the folder contains a lot of files.

You can get the number of files and sub-folders at each level by adding “Folder Child Count” and “Item Child Count” fields to the view.

The caveat here is that Item Child Count only tells you what is stored within the top-level folder — it doesn’t count the items within the sub-folders.

Please follow the steps:

1.Go to the Document library as a site admin

2.Click Add column + >> Show/hide columns

3.On the Edit view column panel, select "Item Child Count" and "Folder Child Count" fields

4.Click Apply

Thanks,
Echo Du
Emily Du-MSFT 51,846 Reputation points Microsoft External Staff

2022-04-04T09:00:48.647+00:00

@seb seb

If Echo's reply helps you, please remember to accept her reply as answer via the "Accept Answer" button, it will be beneficial to others in this forum who meet the same issue in the future. Thanks for your understanding and cooperation.

Answer 3

seb seb 36

Thanks but i have this message :

"Get-PnPListItem: The attempted operation is prohibited because it exceeds the threshold
list display."

thanks,
seb

Terrence Chan 0 Reputation points

2023-08-16T01:29:03.2033333+00:00

Can try this

$Files = Get-PnPListItem -List $ListName -PageSize 500 | Where {$.FieldValues.FileRef -like $FolderServerRelativePath -and $.FileSystemObjectType -eq "File" }
Berger, Matthias 10 Reputation points

2023-09-27T13:50:24.4366667+00:00

Isn't it possible to do the same thing with the MS Graph API / PowerShell Module? Then at leasst we know that it will still be working in a few years - unless Microsoft in it's wisdom decides to abandon that in favor of the next hot thing as well.
John Laub 0 Reputation points

2024-08-06T15:08:43.31+00:00

Edit this line:

$Files = Get-PnPListItem -List $ListName | Where {$.FieldValues.FileRef -like $FolderServerRelativePath -and $.FileSystemObjectType -eq "File" }

as shown here:

$Files = Get-PnPListItem -List $ListName -PageSize 500 | Where {$.FieldValues.FileRef -like $FolderServerRelativePath -and $.FileSystemObjectType -eq "File" }

Answer 4

Tarana Aghabayova 1

This is a quick note to let you know that we are performing research on this issue.

Answer 5

Mark Singh 1

Sync / add a shortcut to File Explorer. Then use file explore to right click, and see the count of all folders and files in the hierarchy. Kind of a pretty big oversight that you can't do this in SharePoint. You can only go to doc settings and see a full file count, but not a folder count.

Berger, Matthias 10 Reputation points

2023-08-14T11:42:55.8633333+00:00

But then you see only what is synced, not what is actually "up there". If the purpose of finding out the numbers is to verify if sync or upload worked successfully in the first place, that's kind of useless.

Share via

How To Find Total Number of Documents In one SharePoint Online folder

4 additional answers

Your answer