Get data excel issues

[vbacoder12]

I am having issues pulling data from teams folder using excel get data. I want to use excel get data from folder and basically pull all files that appear in the teams folder. Any suggestions on how to do this

 

[RoryA]

A Teams folder is Sharepoint, so you want this option (in 365):

and you will need the correct URL for the folder.

 

[vbacoder12]

A Teams folder is Sharepoint, so you want this option (in 365):

View attachment 119651

and you will need the correct URL for the folder.

I was trying to paste in the url and it was coming back as invalid

 

[RoryA]

Then it probably is. How did you get the URL? The best way is usually from the details pane in Sharepoint.

 

[vbacoder12]

Then it probably is. How did you get the URL? The best way is usually from the details pane in Sharepoint.

I've tried going into details and tried opening sharepoint and getting through there. When I do that I am getting a 404 error. Can you take a screen shot of what you referring to as the details pane

 

[RoryA]

They keep changing the functionality which is quite annoying - the copy path button doesn't seem to work for me anymore, so I suggest you open the folder in Sharepoint and click the Copy link button on the menu. That will give you a link in the form of:

https://companyname.sharepoint.com/:f:/r/teams/team_name_and_code_number/Shared%20Documents

The blue bits will be different for each company and team. From that, all you want is everything up to and including the team name and number, but remove the /:f:/r part, so it will look like this:

https://companyname.sharepoint.com/teams/team_name_and_code_number

and that is what goes into the

SharePoint.Files("URL here")

function. That will bring back everything in the site, so you'll need to filter appropriately from there.