Re: Format time in HTML table - Page 2

ThomasH · ‎09-08-2022

Hello, I am having an HTML table created with a date, but I would like the date to be formatted differently so that it is displayed in German format as DD-MM-YYYY, how can I achieve this. In addition, if the date is greater than the current date, I would like it to be colored or highlighted in red, how could I implement this? Thanks

Paulie78 · ‎09-27-2022

In the email you should not be using the output of the HTML table. But the output of the compose action which replaces the special characters.

ThomasH · ‎09-27-2022

@Paulie78 I have update my last Post ,

i use in the Outlook Body this

this is from the compose.

The Email contains this

Is this right?

ThomasH · ‎09-30-2022

@Paulie78 Hi,

can you tell me what my fault?

Paulie78 · ‎09-30-2022

I cannot see where you have gone wrong easily. But if you want I will take a quick look for you on teams. I am sure we can sort it out within a few minutes. Send me a PM if you want to do that.

ThomasH · ‎10-01-2022

@Paulie78 I have write you a PM

Thank you

ThomasH · ‎10-28-2022

Hello, unfortunately I still could not solve the problem.

I use the code of @Paulie78 from Post 19 to create the HTML Table

if
(
  greater(if(equals(item()?['dueDateTime'], null), '', formatDateTime(item()?['dueDateTime'],'dd-MM-yyyy')), utcNow()), 
  concat('<span style="color:red">', item()['dueDateTime'], '</span>', item()['dueDateTime']),
  if(equals(item()?['dueDateTime'], null), '', formatDateTime(item()?['dueDateTime'],'dd-MM-yyyy'))
)

but the "Fällig" dosen't be red if the Value is greater then today.

In the next step "Verfassen" i use this code from @Paulie78 from Post 10

replace(replace(replace(body('HTML-Tabelle_erstellen'), '&lt;', '<'), '&quot;', '"'), '&gt;', '>')

and then i create my Email

with this code

<html>
<head>
  <style> 
table, th {
    border:1px solid black;        
}
td {
    border:1px solid black;
    text-align:left;
    width:20%;
}
  </style>
</head>
<body>
@{outputs('Verfassen')}<br>
<strong>Bearbeitungsstatus:<br>
0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=Nicht begonnen<br>
50 &nbsp;&nbsp;&nbsp;=in Bearbeitung</strong><br>
<strong>100 = Abgeschlossen</strong><br>
</body>
</html>

"Ausgabe" is from "Verfassen"

then i become a Email, but as I wrote, the due date is not marked in red if the date is later than the current date and the individual fields in the table are not filled correctly as can be seen in the picture.

Who is my fault, and how i can correct it?

Thank you for your help.