Format SQL fields for HTML Table

[jnovelliere]

Hello,
Can someone assist me with updating a field below with the format expression. Below is my column Max Amount and the output is 56500000 and I need to show $56,500,000.

I tried the below expression but no luck.

if(empty(item()?['maximum_x0020_debt']), '', formatNumber(item()?['maximum_x0020_debt'], '$0,000'))

Current

Here is a snip of my output. Max column needs to be $56,500,000.

[AbdulWahab]

Hi jnovelliere,

Here is the solution: Solved: Displaying a number as Currency or Decimal - Power Platform Community (microsoft.com).

If I answer your question then please mark it as verified.

Let me know if I can provide you with more details.

Thanks
Regards,

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/

[David- · Accepted solution]

Just replace '$0,000' with 'C0','en-us' and you should be all set. This is a good reference of the codes to use with formatNumber: Standard numeric format strings | Microsoft Docs

Note, C0 is without any decimal places. So if your value is 11.50 it will round up to $12. If you want to show the decimal places, use C1 or C2 for one or two decimal places.

[jnovelliere]

Thanks @David- 🤗

This was exactly what I needed.
I was able to solve with the expression below but went back and adjusted to C0.

if(equals(item()?['maximum_x0020_debt'],null),null,formatnumber(item()?['maximum_x0020_debt'],'$###,###,###'))