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

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

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

ersula82
Level: Powered On

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

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,011)