web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Text Language set "$",...

Power Apps

Unanswered

Text Language set "$", but actual display "￥"

(0) Share

Report

Report

Posted on by LoongWang

Set "Text(ThisItem.Price,"[$-en-US]$#,###.00")" in Power Apps Studio, but display with "￥1,899.99"

Categories:

Building Power Apps

Text Issue.png

I have the same question (0)

All responses Img

All responses (7)

Answers Img

Answers (0)

logixcrm 71 on at

Like (0)

Report

It may be a long shot, but check your currency settings under Advanced Settings > Settings > Administration > System Settings.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @LoongWang,

Could you please tell me if the Price column is a Number or Text type?

If it is a Text type, please modify your formula as below:

Text(Value(ThisItem.Price),"[$-en-US]$#,###.00")

Was this reply helpful? Yes No
LoongWang on at

Like (0)

Report

Number

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @LoongWang,

Go and check your column settings. The following is my Number column settings, please check as below:

I have a test and the situation is confirmed on my side:

Note that the PriceR is a Number column in my SP list.

Was this reply helpful? Yes No
LoongWang on at

Like (0)

Report

The Price in Excel

Price.png

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @LoongWang,

Could you please share more details, like number settings for the Price column in your excel table?

Here is how I set the Number column in my excel table.

In addition, I suggest you create a general column instead to save the format currency.

Was this reply helpful? Yes No
LoongWang on at

Like (0)

Report

The issue is also seen when using Text(1234.56,"[$-en-US]$#,###.00")" in Apps

Was this reply helpful? Yes No

Join the conversation