cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Rob_CTL
Level: Powered On

Formatting HTML table - replacing values?

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

 

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

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

 

View solution in original post

Rob_CTL
Level: Powered On

Re: Formatting HTML table - replacing values?

Brilliant, thanks @v-yuazh-msft

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,460)