Sharepoint integration via Microsoft Flow

Stilyan Mitrev

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?

Shaine Greenwood

Hi Stilyan,

You have a few options here:

1. 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
2. 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
3. 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