Does anyone know how to display 321.234567891234 in a text box with all significant figures?
According to this post by @AndyPennell, PowerApps does its very best to reproduce Excel (including bugs) however Excel clearly shows all significant figures but PowerApps does not. If this is true, then this makes PowerApps useless for a lot of scientific work.
Many thanks.
You cannot. PowerApps numbers are limited to the range of values supported by Javascript, and your example exceeds the accuracy limits of same. Excel has a much richer numeric type system.
Thank you for the reply.
It would be useful to have in the documentation of PowerApps details of such limitations.
Indeed, I opened a Document bug to address this when the subject came up last, but it hasn't been fixed yet.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 757 Most Valuable Professional
Michael E. Gernaey 322 Super User 2025 Season 2
MS.Ragavendar 209 Super User 2025 Season 2