Thanx for sharing. It’s a really powerful tool which I use regularly. Good that you opened up the Attributes column - I never looked into it. Your column “full file path” is becoming magic in an Excel table if you add a column where you combine it with the excel hyperlink function. This way you can open any file without leaving excel. Cheers Seb
Yes, but you will need a bit of VBA magic to move them. I’ve got a guide here to deal with that: exceloffthegrid.com/vba-code-to-copy-move-delete-and-manage-files/
Hi, I tried this idea, but came across the issue of max file length. I need to have the pdf files only. Is it possible to filter out all other folders in the source so the query doesn't need to scan other lengthy folders?
hi, would anyone be able to explain how to get a folder structure without the files? I currently have a share I woudl like to get a folder structure for. Thanks in advance
@@ExcelOffTheGrid thank you for getting back to me. I tried this and it still shows the full content of the folder including files. I am trying to get just the folder levels. Another great help would be to limit the level of folder to list. Thank you in advance 👍🏻
Thanx for sharing. It’s a really powerful tool which I use regularly. Good that you opened up the Attributes column - I never looked into it.
Your column “full file path” is becoming magic in an Excel table if you add a column where you combine it with the excel hyperlink function. This way you can open any file without leaving excel.
Cheers Seb
I had not thought of that... Genius idea ⭐⭐⭐⭐⭐
wow man!!! great idea
Brilliant Mark- Folder.Content => Excellent
Yes, Folder.Contents is useful. It’s one of the functions which isn’t available in the user interface.
Thanks Mark! This channel is really good for PQ enthusiasts. This channel deserves more subscribers. Kudos 👍🏻👍🏻💪🏻💪🏻
I would love more subscribers… maybe one day. 😀
@@ExcelOffTheGrid of course. you will get more with your quality tutorials.
Excellent tutorial. Thanks for sharing!
Glad it was helpful!
Awesome tips Mark! I've been using this feature for some time and it is very useful. Thanks for the demo. Thumbs up!!
Thanks Wayne, I appreciate the encouragement. 😀
The best teacher!!!
Thank you, that is very nice of you to say.
Great info. Thanks very much!
You’re welcome.
Great content 😊 Subscribed
Great news, thanks Sunmanth.
Thank you for this. this is superb!
possible to move files around using excel? if given the path to the old and new paths???
Yes, but you will need a bit of VBA magic to move them. I’ve got a guide here to deal with that: exceloffthegrid.com/vba-code-to-copy-move-delete-and-manage-files/
@@ExcelOffTheGrid thank u for this
Wish there was a way in power query
Looking for ideas to do it using tables sith old and new paths
Excellent video, is it also possible to extract file attribute like owner, thanks
I don’t think that is one of the attributes available.
Hi, I tried this idea, but came across the issue of max file length. I need to have the pdf files only. Is it possible to filter out all other folders in the source so the query doesn't need to scan other lengthy folders?
hi, would anyone be able to explain how to get a folder structure without the files? I currently have a share I woudl like to get a folder structure for. Thanks in advance
In Power Query change the code in the source step from Folder.Files to Folder.Contents.
@@ExcelOffTheGrid thank you for getting back to me. I tried this and it still shows the full content of the folder including files. I am trying to get just the folder levels. Another great help would be to limit the level of folder to list.
Thank you in advance 👍🏻
1:06 how can we do this on macos excel ?