Power Platform Community Forum Thread Details

I've tried so many different things and keep getting the same errors.

I've tried having the value true, 1 setting a different Boolean value as is shown here.

Nothing is working and I keep getting stonewalled.

It's the same thing with the columns that are from the "Contact List" I can't seem to get anything to work.

At one time I was trying to get the columns for their values and parsing them with some dynamic code, didn't work either. Tried AI, looking in the forums here and got nothing helpful. AI kept looping between 3 solutions that didn't work and forums never directly answered this difficult issue.

I have verified that my connection is working because without those fields (Contact List or Checkbox) the row is created and works well.

For testing purposes this is a manual trigger but later I will have it be email automated.

Raw input

{
    "host": {
        "connectionReferenceName": "shared_smartsheet",
        "operationId": "InsertRow"
    },
    "parameters": {
        "sheetId": "8596759883605892",
        "row/Title": "Test",
        "row/Description": "yes I'm Testing",
        "row/MFG ENG Ticket": true
    }
}



Raw Output
{
    "statusCode": 400,
    "headers": {
        "Transfer-Encoding": "chunked",
        "x-ratelimit-limit": "80000",
        "x-ratelimit-remaining": "79600",
        "x-ratelimit-reset": "1766095720",
        "Vary": "Accept-Encoding",
        "x-envoy-upstream-service-time": "37",
        "x-smar-halo-version": "5172154",
        "x-smar-halo-release": "l",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "x-ms-client-region": "unitedstates",
        "x-ms-flavor": "Production",
        "X-Ms-Workflow-Resourcegroup-Name": "selfhostingresourcegroup",
        "x-ms-workflow-subscription-id": "Default-cf254482-97e3-424b-b10f-33096772b8a4",
        "x-ms-environment-id": "default-cf254482-97e3-424b-b10f-33096772b8a4",
        "x-ms-tenant-id": "cf254482-97e3-424b-b10f-33096772b8a4",
        "x-ms-subscription-id": "Default-cf254482-97e3-424b-b10f-33096772b8a4",
        "x-ms-dlp-re": "-|-",
        "x-ms-dlp-gu": "-|-",
        "x-ms-dlp-ef": "-|-/-|-|-",
        "x-ms-mip-sl": "-|-|-|-",
        "x-ms-au-creator-id": "89353990-0a54-403b-8a19-8f1b589f6235",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Thu, 18 Dec 2025 22:07:39 GMT",
        "Content-Type": "application/json",
        "Content-Length": "203"
    },
    "body": {
        "refId": "0cb1123b-3e28-4027-a740-8b6787cb6862",
        "errorCode": 5536,
        "message": "The value for cell in column 3450389597736836, did not conform to the strict requirements for type CHECKBOX."
    }
}