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:
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.
Solved! Go to Solution.
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:
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
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.
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.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.