cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ersula82
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
v-yuazh-msft
Community Support
Community Support

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

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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (31,641)