Excel Power query: search one folder deep

Question

I am doing a power query in excel and im just using it to list all files in a specific directory.

I have two problems:

1. I cannot choose a sharepoint for the query. I may only choose folders on my hard drive. Is it possible to use a network sharepoint?
2. When I choose the folder i want, the query digs deep in all subfolders and list all files. However, i want it to search max 1 subfolder deep. and not 300. Is it possible?

Thanks for anyone who can help me! much appreciated

PS: If there is a vba code which lists all files one subfolder deep, this would also be a great solution

Answer 1

filter the results of your list of there is a PATH column