Answered

Need Help, How to convert HTML table columns in proper date and Currency format.

(0) Share

Report

Posted on by Subodh-Gupta

Dear All, I am working on a flow which will take data from Excel and then make a HTML table and then send email. The flow is working fine, but i am getting date as 2024-04-03T00:00:00.000Z, I just want date as 2024-04-03.Also the amount I am getting as 300 and I want Rs 300.00

Request your support.

thanks.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Srini007 3,483 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Subodh-Gupta

While configuring the value, you can add a expression as below

For Date:

formatDateTime('DateValue', 'yyyy-MM-dd')

Replace DateValue with your actual DateValue

For Number:

formatNumber(300, '0.00')

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Cheers,

Srini

Was this reply helpful? Yes No
Subodh-Gupta on at

Like (0)

Report
Copy link

Link copied!

Many thanks Srini,
But my issues is that I need to format this once the HTML Table is created and ready to be sent by email.
Currently I am getting like this and i need to change the date and amount format.

Was this reply helpful? Yes No
Verified answer

Srini007 3,483 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Subodh-Gupta

Can you share the screenshot of the Create HTML table action including values you are passing

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Cheers,

Srini

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Subodh-Gupta

You should use the expression provided by @Srini007 in Create HTML Table action itself , see below

This is excel file used for demo flow purposes

This is flow designed to send html table

Expression -

formatDateTime(item()?['Date'],'yyyy-MM-dd')

Expression -

formatNumber(float(item()?['Currency']),'#.00')

Now use send email

Expression (to add border to table)

replace(body('Create_HTML_table'),'<table>','<table border="1">')

Now see the result

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Srini007 3,483 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Subodh-Gupta

Currently you are passing the values directly without any expression in create html table action, so to format you have to place the expression as above post inside the create html table

So that you can get desired output

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Cheers,

Srini

Was this reply helpful? Yes No
Subodh-Gupta on at

Like (0)

Report
Copy link

Link copied!

Many thanks Srini, Finally it worked..

Was this reply helpful? Yes No
Subodh-Gupta on at

Like (0)

Report
Copy link

Link copied!

Many thanks Nived, It worked.. 🙂
I have one more query, how i can align right the Amount column

Was this reply helpful? Yes No