Power Platform Community Forum Thread Details

Hello!

I'm looking for a solution to the lack of a "Update a Row" connector between MS Power Automate and Smartsheet.

My current flow is triggered via a checkbox from a SS sheet - "when a sheet is updated". Ideally, I would like the flow to mark the row as "Complete" once it processes. Currently, there is a condition built to only run if column A, "Process", has a check and column B, "Complete", does not.

The built-in automation in SS to update a cell, updates it immediately; thus "Complete" has a check before the trigger request hits the flow. Using the hourly trigger is not ideal as multiple rows can be checked throughout an hour.

Next, I've tried going the HTTP action/API route. I got the action to add a check mark to the "Complete" column, however, I cannot figure out how to pull the triggered row's API Row Id, to mark that specific row. As my current trigger does not pull the Row Id, the Compose action is not helpful.

"Adding a comment to a discussion" route is not ideal as the discussion section is used by the team members for communication.

Any other suggestions or solutions?