Share via

how to list parent directory, all nested subdirectories and files

an mac 51 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 for business Windows Client for IT Pros Directory services Active Directory
Windows for business Windows Client for IT Pros User experience Other
Microsoft Security Microsoft Graph
Community Center Not monitored

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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.