BUG? Patch non-integer to SQL server gives error for European users?

(0) Share

Report

Posted on by Meneghino

6,949

I have an SQL server (Access Web App) table with a number column.

My locale is UK, and I can patch 123.45 to the column:

Patch(MyTable, Defaults(MySource), {MyNumerColumn: MyNumber}), where my number is a numerical context variable of value 123.45

However, when exactly the same app is opened by a colleague in Italy, an error is raised by the patch. It is not an issue of text vs. number because the context variable is numeric (tested with IsNumeric) and of the correct value. Also, when the context variable is set to 123 then the patch works in Italy too.

Has anyone else come across this or can reproduce the error in an Italian/French etc. locale?

Thank you

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Meneghino,

Thanks for this feedback.

Currently it is not available for me to test this.

I will try to involve others who is able to help to confirm this and will share the result once finished.

Appreciate your patience and understanding.

Regards
v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Meneghino,

Would it be available to add your colleague in Italy as Contributor, so that it would be available to check the errors when update hte column under PowerApp Studio?

We tested this, and it has no issues when changing the locale.

Sometime patch would encounter errors which is caused by not providing enough information, specially for the Primary key column.

By the way, what is the column type under your SQL Server, float, or the others ( Numeric Types)?

Regards
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I think this is a general issue: please see here
https://powerusers.microsoft.com/t5/PowerApps-Forum/Format-decimal-and-float-numbers/m-p/14530