cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Format number colum share point call on power apps

Hello, your support, I am trying to put the number in "1" and not "1.00000" without the zeros but I am not able, your help, try applying the commands "abs, exp among others" but I cannot change the type of exported number, is a calculated sharepoint columnpregunta-sharepoint.png

 

 

Thx.

From Peru.

Alexis Gutierrez

 

1 ACCEPTED SOLUTION

Accepted Solutions
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

16 REPLIES 16
Highlighted
Super User III
Super User III

Re: Format number colum share point call on power apps

@MrX19 

This code did the trick for me!

Round(Value(ThisItem.SP_TOTAL_UNIDADES_NUM),0)

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Highlighted
Frequent Visitor

Re: Format number colum share point call on power apps

put the following and I get the error

 

pregunta-sharepoint 2.png

 

thx.

Highlighted
Super User III
Super User III

Re: Format number colum share point call on power apps

@MrX19
Please provide the full error message you are receiving.
Highlighted
Frequent Visitor

Re: Format number colum share point call on power apps

pregunta-sharepoint 3.png

 

The following is still displayed with 1.00000
The following is still displayed with 1.00000
Highlighted
Super User III
Super User III

Re: Format number colum share point call on power apps

@MrX19
Ok, I know the problem. The syntax is different for Spanish vs English. Use this code instead. I replaced the comma with a semi-colon.

Round(Value(ThisItem.SP_TOTAL_UNIDADES_NUM);0)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
Highlighted
Frequent Visitor

Re: Format number colum share point call on power apps

i try...

need "5" not "500000 / 5.00000"

 

pregunta-sharepoint 4.png

Highlighted
Super User III
Super User III

Re: Format number colum share point call on power apps

@MrX19
Wow, it looks like there are 14 zeros in each number for some reason... does this do the trick?

Round(Value(ThisItem.SP_TOTAL_UNIDADES_NUM);0)/Power(10,14)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
Highlighted
Frequent Visitor

Re: Format number colum share point call on power apps

pregunta-sharepoint 5.pngthank you very much for helping me, now I have throws me with "," what I want is in whole number, the column adds me other columns is a calculated column.

if my problem is the zeros that appear

Highlighted
Super User III
Super User III

Re: Format number colum share point call on power apps

@MrX19 

Sorry, I actually don't understand your new question.  Can you please try to explain once again what your goal is here?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

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,914)