cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sundeep

Dealing with floating / decimals with high precision

Submitted by on ‎10-04-2018 11:25 AM

Hi Team, 

 

I have a Float datatype column in SQL Server and when trying to populate that to powerapp through  Gallery -> Label , I see that the value is being chopped.

 

ex: 0.272245892490096 [Actual value] is displayed as 0.27224589 and is chopping to 8 digits after the decimal. is there a way I can get the complete number. 

 

If this issue can be fixed by any chance it will be of great help

 

Status: Under Review

Adding @GregLi to comment on roadmap feasibility.

2 Comments (2 New)
Comments
Audrie-MSFT
Power Automate
Power Automate
‎10-05-2018 04:34 PM
Status changed to: Under Review

Adding @GregLi to comment on roadmap feasibility.

abrevera
Regular Visitor
‎11-24-2018 09:09 AM

I just ran into this same problem.  Attempting to do some location-based work which requires very precise Latitude/Longitude values.  This limitation has essentially stopped us in our tracks for using PowerApps for this purpose.

 

e.g. in SQL Server, the field is a decimal(22, 20) with a sample value of 0.00012367133757961800.  This is showing up in PowerApps as 0.00012367130000000000 which is throwing everything off.