Gallery Money Display

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a gallery from my sharepoint data that displays a field set as money in SharePoint.

I want it to be displayed like R$ 500,00.

So i made a research to better undestand how to display it correctly, however i still got some mistakes.

At my Label, in the function Text, i put the formula:

If(ThisItem.MyMoney=0;"";Text(Round(ThisItem.MyMoney;2);"[$-en-US]$ ####.##"))

The problems are in values represention like R$ 200,00 and R$ 200,10. They are showing values as R$ 200, and R$ 201,1. The final zero is not being displayed.

If someone could help me i would appreciate.

Best regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 154,393 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try

If( ThisItem.MyMoney=0; ""; Text( Round(ThisItem.MyMoney;2);"[$-en-US]$ ###0.00" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz

Thank you!

It worked perfectly.

Best regards,

Was this reply helpful? Yes No