Create HTML FormatNumber error Power Automate

Question

I tried to format the HTML Table below for the number

This is the expression that I used:

formatNumber(int(item()?['Trans Amt']), '0,0.00', 'en-us')

However, it gives an error message as below.

The numbering format expectation is as follows "100,000.00" Thank you.

Are they all int? If not you will get this error. Try decimal(...) or float(...) as an alternative. — Sam Nseir, Commented Aug 28, 2024 at 6:52

Sumit · Accepted Answer · 2024-09-05 14:38:49Z

0

The error expression likely due to incorrect usage of int() and formatNumber() converting the value to an integer you should ensure your are formatting the number correctly.

like,

formatNumber(float(item()?[Trans Amt]),'0,0.00',en-us)

float(item()?[Trans Amt]) - this converts the value to a floating-point number

formatNumber() - this formats the number according to the pattern '0,0.00'

edited Sep 5, 2024 at 14:38

Sumit

1,1611 gold badge14 silver badges30 bronze badges

answered Aug 28, 2024 at 6:54

Nidula Nimadith Wijesekara

444 bronze badges

it works perfectly! thank you
– Novia
Commented Aug 29, 2024 at 9:32

Add a comment |

Collectives™ on Stack Overflow

Create HTML FormatNumber error Power Automate

1 Answer 1

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Related