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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,672)