Forum Discussion

arolon2's avatar
arolon2
Frequent Visitor
5 years ago
Solved

Importing a folder from Sharepoint

Hello,   I am attempting to import a Sharepoint folder that contains .xlsx files. I am clicking on Get Data -> More -> Sharepoint Folder. When asked for the site URL I go to the sharepoint folder, ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    arolon2 ,

     

    Yes, I believe once you import the Home Folder using the Get Data process, you should be able to filter the [Folder Path] field to only show rows within your chosen folder.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
5 years ago

arolon2 

 

Sorry, probably didn't explain that very well.

So, if your MS account email address that you log into SharePoint/O365 with is

[email protected], this becomes my_name_some_company_co_uk

 

Pete

arolon2's avatar
arolon2
Frequent Visitor
5 years ago

Still recieved a 404 error. Also the sharepoint folder I am trying to import from is a shared folder, not personal. Unsure how that URL would help and not the URL I get when I click on the folders ellipses in Sharepoint.

 

Update: So I have been able to link the home folder in sharepoint. My issue is that I am trying to link to a subfolder in it. Am I able to do this?

  • BA_Pete's avatar
    BA_Pete
    Super User
    5 years ago

    arolon2 ,

     

    Yes, I believe once you import the Home Folder using the Get Data process, you should be able to filter the [Folder Path] field to only show rows within your chosen folder.

     

    Pete