Can you format label to show currency?

Like (0) Share

Report

Posted on 21 Sep 2022 03:09:18 by DGWolfe

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

Categories:

General Questions

I have the same question (0)

All responses (2)

Answers (1)

DGWolfe on 21 Sep 2022 at 03:50:39

Like (0)

Report

Re: Can you format label to show currency?

Thanks so much @v-qiaqi-msft , worked perfectly!

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on 21 Sep 2022 at 03:26:55

Like (0)

Report
Re: Can you format label to show currency?

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")

Was this reply helpful? Yes No