Format currency/date column in html table

Like (0) Share

Report

Posted on 16 Nov 2022 08:21:59 by drewbty

I am running a database Stored Procedure

from that resulting dataset, I create a html table, with automatic columns selected

that html table then gets some CSS table styling

and the final table then gets sent in an email

Everything works fine except for the fact that the 3 currency columns in the table aren't formatted to display that, along with a date column which is an ugly format from the database.

Should I add a Compose step somewhere? How can I use that to access a particular column inside my html table to format numbers/dates?

I have the same question (0)

Summarized by AI

All responses (5)

Answers (1)

Ajinder31 530 on 16 Nov 2022 at 09:15:26

Like (0)

Report

Re: Format currency/date column in html table

Hi @drewbty , Can you please share the values received and required formats for both date and currecny fields?

--------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
drewbty 74 on 16 Nov 2022 at 09:38:59

Like (0)

Report

Re: Format currency/date column in html table

Example of output from stored procedure.
Stake and Payout should be to 2 decimal places and include a $ sign. Client DOB should change to dd/mm/yyyy.
Not that this is just an example of one {} within the array. But there are many. All of them have the same column headers.

{
"Table1": [
{
"Match": "xxxxx v xxxxx",
"Market": "xxxxx",
"Outcome": "xxxx",
"Stake": 194.7,
"Price": 1.95,
"Payout": 254.7,
"Client First Name": "xxxxx",
"Client Surname": "xxxx",
"Client Suburb": "xxxx",
"Client State": "xxxx",
"Client Phone": "000000000",
"Client Mobile": null,
"Client Email": "xxxxxx@gmail@gmail.com",
"Client DOB": "1989-03-10T00:00:00"
},

Was this reply helpful? Yes No
drewbty 74 on 16 Nov 2022 at 09:41:56

Like (0)

Report

Re: Format currency/date column in html table

Edit

Was this reply helpful? Yes No
Verified answer

Ajinder31 530 on 16 Nov 2022 at 09:55:30

Like (0)

Report
Re: Format currency/date column in html table

Hi @drewbty , Please try below expressions

1. For Currency field. eg. Price
formatNumber(item()?['Price'], 'C2')

2. For DOB field
formatDateTime(item()?['Client DOB'], 'dd/MM/yyyy')

--------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
drewbty 74 on 16 Nov 2022 at 10:14:08

Like (0)

Report

Re: Format currency/date column in html table

Excellent solution, thanks!

Was this reply helpful? Yes No