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.

Find more posts tagged with

Accepted answers

jmyzk_cloudsmart_jp

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!

https://youtu.be/mqMmdcXHWyg

(Note: Perse JSON action is not necessary.)

All comments

Georgie

Hi @notmichaeljfox,

Having reviewed the Microsoft Documentation on the Smartsheet connector (here), it looks like it’s not possible to update particular cells using Power Automate.

You can check out the Smartsheet Power Automate integration page here. If you’d like to know more about using the integration, please reach out to your Customer Success Manager or our Sales team.

Additionally, I’d recommend reaching out to the Microsoft Power Platform Community or Microsoft Support for assistance with how-to for Power Automate.

Hope that helps!

Georgie

jmyzk_cloudsmart_jp

Hi @notmichaeljfox

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!

https://youtu.be/mqMmdcXHWyg

(Note: Perse JSON action is not necessary.)

notmichaeljfox

Thank you @jmyzk_cloudsmart_jp! That is a huge help.

jmyzk_cloudsmart_jp

Happy to help!😁

Vivian.Pham

https://community.smartsheet.com/discussion/comment/473601#Comment_473601

Hi @jmyzk_cloudsmart_jp , this post is a bit old but is there any way you can elaborate on the HTTP action in more detail? I am having trouble with figuring out how filter the arrays to pull the row/cell I need to update...

MrHealthcareVcvr

This is a very helpful thread and video. Could I get clarity on one point.

In the HTTP request, for the "Authorization" key, what is the expected Value? Is it a username, username/password combination, or something else?

Thank you.

jmyzk_cloudsmart_jp

Hi @MrHealthcareVcvr

https://help.smartsheet.com/articles/2482389-generate-API-key

As shown in the help article above, you generate an API key from the Personal Settings page.

With the key, the holder can perform all actions that a person can do with Smartsheet, utilizing the Smartsheet API. So, be very careful handling it. Keep it safe. For example, never share the Access Token with anyone else, including someone from your organization.

The token looks like this;

JKlMNOpQ12RStUVwxYZAbcde3F5g6hijklM789

MrHealthcareVcvr

Thank you, jmyzk_cloudsmart_jp, much appreciated.

jmyzk_cloudsmart_jp

Happy to help!😁

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.