Unanswered

Currency not showing in USD in other countries - SharePoint PA form

(0) Share

Report

Posted on by Cbeene

Good day PowerAppers. I'm having an issue I was hoping someone could shed some light on.

I have a PA customized form for my SharePoint list. I have several Currency fields in said list. Within the these fields I updated the default mask as - Text(Value(Parent.Default),"[$-en-US]$ #,###.00").

As you can see in my 1st attachment, my currency fields show up as "$".

The problem is that my global users see these same fields in their local currency (see my second image). Any idea's on how to make this show as USD in any country??

Categories:

Building Power Apps

Global view.JPG

USD view.JPG

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

mdevaney 29,989 Moderator on at

Like (0)

Report

@Cbeene

Your formula requires one additional argument to ensure everyone sees the value in USD.

Text(Value(Parent.Default),"[$-en-US]$ #,###.00","en-US")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Cbeene 74 on at

Like (0)

Report

Well that is simple enough. Thanks @mdevaney

Was this reply helpful? Yes No
Verified answer

Cbeene 74 on at

Like (0)

Report

@mdevaney I spoke to soon. This change didn't effect anything when I view the PA, so nothing changed there. My user overseas, however, reported that those fields were I made the change are now showing nothing. To be clear, the fields were USD goes are calculations based on the exchange rate they put in and then the local currency number there are entering next to the USD field. See image.
I just added the "en-US" as you suggested, but maybe my formula is incorrect to begin with.

Text(Value(Parent.Default),"[$-en-US]$ #,###.00","en-US")

Thoughts?

Capture.JPG

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@WarrenBelz @Pstork1

Any ideas here?

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@Cbeene ,
Did some testing and this worked for me on a numeric field
Text( Parent.Default, "[$-en-US]$ #,##0.00" )
and this on a text field with a number in it
Text( Value(Parent.Default), "[$-en-US]$ #,##0.00" )

Be aware that other than in the US, this will often change to your country (it does here in Oz) and then you will get an error - you just need to change it back to US.

Was this reply helpful? Yes No
Cbeene 74 on at

Like (0)

Report

An Update: I didn't make any changes to the formula @mdevaney provided me but today I have an email from my Chinese counterpart telling me that it's fixed on his end. The numbers are showing, and in USD. I guess that was the correct solution after all. Thanks, however, @WarrenBelz .

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@Cbeene ,
The whole problem with this is different regional settings and users like myself (Australia) and @mdevaney (Canada) can only provide answers which work for us and (in the vast majority of cases) also work for the other person.
You also need to be aware that this has absolutely nothing to do with Exchange Rate - Power Apps does not perform that function.
It is about what "patterns" have been pre-loaded. Any dollar format is simply dollars (US, Canada, Australia, NZ, Singapore . . . ) and a way of displaying it in your App.
If my solution worked for you, please consider Accept as Solution.

Was this reply helpful? Yes No