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?
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:
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.
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 first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for the next call on June 15, 2022 at 8am PDT.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.