Answered

Show Individual Currency Fields as US Currency

(0) Share

Report

Posted on by Phineas

5,335 Moderator

I have several independent currency fields in Gallery1.

If 'Reference ID' is blank I want $00.00 to appear as default
content.

If an amount is entered in the currency field, I'd like the amount
to show as US currency - (example: entering 12345670 would
appear as $123,456.70

If(IsBlank(Edit_PO_Reference_ID_Fld.Text),"$00.00", Value(Self.Text),"$#,###.00")

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Phineas ,

Maybe something like this

If( Len(Self.Text) = 0, "$00.00", Text(Value(Self.Text),"$#,###.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.

MVP (Business Applications) Visit my blog Practical Power Apps
Phineas 5,335 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I can't get anyone to bite on my screen scroll question - which I've already submitted, twice.

Do you have any thoughts?
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Phineas ,

Sorry, I am not a user of this format - I either tab list the visibility of cards or use pop-ups.