Assessing .csv from MS Teams
Hello
I am trying to leverage MS Teams as a OneDrive sharepoint file location for DataUploader to use for scheduled uploads. DataUploader recognizes the file location and tries to grab the specified .csv file. The .csv is useable - I can manually attach the exact file to a sheet and DataUploader executes. This is the error message in the DataUploader log file. The id indicated is not the .csv file name that I see.
Any ideas for a resolution or work-around?
Best Answer
-
Hi @KDM
Although DataUploader is able to work with files store in your personal OneDrive, it won't be able to recognize MS Teams as a valid OneDrive location, which is likely why you're receiving the error. (These are listed on the DataUploader login page, here.)
At this time the file will need to either be attached in Smartsheet, in Google drive, or in your personal OneDrive. Please submit an Enhancement Request when you have a moment!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @KDM
Although DataUploader is able to work with files store in your personal OneDrive, it won't be able to recognize MS Teams as a valid OneDrive location, which is likely why you're receiving the error. (These are listed on the DataUploader login page, here.)
At this time the file will need to either be attached in Smartsheet, in Google drive, or in your personal OneDrive. Please submit an Enhancement Request when you have a moment!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks Genevieve.
I'll mark my question as answered, as I know that is the smartsheet response.
I did build a work-around using microsoft's Power Automate to copy the .csv attachment that was emailed into MS Teams, to my personal OneDrive. This at least allows the rest of the team access to the .csv raw data without me having to keep up with who is shared to my OneDrive. (As a side note, I had never used MS Power Automate and was only vaguely aware it was part of O365. Thankfully some talented person posted the answer here and I just needed minor tweaking to keep the file name constant)
Thanks for all your help here in the community.
-
Hi @KDM
I wouldn't have thought to use Power Automate, that's a great idea. Thanks for sharing this, and for providing a link to the other post!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives