Power Platform Community Forum Thread Details

Hello,

I created a connection to my Azure Synapse SQL table that has a PK column in the table. In the Powerapps canvas, the default EditScreen1 showed up enabling me to edit or create new record to the SQL table. However, when I try to do that, using all default codes, I get the Badgateway error. This is the first time I'm trying to connect to Azure SQL so any help is appreciated on how to fix this problem. Thanks!

"body": {
"error": {
"code": 502,
"source": "europe-001.azure-apim.net",
"clientRequestId": "336045d5-7267-4878-abcc-d5cc0826635f",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "Parse error at line: 1, column: 60: Incorrect syntax near 'OUTPUT'.\r\nclientRequestId: 336045d5-7267-4878-abcc-d5cc0826635f",
"error": {
"message": "Parse error at line: 1, column: 60: Incorrect syntax near 'OUTPUT'."
},
"source": "sql-we.azconn-we.p.azurewebsites.net"
}