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.
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.
- Ok, got it up and running. Thank you. This solves one of the issues, but gets away from one of the main positives my original method had.
Using the regular folder method means the query works regardless of the file name. So as long as the report/columns match, and there's only one file in folder, the report will work as intended. (And if it's wrong, the errors are obvious, and you just put the right report in the folder and refresh.)
This method relies on the file name remaining identical. Not a deal breaker, but mildly annoying.
(Trying to find a solution for a lot of users with different capabilities to follow.)Perhaps I misunderstood something, but you don't need filenames here as well. After you filter on SharePoint folder you may keep only Content column
After expand it you have same windows for combining files having first file as a sample