cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gorilla_8
Level 8

ANY ONE KNOW THIS ERROR?

I try to reput the label, but he cant show the "R$" is  the same on my lists on sharepoint.

 

Thanks.

 

print_reembolso_erro_R$.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: ANY ONE KNOW THIS ERROR?

@Gorilla_8 

Please try this code.  You will need to write it properly to inside accents on the letters.  My keyboard in English only, sorry.

"Resumo alientacao: " & Text(Value(ThisItem.'Resumo Alimentacao Total'); "[$-pt-BR R$ #,00]")

 

It is very odd that all the column types are number yet you are only having a problem with Resumo.  Something is different about it and I don't know what.  Do you have any ideas?

 

Finally, if the above code did not work, please supply all the code you used for these in the Items property:

  • Transporte
  • Viagem
  • Outros

 

---
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."

View solution in original post

9 REPLIES 9
Super User
Super User

Re: ANY ONE KNOW THIS ERROR?

@Gorilla_8
What column type is ‘Resumico Alcementio Total’?

Is the column type different from Transporte, Viagem or Outros?
Gorilla_8
Level 8

Re: ANY ONE KNOW THIS ERROR?

Yes, it is

Super User
Super User

Re: ANY ONE KNOW THIS ERROR?

@Gorilla_8 

Please answer my question "What column type is ‘Resumico Alcementio Total’?"

Gorilla_8
Level 8

Re: ANY ONE KNOW THIS ERROR?

Its a number

Super User
Super User

Re: ANY ONE KNOW THIS ERROR?

@Gorilla_8 

What column type are each of these?

  • Transportes
  • Viagem
  • Outros

 

Also, are you sure that Resumo Alimentico Total is not a "Calculated" column?

Gorilla_8
Level 8

Re: ANY ONE KNOW THIS ERROR?

Its all numbers column with the same properties, they sum all itens from another list

Super User
Super User

Re: ANY ONE KNOW THIS ERROR?

@Gorilla_8 

Please try this code.  You will need to write it properly to inside accents on the letters.  My keyboard in English only, sorry.

"Resumo alientacao: " & Text(Value(ThisItem.'Resumo Alimentacao Total'); "[$-pt-BR R$ #,00]")

 

It is very odd that all the column types are number yet you are only having a problem with Resumo.  Something is different about it and I don't know what.  Do you have any ideas?

 

Finally, if the above code did not work, please supply all the code you used for these in the Items property:

  • Transporte
  • Viagem
  • Outros

 

---
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."

View solution in original post

Gorilla_8
Level 8

Re: ANY ONE KNOW THIS ERROR?

When i put this: 

 

"Resumo alimentação: " & Text(Value(ThisItem.'Resumo Alimentação Total'); "[$-pt-BR] $ #,00")

 

They work it! 

 

It just publish and refresh the database too!

 

Thanks @mdevaney!

Super User
Super User

Re: ANY ONE KNOW THIS ERROR?

@Gorilla_8 

You are most welcome.  Best of luck in building your app!

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,780)