Share via

how to list parent directory, all nested subdirectories and files

an mac 41 Reputation points
2020-12-18T07:28:21.737+00:00

Hello, I wan to list all files, subfolders (all nested subfolders including parent directory) and all files across all level of subfolders into power query for any folder of my choosing. But, when I am using power data query to add a folder, it doesn't show the directory levels or the parent directory, it only shows the files.

How can I change that and do as stated in the beginning of this post? Thank you

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,881 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,913 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,013 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,669 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ehren (MSFT) 1,781 Reputation points Microsoft Employee
    2021-01-16T00:45:40.053+00:00

    The table returned by Folder.Files contains a "Folder Path" column. Can you derive the information you're needing from this field?

    0 comments