Unanswered

Power Apps Currency format Issue

(1) Share

Report

Posted on by VM_wyn

I have a text field on my power app which gets auto populated based on a subtraction happening on two fields above it. I wish to display the value with the South Africa ZAR currency symbol, ex R1234.00 . I am able to display the value fine but the update property of the datacard gives an error saying "Cannot convert R 1234.00 to a number" . My field format is also set to Text and my datasource column is also a string column. Weirdly this works perfectly fine if I change the currency to USD i.e. $ 1234.00. I have a feeling it is not identifying the currency symbol correctly. Is there anyway to fix this? I would like to display the currency symbol and not just a number

Field Format

Formula I use to populate my text input field

If((!IsBlank(DataCardValue13.Text) && !IsBlank(DataCardValue14.Text)),Text(Value(DataCardValue13.Text) - Value(DataCardValue14.Text),"[$-en-US]R#,##.00"),"")

The output looks fine

But the Update property gives this error

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Dipak_Shaw 108 on at

Like (1)

Report

May I know Which data source you are using?

Was this reply helpful? Yes No
Sunil Pashikanti 736 Moderator on at

Like (1)

Report
Hope you are using the exact below one in the default property of the textbox

Text(Parent.Default, "[$-en-US]R#,##0.00")

Alternative Approach (View Mode):
If you’re displaying the value in View mode (not Edit mode), you can use a label control to achieve the desired formatting.
Add a label control on top of the existing text input control.
Set the Visible property of both controls based on the form mode:

DataCardValueX.Visible: EditForm1.Mode <> FormMode.View NewLabelInCard.Visible: EditForm1.Mode = FormMode.View NewLabelInCard.X: DataCardValueX.X NewLabelInCard.Y: DataCardValueX.Y NewLabelInCard.Height: DataCardValueX.Height NewLabelInCard.Width: DataCardValueX.Width NewLabelInCard.Text: Text(Parent.Default, "[$-en-US]R#,##0.00")

Adjust the control names (e.g., DataCardValueX and NewLabelInCard) according to your app’s structure.

Was this reply helpful? Yes No
VM_wyn on at

Like (1)

Report

It's a Sharepoint list and the column is a single line text column

Was this reply helpful? Yes No