cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnjohn123
Post Prodigy
Post Prodigy

Value must be between 0 and 1 for a sharepoint percentage field

I have the following SharePoint field, which is a pecentage between 0 and100:-

 

johnjohn123_0-1630348526181.png

 

 

now on Power App when i try to save the field by entering a value such as 15, i will get this error:-

 

johnjohn123_1-1630348574742.png

 

 

any advice?

Also if i enter 1 inside power app >> it will be saved as 100% inside SharePoint.. also i am getting this error inside the built-in formula  " We can not convert the value to a number because the value is an empty string":-

 

johnjohn123_0-1630349589464.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @johnjohn123 ,

 

I take my first item as an example.

vxiaochenmsft_0-1630466939415.png

Add a label control and set its Text property to:

First(LIST163).TestNumber *100 &" %"

 

vxiaochenmsft_1-1630466980721.png

 

Best Regards,

Wearsky

 

 

View solution in original post

3 REPLIES 3
v-xiaochen-msft
Community Support
Community Support

Hi @johnjohn123 ,

 

You could set update property of your datacard to:

Value(DataCardValue48.Text/100)

 

Best Regards,

Wearsky

@v-xiaochen-msftand what about showing the data,, as if it inside sharepoint as 100% it will be shown inside power apps as 1? thanks

v-xiaochen-msft
Community Support
Community Support

Hi @johnjohn123 ,

 

I take my first item as an example.

vxiaochenmsft_0-1630466939415.png

Add a label control and set its Text property to:

First(LIST163).TestNumber *100 &" %"

 

vxiaochenmsft_1-1630466980721.png

 

Best Regards,

Wearsky

 

 

View solution in original post

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,213)