web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Apps - Building Power Apps Displaying Numbers wit...

Power Apps - Building Power Apps

Suggested answer

Displaying Numbers with Scientific Notation

(0) Share

Report

Report

Posted on by GB-17111712-0

I have a number from a calculation 0.0001186049010045943 that in my legacy .Net app displays as 1.19E-4 and now I want to display the same number in Power Apps.

When I use Text(number, "[$-en-US]0.##E+0" ) I get 0.E+0

In .Net the number was declared as a Double and I used ToString("0.##E+0") to get the correct format of 1.19E-4

How can I get it displayed as 1.19E-4 in Power Apps? I tried Round and changing the number of decimal place but no success.

When I use the same format with this number 7.06402031 I get 7.06E+4

It appears the issue is related to Precision?

Any help would be appreciated

Gary

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

BCBuizer 22,424 Super User 2025 Season 2 on at

Like (0)

Report
Displaying Numbers with Scientific Notation

@GB-17111712-0,

When running your question through Copilot, it suggested the below formula as workaround for the lack of native support for scientific notation:

With( { num: 0.0001186049010045943, exp: RoundDown( Log( Abs(0.0001186049010045943) ) / Log(10) ) }, Text( num / Power(10, exp), "[$-en-US]0.00" ) & "E" & exp )

Obviously the numbers are hardcoded, so you neeed to replaced with the number / reference to what you wish to display.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
GB-17111712-0 on at

Like (0)

Report

Displaying Numbers with Scientific Notation

Appreciate the tip but it has syntax errors. RoundDown expects two arguments and only has 1. Power also has invalid argument.

Quite a few redlines

When I asked Copilot I got

But this does not work either

Was this reply helpful? Yes No

Join the conversation