Unanswered

Problem saving number from powerapps to SQL SERVER

(0) Share

Report

Posted on by Mich_84_it

Hello, I have an input field that contains a decimal number. The system language of powerapps uses a comma as the decimal separator. This number needs to be saved in a SQL SERVER database, specifically in a field defined as decimal(10,2). The language of the database is set to US English. In practice, if I save the number with a comma, it gives me an error. If I try to convert it using a substitute, it saves the number without a comma (3,5 becomes 35.00 instead of 3.5). Any ideas?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mich_84_it

Please post the details as to how you're saving the record.

SQL Server will handle the saving of numbers automatically, irrespective of language. The behaviour you report could occur if you call Patch and call Text to convert the number to text.

Was this reply helpful? Yes No
Mich_84_it 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, I'm using a regular form for data saving connected to my SQL connection. In the UPDATE function of the field, I'm using the Value(Substitute(Text(DataCardValue5.Text), ",", ".")). I also tried inserting "en-US," but I'm still experiencing the issue.
Thank you

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Mich_84_it

You would just call Value like so - there's no need to call Substitute.

Value(DataCardValue5.Text)

Was this reply helpful? Yes No
Mich_84_it 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, Value(DataCardValue5.Text) return a conversion error

Was this reply helpful? Yes No
timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mich_84_it

This is very unusual.

If you add a completely new form with the OreTot field and not customise the form at all, does it work?

Was this reply helpful? Yes No