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)

Sort by

Dipak_Shaw 108 on at

Like
a
(1)

Report
Copy link

Link copied!

May I know Which data source you are using?

Was this reply helpful? Yes No
Sunil Kumar Pashikanti 2,338 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No