Forum Discussion

mkquestions's avatar
mkquestions
Copper Contributor
Jan 24, 2024

Creating a live folder directory from a Sharepoint site using Power Query

I need to create a directory showing all folders and files in a sharepoint site. I want to show all relationships using indentations (top level folder would have no indentation, folders within that would have 1 indent, subfolders within that would have 2 indents, etc.) as in the image below.

 

 

I'm able to link the top level folder everything else is housed in, but I only see the files housed within and not the folders themselves. Any way to do this in Power Query?

No RepliesBe the first to reply

Resources