Answered

SharePoint Currency field display as current in view/edit modes

(0) Share

Report

Posted on by everdingk

Hello,

I have a form that by default is in view mode. There is a toggle which switches the value to edit mode. The form links to a sharepoint list of which one of the fields is "Amount" which is a currency field.

This form in my app does not show the value as a currency. To achieve this, I am using the following code in the default properties this Text(Value(Parent.Default),"$#,##0.00","en-us").

This kind of works but I am getting an error: The value $100 cannot be converted to a number.

Is there a way to display the field with the $ sign while being able to switch between view and edit modes?

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

v-hanytian-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @everdingk ,

In the SharePoint List that Type is Int.
When you change Default properties, it will show the Error Message.
Please fill the formula as below in Format in DataCardValue.
TextFormat.Text
Please fill the formula as below in Update in DataCard.
Value(Right(DataCardValue3.Text,Len(DataCardValue3.Text)-1))

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
everdingk 95 on at

Like (1)

Report
Copy link

Link copied!

thanks @v-hanytian-msft

So the first part of your response is changing the field type to text.
What exactly is the second part doing?

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @everdingk ,

We considered if you want to update data form Edit form to SharePoint List, it will change the String to Int without any Error Message.

Best Regards,
Tina

Was this reply helpful? Yes No
everdingk 95 on at

Like (0)

Report
Copy link

Link copied!

I am getting some runtime errors with this saying "The second argument to the 'Right' function is invalid."

I think this occurs when the amount field is blank... How would I fix this?

Was this reply helpful? Yes No
Verified answer

v-hanytian-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @everdingk ，

Please try this:
If(isBlank(DataCardValue3.Text), 0, Value(Right(DataCardValue3.Text,Len(DataCardValue3.Text)-1) )
Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
everdingk 95 on at

Like (1)

Report
Copy link

Link copied!

Ah I almost had it... just not entirely sure what the Update property does.... thank you so much for your help

Was this reply helpful? Yes No
everdingk 95 on at

Like (0)

Report
Copy link

Link copied!

Ah so I just noticed when I type 55 into that field it is saving as $5 so it is dropping the last digit.

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @everdingk ,

In my Testing, this formula means dropping the first chart of DataCardValue.
Best Regards,
Tina

Was this reply helpful? Yes No