cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gorilla_8
Impactful Individual
Impactful Individual

REMOVE THE ZERO ON COLUMN SHAREPOINT AND POWERAPPS

Hey guys, I need remove and format a number in PowerApps and sharepoint ate the same is that possible?

 

See the Screenshot:

 

remove the comma.png

 

2.248

 

I wanna show this:  224,80

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

Try:

Text(Value(TextInput2.Text)*100,"0.00")
 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

 
 

View solution in original post

4 REPLIES 4
eka24
Super User
Super User

Try:

Text(Value(TextInput2.Text)*100,"0.00")
 

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

 
 

View solution in original post

Paulo_VS
Advocate I
Advocate I

Opa, boa tarde!

 

No próprio Sharepoint, tem como você definir a coluna como "Moeda", se quiser que apareça no PowerApps quando for fazer a consulta também faz assim ...

 

resolution.png

Gorilla_8
Impactful Individual
Impactful Individual

@eka24 Thanks for the reply! 

 

But didn't so well...

 

didnt work.png     

224.800

 

form.png

,

Text(Value(Parent.Default)*100;"[$-pt-BR] #.0")

 

He didn't recongize...

 

 

And @Paulo_VS ...

 

Eu sei que tem essa opção no SharePoint, pois não tá funcionando muito bem ...

 

 

Gorilla_8
Impactful Individual
Impactful Individual

@eka24 Thanks for the idea... I think works well...

 

 

See the print:

 

didnt work.png

 

And the formula(If anyone wanna)

 

form.png

 

Text(Value(Parent.Default)/10;"[$-pt-BR] #,#")

 

Thanks e Obrigado @eka24 e @Paulo_VS for the help! 🙂

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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