Mysql Insert Row connector in logicapp and power automate is expecting value for auto increment fields. There is no workaround for this either

[srinims]

Describe the Bug with repro steps

1, Create table with ID as auto increment and primary key

2, Add insert row for mysql

3, since ID is primary key, it is non nullable field. logic app is expecting the value to be passed here though it is not required.

Please note this issue is not happening in power apps.

What type of Logic App Is this happening in?

Consumption (Portal)

Are you using new designer or old designer

New Designer

Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

Workflow JSON

No response

Screenshots or Videos

No response

Browser

chrome

Additional context

No response

[srinims]

power automate is not asking the value for the auto increment nullable field. However, it is causing failure during insertion.

### below is the create table script.

CREATE TABLE customer_updates (
ID int NOT NULL AUTO_INCREMENT,
customer_id varchar(50) NOT NULL,
message varchar(255) DEFAULT NULL,
last_updated datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (ID,buyer_id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

### below is the error message
{
"status": 400,
"message": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '43ab1d1c-14d6-4dec-8e6e-ea65d693a3c8'' AND ID = 9' at line 1\r\nclientRequestId: edae4a96-646a-47a1-ae81-6295c90d7754",
"error": {
"message": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '43ab1d1c-14d6-4dec-8e6e-ea65d693a3c8'' AND ID = 9' at line 1"
},
"source": "azuremysql-uks.azconn-uks-002.p.azurewebsites.net"
}

Below is the json code from logic app
"Insert_row": {
"inputs": {
"body": {
"buyer_id": "@{variables('buyerid')}",
"message": "Email address updated '@{body('Get_row')['email_address']}'"
},
"host": {
"connection": {
"name": "@parameters('$connections')['azuremysql']['connectionId']"
}
},
"method": "post",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('default'))},@{encodeURIComponent(encodeURIComponent('db1'))}/tables/@{encodeURIComponent(encodeURIComponent('[db1].[customer_updates]'))}/items"
}

[github-actions]

This issue is stale because it has been open for 45 days with no activity.