Forum Discussion

adamsharma's avatar
adamsharma
Frequent Visitor
6 years ago
Solved

Combine HTML Binaries from SharePoint

So I can combine several HTML files with the same schema from a local folder easily and extract a data element from each such as a table, but I simply cannot do the same with the same HTML files stor...
Need Help
  • adamsharma's avatar
    adamsharma
    6 years ago

    So I've actually ended up answering my own question, more through luck than judgement! I turned on the "New web table inference" Preview Feature. After doing that, the out-of-the-box combine binaries feature suddenly worked on my SharePoint HTML files!

artemus's avatar
artemus
Microsoft Employee
6 years ago

Just to make sure: Have you tried disabling privacy levels?

 

Other than that, it may depend on how your reading the file. E.g. Make sure you are using Web.Contents and not another function. It is possible that a Web.Page or Web.BrowserContents was automatically added after you connected to the sharepoint files.

adamsharma's avatar
adamsharma
Frequent Visitor
6 years ago

Thanks Artemus.

 

I've tried disabling privacy levels to no avail unfortunately. I've tried changing the query to Web.Contents and I just seem to get credentials errors despite definitely having the correct credentials in place to be able to access the SharePoint folder in question.

 

Has anyone actually managed to successfully do this? I can't find any evidence online that anyone has managed to combine anything other than Excel files from SharePoint so wondering if I'm barking up an impossible tree...