I want to get list of folder names and files in it from sharepoint list to excel and excel will be updated automatically. I am having access problem using Power Query so power query is out.
I found out a way is to get sharepoint folder link and somehow, excel able to get folder and file names from the folder link, but how?
Please share with me the method above or if you have any better way? Thanks in advance.