Forum Discussion
Power Query/Sharepoint
You may use From SharePoint Folder connector
using for the connection root site URL and filtering after that on desired folder. But that will be new project, From Folder connector is not mapped on SharePoint folder. At least directly.
You may use From SharePoint Folder connector
using for the connection root site URL and filtering after that on desired folder. But that will be new project, From Folder connector is not mapped on SharePoint folder. At least directly.
- Thanks. Yeah, that's the next step I can't work out. As you say, sharepoint folder only links to root site. Can you point me to a How to guide on that next step? Is it a matter of settings in sharepoint, user permissions, or a specific bit of coding?
Connecting to root one of the columns will be Folder path - filter on on folder you work with.
After filtering, expand content. Rest is similar as with From Folder connector.
SergeiBaklan Thanks again for this, couldn't seem to use expand option for that column, but removing other columns and just keeping binary and folder path columns did the job.
