Error when updating with EditForm and SubmitForm

[Venxir]

Hello,

When using a simple EditForm in Powerapps I have the issue if a primary key (nvarchar) contains a comma, the whole query dies because it thinks i'm supplying more then one parameter. this happens when I use the SubmitForm function on an Edit Form. When the primary key does not contain a comman, the query works.

My primary key looks like "O/xx-xxxx,xx", a workaround is using underscore instead of comma.

The data is written through a gateway to my on-premise SQL Server.

Anyone else having this problem?

[v-yamao-msft]

Hi Venxir,

Do you get any error messages?

I have seen a similar issue about Error while saving decimals value from another thread, the thread link is:
https://powerusers.microsoft.com/t5/PowerApps-Forum/Error-while-saving-decimals-value/m-p/23946/high...

I have reported this issue on my side, but I haven’t got any updates on it. I will keep an eye on this issue.

Best regards,
Mabel Mao

[Venxir]

Hello Mabel,

Something like "Mashup exception, inner exception: One key specified but two values supllied". The error was in dutch and I couldn't find the correct English translation... 

[KurtSchron]

I am also having this problem. My primary key is "#####, ####, ####" and the error I am receiving when I try to submit the edit form is, 

"The Requested Operation is Invalid. Server Response: [dbo].[TABLE_NAME] failed: 1 Keys were specified, but 3 values were provided. Inner Exception: 1 Keys were Specified, but 3 values were provided. clientRequestID: c408c390-f4c6-4062-8120-9b37f6f34a76"

[Venxir]

The Mashup engine cannot handle the comma's you're using, I had the same problem. Try replacing those comma's for something else.