Update cell via Power Automate

Has anyone been able to update a particular cell using Power Automate? I'm working on a project where we are using Smartsheet to record the completion of certain tasks performed by Power Automate, to meet reporting requirements.

Partially completed rows already exist for each task, containing identifiers for each respective task.

Best Answer

  • jmyzk_cloudsmart_jp
    jmyzk_cloudsmart_jp Community Champion
    Answer ✓

    Hi @notmichaeljfox

    As Georgie mentioned, Power Automate does not have a built-in "Update Row" action for Smartsheet. However, updating a specific cell using the HTTP action method is possible. The attached short video demonstrates this with a demo of the Power Automate workflow.

    While updating Smartsheet via Power Automate is achievable, I find it more straightforward to use the Smartsheet API directly with a preferred programming language's SDK, such as the Smartsheet Python SDK. This provides more flexibility and efficiency for updating cells and rows.

    For those interested in using the HTTP method in Power Automate, Microsoft provides helpful documentation on HTTP actions here:
    🔗 Power Automate HTTP Actions

    Hope this helps!

    (Note: Perse JSON action is not necessary.)

Answers