cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Show a percentage from Sharepoint list

Hi, I have a calculated column (CompletionScore) in a sharepoint list that is formated as a number, to zero decimal places, and as a percentage.

 

I want to show it in Powerapp. I have tried:

Text=ThisItem.CompletionScore

 

but i just get 1.0000000000000 or 0.8666666666666

 

I have also tried:

Text=text(ThisItem.CompletionScore,"0%")

and have played around with the calculated column, changing it to a text formart, and also using Round, but i'm going in circles. I have control over the Sharepoint list and the calculatoin, so can change it if necessary.

 

Any help?

Thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Show a percentage from Sharepoint list

I revisted this problem this morning, and have found a solution:

 

Concatenate(Text(Round(Value(ThisItem.CompletionScore)*100,0),"[$-en-US]0"),"%")

 

It seems rather clunky, but it works. 

 

Thought I'd post in case someone else gets stuck like me.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Re: Show a percentage from Sharepoint list

I revisted this problem this morning, and have found a solution:

 

Concatenate(Text(Round(Value(ThisItem.CompletionScore)*100,0),"[$-en-US]0"),"%")

 

It seems rather clunky, but it works. 

 

Thought I'd post in case someone else gets stuck like me.

View solution in original post

ShowMeTheAnswer
Level: Powered On

Re: Show a percentage from Sharepoint list

Where did you put that formula - it doesn't seem to work in my "Format" field?

Highlighted
Diogo
Level: Powered On

Re: Show a percentage from Sharepoint list

I didn´t understand where to insert the code. I have the same problem (see pic). I uploaded data from an excel table, and one of my columns have a percentage.

 

In the excel document the column is formated as percentage. But when i upload to the Powerapp, that specific column shows only decimals.Capturar.PNGFull tableImagem1.pngLeft (powerapp) is the value in decimal, uploaded from the right (excel) in percentage.

kaleyanne
Level: Powered On

Re: Show a percentage from Sharepoint list

In the Text field of the DataCardValue set it equal to:

Text(Value(Parent.Default*100),"[$-en-US]0%")

 

That worked for me. I hope it works for you too! 

understatedcool
Level: Powered On

Re: Show a percentage from Sharepoint list

Does anyone know why this happens? 

 

I have a slightly different scenario whereby I have a number field in SharePoint which has a minimum & maximum value (0-100 respectively); this is then being displayed as a percentage with no decimal places. When a user attemps to submit a value (i.e. 20) through PowerApps, the form submission fails because it expects a value between 0-1?

 

Does anyone know why this is, and how to workaround this particularly strange issue? Does using the "display as percentage" option in SharePoint mean that the value has to be a decimal value between 0 and 1? 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 111 members 5,303 guests
Please welcome our newest community members: