Answered

How to change the date format of the html table data

(0) Share

Report

Posted on by MIA27

I made the html setting as below and code which i copied from the peek-code, whcich also I have pasted, the data is coming from sharepoint date field, which is Date long.

I want to date to appear as "dd-mm-yyyy" in the output.

Please advise what correction and on which screen, Confused to be done on the Create Html Table screen or on the html code screen.

====================

{

"inputs": {

"from": "@outputs('Get_items')?['body/value']",

"format": "HTML",

"columns": [

{

"header": "RecordNo",

"value": "@item()?['ID']"

{

"header": "ServiceDate",

"value": "@item()?['SvcDate']"

{

"header": "Model",

"value": "@item()?['Model']"

{

"header": "SerialNo",

"value": "@item()?['SerialNo']"

{

"header": "Mach-SMR",

"value": "@item()?['SvcSMR']"

{

"header": "AssetNo",

"value": "@item()?['AssetNo']"

{

"header": "JobDone",

"value": "@item()?['JobCategory']"

}

]

"metadata": {

"operationMetadataId": "3e291b08-5ca9-434a-8082-447671132ede"

}

==============================================

My output is as below :

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

David- 1,254 on at

Like (1)

Report

You would use the expression formatDateTime([your field], 'dd-mm-yyyy')

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Dear Mr. David,
Where to apply?. you mean in the html code view. could you please show more details by picking my line of my code,

Was this reply helpful? Yes No
David- 1,254 on at

Like (1)

Report

You would use the expression in the value column of the create HTML table action instead of the actual field.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Applied and found red font (I think its error)

Was this reply helpful? Yes No
David- 1,254 on at

Like (0)

Report

You can choose your field by switching to Dynamic content in the expression builder. It will then input something like item()?['SvcDate'] into your expression once you select the field. You can see these values in the fields you listed in your original post.

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report

Sorry unable to understand. you mean I should put the expression as below :

Still it is showing red.

Please note, the image i posted is the actual flow. But I am testing on another Inquiry records, Just to check the date.
issue is how to make the date is short to dd-mm-yyyy

please advise what changes more to be done.

Was this reply helpful? Yes No
Verified answer

David- 1,254 on at

Like (1)

Report

Yes, that is where you would want to put the expression. However, you have not formatted it correctly, which is the cause of the error. You need to format it like:

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

Note the placement of the quotes around the date format compared to what you entered.

Was this reply helpful? Yes No