Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - Power Apps Portals
Answered

Power Apps does not show data correctly

(0) ShareShare
ReportReport
Posted on by 10

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

 

  • skouboe Profile Picture
    10 on at
    Re: Power Apps does not show data correctly

    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

    Mobile snapshot.jpg

     

    Screenshot powerapps in Windows shows correct

    Windows snapshot.png

  • Verified answer
    v-bofeng-msft Profile Picture
    on at
    Re: Power Apps does not show data correctly

    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

     

  • ragavanrajan Profile Picture
    7,036 Most Valuable Professional on at
    Re: Power Apps does not show data correctly

    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 

  • skouboe Profile Picture
    10 on at
    Re: Power Apps does not show data correctly

    Hi

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

    Cheers

    Dennis

     

  • ragavanrajan Profile Picture
    7,036 Most Valuable Professional on at
    Re: Power Apps does not show data correctly

    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

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.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 1

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 1

#3
surya narayanan Profile Picture

surya narayanan 35