Formatting number field for USD ($)

(0) Share

Report

Posted on by mgd1317

Hi, confused on how to modify this field to show only 2 decimal places and adding a comma for thousands.

Any insight for the field within the "Populate Word" would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @mgd1317

Pls try the below expression and pass the decimal value dynamically in place of hard code value:

Expression needs to be added in the expression box as highlighted in the above screenshot:

formatNumber(7168.5500000000,'#,###.00')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
formatNumber(1234.567, 'C2', 'en-us')

Was this reply helpful? Yes No
mgd1317 49 on at

Like (0)

Report

Hi, appreciate the response. Confused a little bit. Here's what I put in place because I cannot hard code any value since it always changes.

Here's what I put in place, that does not work, although I thought it would if I added in the field.

formatNumber(outputs('Get_item')?['body/Amount_x0020_to_x0020_Bill'],'#,###.00')

Here's the error.

Unable to process template language expressions in action 'Populate_a_Microsoft_Word_template' inputs at line '0' and column '0': 'The template language function 'formatNumber' expects its first parameter to be an integer or a decimal number. The provided value is of type 'String'. Please see https://aka.ms/logicexpressions#FormatNumber for usage details.'.

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Your Sharepoint column type is String.

Either change it to Number or convert this string to a Number in Power Automate with function float()

Was this reply helpful? Yes No
mgd1317 49 on at

Like (0)

Report

Appreciate that insight. What would the syntax be for the float string?

Was this reply helpful? Yes No
Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
formatNumber( float( outputs('Get_item')?['body/Amount_x0020_to_x0020_Bill'] ), '#,###.00' )

Was this reply helpful? Yes No
mgd1317 49 on at

Like (0)

Report

Thanks a ton for your assistance. Worked great!

Was this reply helpful? Yes No