Skip to main content

Notifications

Power Automate - Building Flows
Answered

Grabbing attachments from Smartsheet

Posted on by 246

Hello.

 

I was able to build a flow that when a row is added to Smartsheet, it creates an item in Sharepoint.  To accomplish this i had to create an expression that looked at the Smartsheet columns using a workaround that i found: 

first(triggerBody()?['cells'])?['value'].
 

I am having trouble figuring out how to copy the attachments that are in Smartsheet and add them to the SP list/library.  

 

Does anyone know if this is possible?

 

Thank you for your time.

  • Rglavan370 Profile Picture
    Rglavan370 7 on at
    Re: Grabbing attachments from Smartsheet

    Has anyone been able to find a solution to this yet? I am not able to get attachments automatically emailed to me!

  • Rglavan370 Profile Picture
    Rglavan370 7 on at
    Re: Grabbing attachments from Smartsheet

    Did you ever get this figured out? I am having the same issue now, its frutsrating. 

  • Misa Profile Picture
    Misa 246 on at
    Re: Grabbing attachments from Smartsheet

    @ChristianAbata @abm 

     

    Thank you both for taking the time.  I also wanted to let you know that the link to submit an idea gives me the error message saying that i don't have permission.

     

    Have a wonderful week.

  • Verified answer
    ChristianAbata Profile Picture
    ChristianAbata 8,976 on at
    Re: Grabbing attachments from Smartsheet

    sure @Misa  but as I told you there are no way to get the SmartSheet attachments. 

  • Misa Profile Picture
    Misa 246 on at
    Re: Grabbing attachments from Smartsheet

    @ChristianAbata 

     

    With the Add Attachment, you would still need to be able to reference the Smartsheet values and as you may know, they are very user friendly.  I am trying to be able to manipulate the Smartsheet connector options like the work around that i showed above.

    ss3.PNG

  • Misa Profile Picture
    Misa 246 on at
    Re: Grabbing attachments from Smartsheet

    Hi @abm ,

     

    I am not trying to insert a row into Smartsheet.  When a row is added to the Smartsheet, the flow creates an item in the SP list.  The flow is currenly working.  What i am trying to do is save the attachment that is in Smartsheet (same row) and add it to the SP list or a linked Library.

  • ChristianAbata Profile Picture
    ChristianAbata 8,976 on at
    Re: Grabbing attachments from Smartsheet

    ohh @Misa  if I'm corrent what you need is add atachment to a item, so you need this.

    addatcg.PNG

  • Misa Profile Picture
    Misa 246 on at
    Re: Grabbing attachments from Smartsheet

    Hi @ChristianAbata,

     

    I was able to find a work around in this forum.   But i cant find the original post (my apologies).

     

    In the field, i am adding to the expression.   

    first(triggerBody()?['cells'])?['value']  <-- 1st column in Smartsheet

    first(skip(triggerBody()?['cells'],1))?['value']  <-- 2nd column in Smartsheet and so on.
     
    SS.PNG
     
    From what i can tell, the attachments column is not being recognized as a column but i honestly dont know how Smartsheet see the attachments column.
  • abm abm Profile Picture
    abm abm 32,250 on at
    Re: Grabbing attachments from Smartsheet

    Hi @Misa 

     

    Inserting a row to smartsheet with an attachment is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

     

    https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

     

  • ChristianAbata Profile Picture
    ChristianAbata 8,976 on at
    Re: Grabbing attachments from Smartsheet

    @Misa  please could you share an screnshot of what you are doing, becaouse in my experience you can't get the attachments from Smartsheet.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard