Unanswered

Power Apps does not show data correctly

(0) Share

Report

Posted on by skouboe

Hi,

My SharePoint list used as reference to my Power App, is having a calculated colum that calculates a percentage. In SharePoint list called "Scorecard", the number is shown correctly e.g. 70%. see attachment called "Correct".

Unfortunately Power Apps in the "Browser screen" shows the number different e.g 0,697297297297297

Anyone who knows how to solve this??

Regards

dennis

Categories:

Power Apps portals

Browserscreen.png

Correct.png

I have the same question (0)

All responses (5)

Answers (1)

ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

Hi Denis,
Probably can you take a look on below link

https://powerusers.microsoft.com/t5/Building-Power-Apps/Show-a-percentage-from-Sharepoint-list/td-p/96949

Hope it should work

Was this reply helpful? Yes No
skouboe 10 on at

Like (0)

Report

Hi
If I click your link an error pops up. Is it possible to check the link you sent to me.
Cheers
Dennis

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (0)

Report

Sorry about that. Please try the below link

https://powerusers.microsoft.com/t5/Building-Power-Apps/Show-a-percentage-from-Sharepoint-list/td-p/96949

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @skouboe :
I assume that 70% is the correct calculation result and not an approximation.
Fristly,the cause of the problem may be:
Floating-point arithmetic is approximate, so it can sometimes give unexpected results with many documented examples. You might expect the formula 55 / 100 * 100 to return exactly 55 and (55 / 100 * 100) - 55 to return exactly zero. However, the latter formula returns 7.1054 x 10–15, which is very small but not zero. That tiny difference doesn't normally cause a problem, and the app rounds it away when showing the result. However, small differences can compound in subsequent calculations and appear to give the wrong answer.
Secondly,please set the label's Text property to:

Round(Value(ThisItem.Scorecard),2)*100&"%"

Best Regards,
Bof

Was this reply helpful? Yes No
skouboe 10 on at

Like (0)

Report

Again,

Really strange...

Power Apps in Windows shows correct when using your suggestion. Problem is that if I log into the app via my mobile phone it looks very different. See attavhed.

Looks more to me that there is an issue with Power apps.

Regards Dennis

Screenshot powerapps from mobile device shows incorrect

Screenshot powerapps in Windows shows correct

Was this reply helpful? Yes No