Formatting calculated fields from Sharepoint in Power Apps

(0) Share

Report

Posted on by Florian2508

I have an invoiced field in Sharepoint with the column heading Net Invoice Amount. This is formatted as currency.
Unfortunately, in Power Apps the correct value is displayed in the form during the calculation, but with 12 zeros at the end. How can I format it correctly in Power Apps. The calculation and display is done correctly in Sharepoint.

The display on the screenshot should read 49.00 instead of 49.000000000000.

I'm grateful for every tip!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Florian2508

If you have a label displaying the net invoice amount (NetInvoiceAmount), you can format it to display with two decimal places using the Text function:

Text(YourNetInvoiceAmountField, "[$-en-US]#.00")

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Florian2508 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your answer.
Unfortunately it doesn´t work. Maybe i´m in the wrong place?

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
I think Rechnungsbetrag Netto is text data type so you should change text to value.

Text(Value(ThisItem.'Rechnungsbetrag Netto';"[$-en-US]#.00")

Thanks!

Was this reply helpful? Yes No
Florian2508 4 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately it didn´t work. But i found a solution.
I also calculate the values for an ad in Pwoer Apps in power Apsps itself. The transfer to Sharepoint has already taken place correctly.

Was this reply helpful? Yes No
Suggested answer

Power_Person 71 on at

Like (0)

Report
Copy link

Link copied!
I had the same Issue, it works using this this format:
Text(Value(ThisItem.'Rechnungsbetrag Netto'), "#,##0.00 €")
In my case it looks like this:

You can change and move the position of the currency symbol or leave it out completely if you want.

Was this reply helpful? Yes No
Suggested answer

Thomas Karer 2 on at

Like (0)

Report
Copy link

Link copied!

Hi!

I had the same issue, for me the following formula worked:

Value(Substitute(Parent.Default; "."; ","))

Best regards.

Was this reply helpful? Yes No