Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
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

 

 

  • Rob_CTL Profile Picture
    on at
    Re: Formatting HTML table - replacing values?

    Brilliant, thanks @v-yuazh-msft

  • Verified answer
    v-yuazh-msft Profile Picture
    on at
    Re: Formatting HTML table - replacing values?

    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

     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >