Smartsheet attachment files stored in OneDrive

Bram Batenburg

Hi!

I'm using Smartsheet to gather information through forms. People fill in a form, they add a picture in the submission, and all this gets saved in a sheet. Eventually, I receive rows filled with information in Smartsheet and for each row there is a picture attached.

I need these pictures not only within Smartsheet, but also in a shared OneDrive folder. My question is: how can I automatically export these pictures from the sheet in Smartsheet to a folder in OneDrive? Also: is it also possible to automatically rename the picture files to a name linked to the row information?

I tried working on it with Microsoft Power Automate, but I was struggling as I'm not an expert in this program. Also Zapier and Intregromat are new to me, so if these programs are the solution to my problem then please also explain how it exactly works.

Let me know if you have a solution!

Best regards,

Bram

Streamline Technology

Hi Bram,

You might be able to do something with Microsoft Power Automate to set this up, but there is not something natively within Smartsheet that I am aware of.

Streamline Technology

Hi Bram,

Have you tried using the sheet backup functionality? Setting a regular sheet backup will have a copy sent to your email, which you can then place on OneDrive.

Bram Batenburg

https://community.smartsheet.com/discussion/comment/291573#Comment_291573

This indeed gets me the attachments. However, it requires quite some manual step and the OneDrive folder will only be up to date when I proceed with the manual steps. I rather have it done automatically.

Streamline Technology

Hi Bram,

You might be able to do something with Microsoft Power Automate to set this up, but there is not something natively within Smartsheet that I am aware of.