cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Misa
Kudo Commander
Kudo Commander

Grabbing attachments from Smartsheet

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

8 REPLIES 8
ChristianAbata
Super User II
Super User II

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

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.

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

addatcg.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Misa
Kudo Commander
Kudo Commander

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 

 

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

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,760)