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"
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!