Sharepoint Folders and Items in Folders

[SteveKWWHA]

Hi All

As an audit requirment tasked to me, i need to generate a list of all the folders within a document library, the sub folders and whether they have any items (or count of how many items exist in that folder)

I can connect to the site > access the folders but it is only giving me a list of the folders where a file exists. Ideally, what i want to produce is a report showing: 

Folder name

Sub Folder Name

Items in Sub Folder

Not sure if this is possible but if someone does know ny help would be greatly appreciated

Thanks

[v-shex-msft · Accepted solution]

Hi @SteveKWWHA,

According to your description, I think folder connector should suitable for your requirements(get detail information of a specific path and its child)but it only works on 'absolute path' and does not compatible with dynamic web URL.

For this scenario, I'd like to suggest you to use external tools(e.g. PowerShell or programming language) to export detail SharePoint folder contents and save to local file, then you can use power bi to get data from that file.

In addition, you can also try to use power query to invoke python code with iterator function to looping detail contents of a directory.

Regards,

Xiaoxin Sheng

[tkirilov]

Hi @SteveKWWHA ,

I don't think Power BI alone can do that, but I am aware that there is a way of achieving that using PowerShell. I found this article (link below), which seems to describe how to achieve what you are looking for, but I must admit I don't know much about PowerShell.

https://www.sharepointdiary.com/2018/08/sharepoint-online-powershell-to-get-all-files-in-document-li...

Best,

Tom