cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Meneghino Community Champion
Community Champion

Re: Format decimal and float numbers

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
New Member

Re: Format decimal and float numbers

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.

Community Support
Community Support

Re: Format decimal and float numbers

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rsoeagnie
Frequent Visitor

Re: Format decimal and float numbers

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 Community Champion
Community Champion

Re: Format decimal and float numbers

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.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (4,902)