Announcements
Set "Text(ThisItem.Price,"[$-en-US]$#,###.00")" in Power Apps Studio, but display with "￥1,899.99"
It may be a long shot, but check your currency settings under Advanced Settings > Settings > Administration > System Settings.
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")
Number
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.
The Price in Excel
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.
The issue is also seen when using Text(1234.56,"[$-en-US]$#,###.00")" in Apps
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 547
WarrenBelz 444 Most Valuable Professional
Valantis 322
