Power Automate to save a Smartsheet attachment to SharePoint

Options
Melissa Torrez
Melissa Torrez ✭✭✭✭✭
edited 06/26/23 in API & Developers

Can you use Power Automate to save an attachment from a Smartsheet row to SharePoint? Alternatively, I need a way to link directly to the attachments in a sheet. Is either possible?

Answers

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    Options

    Hello @Melissa Torrez Data Shuttle does exactly what you want.

  • Melissa Torrez
    Melissa Torrez ✭✭✭✭✭
    Options

    Hi @Eric Law I am trying to save an attachment from Smartsheet to SharePoint. I can see where you can do the opposite via data shuttle and attach something to a Smartsheet row from SharePoint, but again I am trying to do the reverse. The attachment is already in Smartsheet and I need a way to save it to SP or save a URL to that specific row perhaps in a SharePoint list.

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    Options

    @Melissa Torrez You need to create an offload shuttle in Data Shuttle. From there you can upload a file to your Sharepoint.



  • Melissa Torrez
    Melissa Torrez ✭✭✭✭✭
    Options

    @Eric Law yes I can upload the whole sheet to SharePoint via data shuttle but there are files attached to every row of the Smartsheet. The row attachments are what I am trying to get from SS to SP.

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    Options

    @Melissa Torrez Sorry for the misinterpretation, I don't know about THAT specific function. From everything I've read it isn't a easy thing to automate getting attachments. Even if you backup the attachments, there are no reference to the row that it is attached to, so each attachment would need to be manually renamed.

    You CAN get a URL to point to the attachment... BUT, the URL only lasts for 30 days, unless you go back into the file (prior to expiration) and request a URL to the file again. If you request the URL after the expiration, you get a new link. This process is very cumbersome and non-sustainable

  • vdemattei
    vdemattei ✭✭✭✭
    Options

    I would also like to be able to do this as a means of archiving our "projects". Each row represents an individual project with various attachments. Once a project is completed, I'd love for an archive to be saved with a folder with the primary column name and all the attachments that were attached to that row saved into that folder.

    I'd love to see an enhancement request for this.

  • JD Lobue
    Options

    Is there not a solution w/in the smartsheet application and suite of applications that allows for extraction of the attachments within a smartsheet row and load it into SharePoint? How do we get this functionality added? Seems like it would be valuable for many.