Jul 10 2020 08:02 AM
Hi everyone. I am formatting a SharePoint On-Line list with JSON and have a column that is set-up in SharePoint as a 'Currency' column. In standard list view without any JSON applied it shows in proper $XX,XXXX.XX format. I'd like to get it shown the same way after I've applied JSON to the list, but can't seem to get it quite right.
The closest I can get is to manually ad a '$' into the "txtContent" span, but it doesn't then show any of the comma delimiters or anything. I've attached what I've done so far and what it results in.
Is there a better way for me to cost this into the JSON?
Jul 14 2020 01:17 AM
@jdiorio ,
When you are using currency field in JSON formatting and concatenating some text to its value it gets converted to string.
And I don't think that there is any function supported by JSON formatting till now which will convert it back to currency and append the commas (,)