Can Power Apps use the Smartsheet connector to update cell values in a Smartsheet?
I wrote a Power App that accesses the data in Smartsheet cells. A Smartsheet contains a table full of Rows. And each record in that table includes some data and then a table with the custom columns/cells. So you can't just connect to a Smartsheet. Instead, I loop through the Smartsheet and build a local collection that feels more like a table. It works great, and I'm happy to share the code.
What I would like to do now is be able to update the value in a Smartsheet cell from my Power App. I've been unsuccessful so far, but before I really bang my head against the wall to figure it out I wanted to confirm that the Power Apps Connector for Smartsheet supports record updates. In particular, the Sheet contains a table of Rows. The Rows contain a table of Cells. The cell table is a list of [ColumnId, value, displayValue]. I want to be able to update a record in the cell table to modify the value in that cell in the Smartsheet.
Is this supported?