web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate HTML format for numbers

Power Automate

Answered

HTML format for numbers

(0) Share

Report

Report

Posted on by tanveal

235

Hi I am using HTML format and inputting the table in email.

However, i am having trouble formatting number columns to show commas. Is it possible to format so it's actually in accounting format showing $ and commas ?

Below are the number columns from table generated in email

flow

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @tanveal ,

You can try to use the formatNumber() function to format your numbers.
Learn more via the links below.
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn
Custom numeric format strings | Microsoft Learn.
formatNumber(Float(item()?['Number1']),'$##,#.0#')

Best Regards,
Dezhi

Was this reply helpful? Yes No

Join the conversation