Folders and files list mixed together power data query

[anmac1789]

hello, I am using power data query to organize a list of files and folders and their subfolders by date and time created & date and time modified. The problem is that I have a lot of subfolders and I want to see if there is a query code to list ALL subfolders and ALL FILES in those subfolders INCLUDING the parent directory in a table and then filter out specific files/folders I want to see. Is this possible? Thanks

 

[GraH]

Can't you split the file Path per delimiter "/" or "\" ( I always forget). But that does not give you creation date I guess.

 

[anmac1789]

Can't you split the file Path per delimiter "/" or "\" ( I always forget). But that does not give you creation date I guess.

well what I wanted is to list everything inside a parent folder including the parent folder itself in power data query but instead of having to add each subfolder seperately and then combingin all the subfolders I want to see if there is a formula that can do that automatically.