Number Format using "Populate Microsoft Word template"

[BenRenshaw]

I am creating invoices from an Excel file, and I am using the "Populate Microsoft Word template". Even if I format my numbers to INT() or FLOAT(), when writing to the MS Word doc, the numbers are like this "1234.5" instead of "1,234.50". Is there anyway to force the format in the template? 

Thanks in advance,

Ben 

[AnthonyAmador]

Hi @BenRenshaw 

I think you can use the action "format number"

Hope this can help you.

Cheers.

[Rilsina]

Hi @BenRenshaw 

I agree with Anthony, Format Number action will help you get number in desired format.

Here is a small blog for reference- Format Number in Power Automate | CloudFronts

If this helps, Please Accept as Solution.

Thank you.

[BenRenshaw]

Thanks for your reply, I wrapped the info in formatnumber() expression - I overlooked this one.. and it worked fine!!! 

Ben 

[AnthonyAmador]

Thanks for share your findings 

Please consider marking the thread as solved so other people can find it more quickly.

Cheers.