Unanswered

How to format fields to display as currency in edit and view modes and how to total said fields in another field

(0) Share

Report

Posted on by GardenGirl

It is quite perplexing that the Power Apps custom form formulas based on Excel do not make it simple to set a field as currency showing the dollar sign and .00 for dollars with no cents. What is the simplest way to have number fields display as currency in EDIT and VIEW modes and to total them in another field in a Power Apps custom form? In Excel this can be accomplished in less than 2 minutes and not 2 hours.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @GardenGirl,

Absolutely you could achieve this directly in Excel sheet by some function set, however, in PowerApps, recgonize it as numbers and sum total is not supported.

The simplest way is to format the column as the GENERAL type in Excel, then convert it into numbers and sum it in PowerApps.
GardenGirl 35 on at

Like
a
(0)

Report
Copy link

Link copied!

I am trying to accomplish currency fields displaying "$0,000.00" and totaling this fields in another field solely in a Power Apps custom form. I only mentioned Excel since it has been touted that the Power Apps formulas were based on Excel.

This is something so basic and I am astounded Microsoft has chosen not to provide this basic functionality without developers having to be contortionists.
trjackson77 254 on at

Like
a
(0)

Report
Copy link

Link copied!
You can achieve currency formatting and totaling in Power Apps with the following steps:
Currency Formatting:
Use the Text() function to display currency fields in the "$0,000.00" format.
Text(YourNumericField, "$0,000.00")
Totalling the Fields:
To calculate the total of these formatted fields, use the Sum() and Value() functions. Create a new field to display the total as text.
Text(Sum(Value(YourFormattedField1), Value(YourFormattedField2), ...), "$0,000.00")
Add it to the Custom Form:
Insert the expression from step 2 into the desired field in your Power Apps custom form.
Power Apps offers flexibility and customization, making it a powerful tool once you get the hang of it. If you have any specific questions or run into issues, feel free to ask for further assistance.

Keep Going!

Tim