List Sharepoint Folder Contents?

[BarryFletcher]

Hi all,

I currently have an excel workbook which has a data source of a set of folders and it lists the files within the folders.

Currently - this source is a shortcut to a sharepoint folder on my local device which obviously isn;t ideal if others want to update the contents as it is mapped to c:\users\myusername.

When I try to set the online sharepoint folder I get errors?

[BarryFletcher]

Thanks for suggestion - had to change authentication method to connect to the companies sharepoint site and it worked

[Expiscornovus · Accepted solution]

Hi @BarryFletcher,

What type of url did you use Get Data wizard Site Url field and can you share a screenshot of that setup? And which authentication did you use?

Did you follow the below steps to set this up?

https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder