Answered

Dealing with Float datatype

(0) Share

Report

Posted on by Sundeep

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.

As these are Foreign exhange values we cannot slip atleast one digit.

Any help is appreciated. See below for the screen shot

thanks

Sundeep

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

Hi @Sundeep,
I did a little experiment and found that apparently Powerapps is hard coded to accept a maximum of ten decimal places. (I looked at the function Pi().) and used Text(Pi(),"#.##########") putting more #'s beyond 10 did not change the value shown. When any function was used to either multiply or divide Pi, the result was limited to 8 decimal places, again regardless of the number of #'s shown.

If you need more than 10 decimal places shown, I suggest that you submit a request to the Powerapps Ideas forum.
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas
Please mark this as solved if it answers your question.

Was this reply helpful? Yes No
timl 36,415 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Sundeep

I think that @Drrickryp is correct about there being a hard limit on the number of decimal places that you can use in PowerApps.

When I asked a similar question, @AndyPennell explained that JavaScript imposes limits on the accuracy of the numbers that PowerApps can use. I suspect you might be encountering the same issue.

https://powerusers.microsoft.com/t5/General-Discussion/What-s-the-maximum-value-you-can-store-in-a-number-field/m-p/31935#M13302

Here's another thread that you might find useful if you're working with SQL Server and numbers.

https://powerusers.microsoft.com/t5/General-Discussion/Loss-of-precision-with-SQL-Server-BigInt-data-type/m-p/31969#M13320

If you need to display float values with the correct level of precision, perhaps you could create a SQL Server view and cast your float datatype column to the varchar data type? That way, PowerApps should interpret your foreign exchange values as text and display the correct number of decimal places.

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report

Hi @Sundeep,

I have made a test, and the issue is confiemed on my side.

I agree with @timl's thought almost. PowerApps numeric limits are defined by Javascript&colon. Currently, the max decimal places of a Number type value is 8.

If you would like to get more decimal places (more than 😎 for a Number type value within PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

As an alternative solution, you could consider take a try to create a Varchar type column to store the Foreign exhange values within your SQL table.

Best regards,

Kris

Was this reply helpful? Yes No
Verified answer

Sundeep on at

Like (0)

Report

@v-xida-msft, I accept that Kris, Submitted an Idea already and its under review now. I spoke with the Engineering team as well and seems by design there is a limitation. But it happens only with PowerApps - > Gallery control but not with Data Table control. DataTable shows everything fine..

Thanks for jumping in to help us. Appreciated:)

Was this reply helpful? Yes No