Problem with Smartsheet Update Row

Help Studio
, ,
1

Hello,

I’m trying to use the Update Row activity to update a row in a Smartsheet.

image

The issue I’m having is the activity has no place for me to define what column to update, or what information to put into the cell or row that I want updated. It appears to have an OUT bound variable to hold a returned row, but why would I need that if I’m sending information TO Smartsheet?

The image shows a user interface for configuring an "Update Row" action in UiPath, with various settings for Smartsheet integration and properties options on the right side of the screen. (Captioned by AI)
The image shows a user interface for configuring an "Update Row" action in UiPath, with various settings for Smartsheet integration and properties options on the right side of the screen. (Captioned by AI)1186×420 30 KB

The image shows a software interface for updating a row in a Smartsheet, with fields for Sheet ID and Row ID, and a list of additional properties with their data types and in/out status. (Captioned by AI)
The image shows a software interface for updating a row in a Smartsheet, with fields for Sheet ID and Row ID, and a list of additional properties with their data types and in/out status. (Captioned by AI)810×710 71.4 KB

This seems a pretty significant oversight which renders the activity completely useless.

While we’re discussing it, why does Sheet ID accept a string but Row ID requires an integer? This makes little sense, they should be standardized.

2

@kevin.scott

Ideally whatever additional fields that you select and save should be added to the activity for you to give the input value..is that not happening?

Cheers

3

Hi @Anil_G , yes that does happen. Which field in the screenshot do you think is meant to hold the data that is to be passed back to the row?

It can’t be any of the booleans so they’re out. It can’t be the Row number, so that’s out. That leaves only Access Level, and I think we can agree that’s not it either.

4

@kevin.scott

Use the actual sheet ID and not the variable and then open manage properties and you would see the fields that are to be updated also would be loaded based on sheetid

Cheers