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
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'), '<', '<'), '"', '"'), '>', '>')
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 =Nicht begonnen<br>
50 =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.
Helpful resources
Power Automate News & Announcements
Keep up to date with current events and community announcements in the Power Automate community.
Community Calls Conversations
A great place where you can stay up to date with community calls and interact with the speakers.
