Hello All,
I am using UiPath Studio Web to do some work with Smartsheet. The problem I am encountering is I can’t seem to change the Row/Column data in the sheet. I am trying to take a DataTable exported from Document Understanding and populate a Smartsheet with that. The struggle is actually Changing the data in the row or column.
Use Get Rows to retrieve the Row IDs. Then use Update Row with correct Column IDs to modify the data in Smartsheet.
Welcome to the community
are you getting some error or are you finding trouble to find the right activity to use?
can you show some screenshot
cheers
I’m struggling to find the right activities to use. This comes from being locked to UiPath Studio Web so I have to use the connectors built-in there. I don’t have a Get Rows activity, only things like Get Sheet, Add Row, Update Row, etc.
List All Records allows me to get things like the Columns from the sheet, but I don’t see a way to update them with new data.
From list you would all then loop and use update row inside itwith row identifier
Check the properties once
Cheers
These are the only properties I can access in the Update Column activity. There doesn’t seem to be anywhere to actually change the cell data in the columns. Same thing for Update Row.
Could you please showcase your current workflow?
You mentioned that you start with a data table and then want to use it for Smartsheet activities after some manipulation.
It would help to know the use case you’re trying to solve to speed up resolution. 
