Problem inserting value in sql server

(1) Share

Report

Posted on by gikido

1,030

good evening

in a power apps canvas application I try to insert a value with a comma in a table in sql server
Value(Concatenate(txtTaille.Text; ","; txtTailleExt.Text))

When I use a device with a French system language, the value is inserted correctly (for example 111,12) and if I use a device with English as the language, the value is inserted without a comma (11112)

How can I fix this problem?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello

Use the Text function to format the number with a specific locale:

If( Language() = "en", Text(Value(Concatenate(txtTaille.Text, ".", txtTailleExt.Text)), "[$-en-US]0.00"), Language() = "fr", Text(Value(Concatenate(txtTaille.Text, ",", txtTailleExt.Text)), "[$-fr-FR]0.00") )

This is what I get returned from English:

Hope this helps.

Was this reply helpful? Yes No
gikido 1,030 on at

Like (0)

Report
Copy link

Link copied!

@SpongYe

Text(....) gives error because the type in sql table is Float

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The issue you're experiencing is due to differences in decimal separators based on regional settings. In French, the comma is used as a decimal separator, while in English, a period is used.

Value(Text(txtTaille.Text & "," & txtTailleExt.Text, "[$-fr-FR]Standard"))

this should take care.

Was this reply helpful? Yes No