Share
ReportI'm using power automate with a custom smartsheet connector as the published connector is not available in our environment.
I have all these actions up and running without issue - ListWebhooks, CreateWebhook, GetWebhook, DeleteWebhook, UpdateWebhook, ResetWebhookSecret, GetSheet, GetRow, UpdateRow
My only problem is with AddRow when using it in a flow. If I go into the test custom connector and use AddRow, it works. However, when I use AddRow in a flow, it just keeps inserting blank row and reports back that it was successful. I've tried using both variables and actual values. The action raw inputs look fine (as far as I can tell) but the raw output never has any value for the columns.
Raw input from "successful" run with actual values looks identical to when I use variables for the values... I x'd out part of the sheet ID and reference name - wans't sure if that should be posted or not.
{
"host": {
"connectionReferenceName": "shared_smartsheet-20custom-20for-20events-xxxxxxxxxxxxxxxxx",
"operationId": "AddRow"
},
"parameters": {
"sheetId": 8653773xxxxxxxxx,
"body/rows": [
{
"cells": [
{
"columnId": 4876319461166980,
"value": "2611133",
"strict": false
},
{
"columnId": 1861800596033412,
"value": "MRSA Planning",
"strict": false
},
{
"columnId": 8251874294321028,
"value": "1022 Wichita cERP",
"strict": false
},
{
"columnId": 5437853430140804,
"value": "NW0001111111",
"strict": false
},
{
"columnId": 852387322089348,
"value": "1",
"strict": false
},
{
"columnId": 4311802050203524,
"value": "Teams",
"strict": false
}
],
"toTop": false,
"toBottom": true
}
]
}
}Raw output:
"statusCode": 200,
"headers": {
"Cache-Control": "no-store, must-revalidate, no-cache",
"Transfer-Encoding": "chunked",
"x-ratelimit-limit": "80000",
"x-ratelimit-remaining": "79600",
"x-ratelimit-reset": "1769197831",
"Vary": "Accept-Encoding",
"Pragma": "no-cache",
"x-envoy-upstream-service-time": "2907",
"x-smar-halo-version": "5469403",
"x-smar-halo-release": "l",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"x-ms-environment-id": "default-c382e4a5-eb78-4106-9133-a5dfxxxxxxxx",
"x-ms-tenant-id": "c382e4a5-eb78-4106-9133-a5dfxxxxxxxx",
"x-ms-dlp-re": "-|-",
"x-ms-dlp-gu": "-|-",
"x-ms-dlp-ef": "-|-/-|-|-",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Fri, 23 Jan 2026 19:49:34 GMT",
"Content-Type": "application/json; charset=UTF-8",
"Expires": "0",
"Content-Length": "1186"
},
"body": {
"message": "SUCCESS",
"resultCode": 0,
"version": 5110,
"result": {
"id": 64974538xxxxxxxx,
"sheetId": 86537734xxxxxxxxx,
"rowNumber": 11,
"siblingId": 8708900255895428,
"expanded": true,
"locked": false,
"lockedForUser": false,
"createdAt": "2026-01-23T19:49:32Z",
"modifiedAt": "2026-01-23T19:49:32Z",
"cells": [
{
"columnId": 5770250310864772
},
{
"columnId": 4677205851066244
},
{
"columnId": 4876319461166980
},
{
"columnId": 5633362031759236
},
{
"columnId": 4874174573793156
},
{
"columnId": 2622374760107908
},
{
"columnId": 2903849736818564
},
{
"columnId": 5530398524919684
},
{
"columnId": 6469814705672068
},
{
"columnId": 8614669988876164
},
{
"columnId": 1861800596033412
},
{
"columnId": 1777949829975940
},
{
"columnId": 2241024834097028
},
{
"columnId": 4029749643661188
},
{
"columnId": 8251874294321028
},
{
"columnId": 5437853430140804
},
{
"columnId": 6499545723391876
},
{
"columnId": 1482775908274052
},
{
"columnId": 8174537871675268
},
{
"columnId": 6563024434057092
},
{
"columnId": 852387322089348
},
{
"columnId": 4311802050203524
},
{
"columnId": 370574946422660
},
{
"columnId": 2091703394324356
},
{
"columnId": 6595303021694852
},
{
"columnId": 8847102835380100
},
{
"columnId": 262116045705092
},
{
"columnId": 4765715673075588
},
{
"columnId": 2513915859390340
},
{
"columnId": 1425206986624900
}
]
}
}
}Any ideas???
I have the same question (0)
All responses (
Answers (
377
