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

Notifications

Announcements

Community site session details

Community site session details

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

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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard