cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

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
Highlighted
Community Support
Community Support

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
Highlighted
Community Support
Community Support

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

Highlighted

Brilliant, thanks @v-yuazh-msft

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,043)