cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Support
Community Support

Re: Format number colum share point call on power apps

Hi @MrX19 ,

Do you want to display as whole number, not "5.00000000000000"?

I've made a similar test and found that you just need this formula:

Value(ThisItem.SP_TOTAL_UNIDADES_NUM)

4144.PNG

 If the problem still exists, please show me your calculated column's calculation rule.

 

 

Best regards,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Frequent Visitor

Re: Format number colum share point call on power apps

Hello thanks for your support, I have the following, columns entered by the user and the other is sharepoint's own calculated columns which results in "5.0000000 / 500000000 ..." and what I want is "5" removing the zerospregunta-sharepoint 6.png

Highlighted
Super User III
Super User III

Re: Format number colum share point call on power apps

@MrX19 
Please answer my latest question.

Highlighted
Frequent Visitor

Re: Format number colum share point call on power apps

excuse me, it is actually the same result, I already tried with the formulas (fx VALUE,ROUND,ABS) that you gave me but I cannot disappear the zeros "# 000000000", in sharepoint and created that calculated column, in the web view it is seen as integer "5", but calling it to power apps gives me "50000000" or "5.0000000" and what I want is "5" without the zeros

Highlighted
Community Support
Community Support

Re: Format number colum share point call on power apps

Hi @MrX19 ,

I notice that using formula as I suggested :

Value(ThisItem.SP_TOTAL_UNIDADES_NUM)

 has meet your requirements: display "5.000000" as "5" in your picture.

Have your problem been solved?

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Format number colum share point call on power apps

Thank you all for your collaboration, in some way or another I managed to display only the integer "1" and not "1.00000", "100000000" or other types of combination that distracted the reading of the number "that came out, I share EYE that mine is a SHARE POINT CALCULATED COLUMN, when exporting it to excel it shows me the whole number, but when calling it to power apps it visualized me with several zeros, greetings.

 

>>>>>>>>>>>>>>Value(ThisItem.'Parent.Default';"zh-TW")<<<<<<<<<<<<<<<<

calculated column = 5
display in power apps = "5000000" or "5.0000000" or "5,00000000"
applying the function (changing language "zh-TW") = 5

 

Perú, Lima - Alexis Gutierrez

Highlighted
Community Support
Community Support

Re: Format number colum share point call on power apps

Hi @MrX19 ,

Ok.

I'm very glad that you've displayed your calculated column in the right format.

Do you have any other probems?

If not, could you make my answer as solution?
Thanks!

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,881)