I’d like to import SharePoint Online files. These files are not sorted into folders but instead have columns created which allows end users to ‘tag’ information about the files. Hence the steps required would be
- Import list of ‘Documents’ in a SharePoint page
- Filter on a metadata Column
- Expand the content in the file.
The problem I am finding is that using SharePoint.Files or SharePoint.Contents will return a list of files but not any metadata.
Using OData.Feed (noting you have to put “/_vti_bin/listdata.svc” on the end of the SharePoint site path when doing this option) or SharePoint.Tables will return metadata but will not return the [Contents] column which will enable you to expand the file data.
Is there any training on how to do this… or I’d appreciate advice if not.
I’d like to avoid using a ‘merge’ if possible as it’s typically a slower transformation in Power Query and a more complex and seemingly unnecessary step to combine two of the above options.
I can’t share a file in this instance because they link to live SharePoint files. I have however screenshot an extract. I’ve highlighted in red squares the Filename and the Metadata columns that I had created. You’ll note there is no [Content] column that allows data to be extracted.