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?
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
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...
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"
The Mashup engine cannot handle the comma's you're using, I had the same problem. Try replacing those comma's for something else.
User | Count |
---|---|
255 | |
106 | |
85 | |
51 | |
43 |