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 ActionsHope this helps!
(Note: Perse JSON action is not necessary.)
Add Ons and Integrations
Add Ons and Integrations
Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.
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
-
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 ActionsHope this helps!
(Note: Perse JSON action is not necessary.)
Answers
-
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
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao! π | Global Discussions
-
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 ActionsHope this helps!
(Note: Perse JSON action is not necessary.)
-
Thank you @jmyzk_cloudsmart_jp! That is a huge help.
-
Happy to help!π
-
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...
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
