Saving files attached to Smartsheet rows out to Sharepoint folder
What is the easiest way to take files attached to each row in a Smartsheet and save those files out to a sharepoint folder?
I know you can download them all and then go to SP and attach them, but surely there exists an automated way to move the files without ever personally touching them.
Bonus if I can do it when a certain status of approval is reached for each row item perferably.
Answers
-
Hey @Ryan blake
Is it possible to email your sharepoint folder? One certainly can if it is a Teams sharepoint as Teams has an email address per channel. I do this frequently with teams. If not Teams, it is dependent on the sharepoint settings whether the sharepoint allows direct email. If allowed, you can set automation to email the sharepoint and include attachments.
Would this work for you?
Kelly
-
@Ryan blake You could probably achieve this with a combination of bridge and Power Automate. Bridge to trigger the workflow, get the attachment download url, and then in power automate you should be able to use the http module to download the attachment via that url, and store it in SharePoint somewhere.
You can't get the attachment contents within bridge, you would need an external system (like power automate)
-
@Samuel Mueller, we are looking to do this exact thing. We have smartsheet rows w/ attachments and we want to GET those and POST them to a SharePoint List. Can you assist? Thanks in advance.
-
@JD Lobue I can try to send some screenshots if you are attempting to use Power Automate. It may take me a day or two.
-
Can you please share Screenshots
-
What are you attempting to do @Veneeth ?
-
@Kelly Moore Hello!
You mentioned that you are currently doing this or have done this. Could you show me how to set this up? Are you saying that smartsheet can directly share the files or drop them into a MS Teams folder? I want to drop attachments that i upload into Smartsheet and those attachments drop into a specified folder in my MS Teams Files folder. Is that even possible?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives