Forum Discussion

Copper Contributor

Jul 19, 2019

Programatically accessing files shared in teams

My group has filed stored in teams channels. They're basically using excel files for data entry. I'd like to access them automatically/programatically for data analysis. Ideally in Python, but I'm o...

Iron Contributor

Jul 21, 2019

Hi cklapperichmn,

I hope I get your needs right. From my point of view, you just need to build a flow that copies the files from the SharePoint Online folder to another place where you can grab them? Maybe you should have a look at this option...

Sven

hanumntha03

Copper Contributor

May 13, 2020

svenseidenberg

I am not able see the option which you mentioned. My requirement is also similar. I have to access all the files present in a folder (in MS Teams) and get those into PowerBI and later use them for file manipulation.

Diagram:

MS TEAMS (folder, containing files)----------------accessed by----------------------> PowerBI (containing python script).

I need to access all these files using python, and the python script is in powerBI

Thanks and regards.

christopherklapperich
Copper Contributor
May 13, 2020
hanumntha03I got this working. I used the "open in sharepoint" option in teams, then used the "sync" option to sync the folder to a local folder on the hard drive. Then python could read from the local folder and the data stayed up to date. Worked well. Must have the one-drive app running on your PC.
- hanumntha03
  Copper Contributor
  May 13, 2020
  christopherklapperich
  
  so can't we directly access files without "using them in sharepoint". I have seen that there is an option given for a folder where we can use the "copy link" option can we use this to get all files in the folder?