Answered

Insert and show decimal number SQL Server

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good afternoon,

I'm having some troubles while trying to use Patch to insert a decimal number into my SQL Database.

The data type of the field is "Numeric(18,2)", and I'd like to insert values like 0,05 or 0,50. Whenever I insert this values using Patch, I get the "Unknown Mashup Exception" error.

On the other side, if the input field is set to Text, it works because I use dot instead of comma (like 0.05), but the database saves only the number and forget the 0's. So for instance, 0.05 becomes a 5.

Is there any way to cast the format number so the database would save it instead of showing me this error?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

I just tested patching Numeric (18,2) field in SQL Server wihtin PowerApps, it works from my side.

Also tested with 0.05 and 0.50, all works.

Thing you may give it a try:

1. Take use of the value function:

For example:

Patch('[dbo].[Numeric]',Defaults('[dbo].[Numeric]'),{Id:3,Number:Value(TextInput1.Text)})

If you would like to use the TextInput as the value input, then when use it under the patch for the Number field, add a value function.

Regards,

Michael

Was this reply helpful? Yes No
aow 19 on at

Like (1)

Report
Copy link

Link copied!

We have a field type decimal (18,1) in on-premises SQL and we have not luck using the patch function to update this column.
Text fields work fine though. Any solution?

Was this reply helpful? Yes No