cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

What's the maximum value you can store in a number field?

What's the maximum value that you can store in a CDS number field?

 

The documentation says that you can store a total of 32 digits, with a maximum of six digits to the right of the decimal point.

 

https://docs.microsoft.com/en-us/common-data-service/entity-reference/field-data-types

 

But in my testing, I find that I can only store a maximum of 17 digits.

 

Can someone explain why this is? Is this an error with the documentation, or is there a bug in PowerApps that prevents you from saving more than 17 digits?

 

Thanks 

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps Staff AndyPennell
Power Apps Staff

Re: What's the maximum value you can store in a number field?

I can't speak to CDS, but PowerApps numeric limits are defined by Javascript:

 

http://stackoverflow.com/questions/307179/what-is-javascripts-highest-integer-value-that-a-number-ca...

 

View solution in original post

4 REPLIES 4
Power Apps Staff AndyPennell
Power Apps Staff

Re: What's the maximum value you can store in a number field?

I can't speak to CDS, but PowerApps numeric limits are defined by Javascript:

 

http://stackoverflow.com/questions/307179/what-is-javascripts-highest-integer-value-that-a-number-ca...

 

View solution in original post

Super User
Super User

Re: What's the maximum value you can store in a number field?

Thanks Andy,

 

So the conclusion from this is that the maximum numeric value that PowerApps supports is 9,007,199,254,740,990, even if the underlying data store could support a larger value.

 

Just out of curiosity, do all versions of PowerApps have a dependency on JavaScript? I naturally assume that the web version of PowerApps studio uses JavaScript, but do the Android and IOS versions also rely on JavaScript, and therefore also be subject to the same numerical limits?

Power Apps Staff AndyPennell
Power Apps Staff

Re: What's the maximum value you can store in a number field?

Yes, to both questions: the numeric limits are as stated, and JavaScript is the underlying technology for all PowerApps.

Super User
Super User

Re: What's the maximum value you can store in a number field?

Thanks @AndyPennell

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

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.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

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 (9,678)