cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Meneghino
Level 10

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
Level: Powered On

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 Team
Community Support Team

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.
Highlighted
rsoeagnie
Level: Powered On

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
Level 10

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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

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