Sharepoint integration via Microsoft Flow
Hello 
I used Microsoft Flow to create a workflow which adds a row into a sheet in smartsheet whenever a new item is created on a sharepoint however I cannot get around the situation with updating the sharepoint item. I want to have a "live" or "active" connection to smartsheet - meaning if the person who created the item change something in the item itself, this to be reflected in smartsheet.
My flow is:
When an item is created or modified -> Insert a new row in SmartSheet.
With this flow whenever I change something in the item a new row is being inserted into smartsheet with only the changed value whereas i want to have it updated within the original row.
Any ideas?
Comments
-
Hi Stilyan,
You have a few options here:
- Create automatic update request rules that email people asking for an update when specific changes are made to your sheet: https://help.smartsheet.com/articles/504779-using-update-requests
- Publish your sheet as editable to SharePoint. Changes will need to be made manually within the published iFrame of your sheet, but it will be a quicker path than going back into Smartsheet to edit: https://help.smartsheet.com/articles/522078-publishing-smartsheet-items
- If you have developer resources available, consider creating something using the Smartsheet API: https://smartsheet-platform.github.io/api-docs/
Otherwise, you might also ask your question on the Microsoft Flow forums: https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity
