How to ignore a secure folder

[hatstand]

Hi All,

I using Power Query to pull in the details of a folder and all sub folders. It works perfectly, but when it comes across a folder that I do not have access too. It stops reading the folders. I have tried using the Read Only attribute to ignore ReadOnly folfers etc. But this does not work.

Has anyone come across this problem before and how to solve it. If it was VBA I could simply 'jump' over the folder/file. With Power Query I can't seem to find how to do this.

Any pointers would be much appreciated.

 

[sandy666]

I don't know your M but you can try:
eg. try [something] otherwise null

 

[hatstand]

Sorry I haven't got back earlier, I've been away for my pc. I think the way your looking at it will be on the right track

 

[sandy666]

I hope so, this is something like IFERROR()