Unanswered

Update row in Smartsheet when Sharepoint List row is updated

(0) Share

Report

Posted on by Anthony-GenH2

I have an MS Form that, when submitted, writes a row to a Sharepoint list and inserts a row into a Smartsheet for internal requirements. The RowID from the Smartsheet insert is also parsed out of the JSON output and stored on the Sharepoint list row as a reference.

When the Sharepoint list is updated, the updated values need to be synced with Smartsheet. For example, if the status changes from Reviewed to Approved, then the mapped column on Smartsheet would need to update. However, I only see a connector to add a discussion to a row and not an UpdateRow for Smartsheet. Is there a connector to update a row in Smartsheet with the Smartsheet ID and Row ID provided as part of the input? If not, is this on the roadmap?

All responses (3)

Answers (0)

ML-30072145-0 2 on at

Like (0)

Report

Update row in Smartsheet when Sharepoint List row is updated

It's really a pity that they have not developed this feature to update the records, which seems to be quite basic. The ability to update rows directly in Smartsheet using Power Automate would significantly streamline workflows and improve efficiency for many users. It's quite surprising that such a fundamental feature is missing.

Currently, the absence of a connector to update a row in Smartsheet means I need to update a lot of records manually,
Anthony-GenH2 2 on at

Like (0)

Report

Re: Update row in Smartsheet when Sharepoint List row is updated

Thanks. I think the http calls require a premium subscription though, which I don't have.
SergeantPup1 on at

Like (0)

Report

Re: Update row in Smartsheet when Sharepoint List row is updated

There is not a native way to do this. You must use http calls in power automate to update rows or sheet summary through a convoluted process.