Saving files attached to Smartsheet rows out to Sharepoint folder

Ryan blake

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.

Kelly Moore

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

Samuel Mueller

@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)

JD Lobue

@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.

Samuel Mueller

@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.

Veneeth

Can you please share Screenshots

Samuel Mueller

What are you attempting to do @Veneeth ?

Batman Smartsheet

@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?