Format decimal and float numbers

[Yme]

Dear reader,

I have a question regarding creating records into a SQL server 2016 on premise database.

I have a column with type: float, Now I have created a form which inserts records into the database. The format for the column is now TextFormat.Number. How can I modify this format in a way that it can handle floats with decimal ','.

Now it just gives an syntax error on submitting the record into the database.

Alternative, I saw that the budget tracker has something like a solution to it since, I can only type in numbers. The format looks like text but when I enter letters the trackers just gives an error.

How can I solve this, without changing the database type to nvarchar.

Best regards.

[Meneghino]

Hello @v-micsh-msft

Thanks for following up:

1. It is Access Web Apps on Office365 E3 subscription, not sure of the language, but all is in English

2. Patch(MySource, {ID: 55}, {MyNumberField: MyNumberContextVariable})

Please note that the above works fine in an Eglish Windows environment, but does not work when the app is openend in Safari (iOS) in an Italian environment

[Yme]

Hi @v-micsh-msft,

1: I use collation: Latin1_General_CI_AS, with language English (United States).

2: Actually there is no 'real' formula I use. I have dragged a form (on which the fields can be adjusted). I connect the form to a datasource & specific table. Select the column having datatype: float in the database (by clicking on the eye). Then make 2 buttons: 1 creates the form, 1 saves the form. Then I run the app. I click on the create button. Form appears, then I type: 11,11 and save the form. Before saving the error shows.

Thats it!

Is there a way to insert an image from my computer? It looks I only can insert images that have been uploaded on the internet already?

Best regards.

[v-micsh-msft]

Hi @Meneghino and @Yme,

Thanks for the update.

For the image, take a look at the image control:

https://powerapps.microsoft.com/en-us/tutorials/control-image/

I will try to take some further tests for the numbers in SQL server database.

Regards

[rsoeagnie]

density van decimal/numeric naar varchar
DataCardValue5.Text -> Number in powerapps
density on update if(find(DataCardValue5.text,","), substring(DataCardValue5.text,",","."))

I'm still getting this type of error when using the DECIMAL in a table on SQL Azure.

CREATE TABLE PRODUCT(

   ID   INT IDENTITY(1,1)      NOT NULL,
   PRODUCT_NAME VARCHAR (255)       NOT NULL,
   DENSITY  DECIMAL(7,4),  

   CONSTRAINT PK_PRODID PRIMARY KEY CLUSTERED (ID ASC));

It worked fine, when I tried to save 0.397 on a system with en-US settings, but when I tried to save the value 0,397 on a system with other region-settings I got the error (making it 0.397 resulted in 397).

changing DECIMAL(7,4) into REAL results in when saving the number changed in 0,38

Is there a bug in the SQL Azure connector?

[Meneghino]

Hi @rsoeagnie, yes there are numerous bugs in the SQL Azure connector, including:

1) Only a limited number of decimal places after the decimal mark will be saved

2) It is not possible to patch null values

3) It is not possible to filter date (and I think datetime columns) using > or < operators

4) The in operator is in theory delegated according to documentation, but it does not seem to be working consistently

5) Cannot write to temporal tables

6) Localisation issues (i.e. what you found)

That is all that comes to mind at the moment, but I think there are more.

If you find a good alternative to PowerApps for Azure SQL, please let me know.