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

Format HTML Table and dates

I've tried many different avenues to get my HTML table centered and formatted nicely but nothing is working so I need a little help. 

 

I have created a flow to grab only today's dated items from a sharepoint list from the 'created' column . Then the flow puts the information in an HTML table and creates an HTML file. I'm going to be working on converting that HTML file to a PDF and then emailing it but I'm still working on that part.

 

The issues I need help with are as follows:

1. The table needs to be centered on the page 

2. The checkin/checkout dates need to be MM/dd/yyyy 

 

The expressions in the flow are as follows:

Sharepoint Get Items
startofday(utcNow(),'yyyy-MM-ddTHH:mm:ssZ

Create HTML table
convertTimeZone(item()?['Created'],'Pacific Standard Time','Central Standard Time','t')

Compose
replace(body('Create_HTML_table'),'<table>','<table border="1">')

Create file
formatDateTime(body('Current_time'),'d')

 

I have tried a lot of different formulas and cannot get it to work. Please help!

 

Capture1.PNG

 

 

 

 

 

 

 

 

pic1.pngpic2.pngpic3.png

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Format HTML Table and dates

Hi @ersula82,

 

Could you please share more details about your issue about what couldn't be achieved when the flow runs?

Could you please share more details about your requirement?

 

Please share more details so we would try to provide a proper workaround for you.

 

Best regards,

Alice

Highlighted
Helper III
Helper III

Re: Format HTML Table and dates

Hi @v-yuazh-msft,

 

  1. I cannot get the date to be formatted as MM/dd/yyyy
  2. I cannot get the HTML table to be centered on the page

See screen shot below:

 

Capture2.PNG

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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!

Top Solution Authors
Users online (5,281)