PowerAutomate - Insert row

Gabi

I am using the the Smartsheet Connector in Power Automate.

It all works fine, if I am using "insert row" with a fixed sheet name.

But if i want to use a dynamic sheet ID, am ask for row

Can anybody help me, what values in which format I have to put in this field. I could not find any documentation.

prime_nathaniel

@Gabi I do lots of power automate to SMAR but I normally do it over the HTTP call module not the built in. I also do tons of Bridge and custom integrations over the API. The standard format for the API is

https://api.smartsheet.com/2.0/sheets/{sheetID}/rows

There is no {row ID} parameter to insert a row as the ID is created when SMAR receives the data. You can see in the official SMAR documentation

https://developers.smartsheet.com/api/smartsheet/openapi/rows/rows-addtosheet

The only time row id's are required is when you do updates and deletes, because you need to tell it what row you want to change.

Anyways all that said, whenever you do have a row id needed, the type is "number" or "int" so you can do a parse on a string to convert it.

I might have time later today to try it with the built in action, just note the built in ones do not bulkify so you are always doing 1 call to 1 row, ie the are inefficient at large scale.