Announcements
Hi,
I have a gallery showing various SP list data. One is a currency field, however, I would like to format the LABEL in the gallery to show the currency. Is this possible? I have read a lot about form formatting for currency, but nothing on labels.
Thanks
Hi @DGWolfe,
To format a currency, you could set the Label Text property as below:
Text(Value(ThisItem.CurrencyField), "[$-en-US]$ #,###.00")
Or you could add the currency symbol by hard code:
"$" & Text(Value(ThisItem.CurrencyField), "[$-en-US]#,###.00")
Thanks so much @v-qiaqi-msft , worked perfectly!
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 325 Most Valuable Professional
11manish 165
MS.Ragavendar 88 Super User 2026 Season 1