web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Formatting HTML table ...
Power Automate
Answered

Formatting HTML table - replacing values?

(0) ShareShare
ReportReport
Posted on by

Hi,

 

This might be a silly question but is there a way of replacing the value in the HTML table?  Let me explain a bit more, I've got a flow that generates a email that shows the following days calendar bookings from a SharePoint calendar, with the excellent help I was given in this thread I've almost got a workable solution.

 

The issue I still have is that events that are set as "All day events" show a start time of 1am in the email:

 

emailresult1.jpg

Is there something I can do with the magic of flow that'll look for that 1am value and change it to "All Day" within the HTML table.  I've been messing about with putting a replace expression within a Compose step but i could get that to work.

 

emailnotificationflow.jpg

 

As a side note. is there any customisation that can be done to the HTML table i.e. borders, colours etc?

 

As usual, thanks in advance!

 

Rob

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-yuazh-msft Profile Picture
    Microsoft Employee on at

    Hi @Rob_CTL,

     

    Please refer to screenshot below to create the flow:

    Capture.PNG

     

    The expression of the Start should as below:

    @if(equals(convertTimeZone(item()?['EventDate'],'UTC','Central Standard Time','t'),'1:00 AM'),'All Day',convertTimeZone(item()?['EventDate'],'UTC','Central Standard Time','t'))

    The flow would run succesfully as below:

    Capture.PNG

     

    Best regards,

    Alice

     

  • Rob_CTL Profile Picture
    on at

    Brilliant, thanks @v-yuazh-msft

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 632

#2
Haque Profile Picture

Haque 458

#3
Valantis Profile Picture

Valantis 357

Last 30 days Overall leaderboard