cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nikelly
Frequent Visitor

Convert Time in HTML Table

Is there any way to add a converted time zone to a generated HTML table? I've tried with the Convert Time Zone trigger, ConvertFromUTC() expressions, and I can't seem to get any of them to show as available dynamic variables in the HTML table.

 

I've tried storing it in variables, but it adds all the converted times to each row instead of just the single converted time.image.png

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

Hi @ nikelly,

 

Please take a try to add a "Select" action before the "Create HTML table" inside your flow as screenshot below:

Capture.PNG

 

You could use the expressions in the "Select" action to convert the time,and create the HTML table fron the Output of the "Select" action.

 

 

Please let me know if it help. 

 

Regards,
Alice Zhang

Select doesn't seem to work for this particular solution. Since i'm pulling dynamic content from Dynamics Online, when I create the convertFromUtc() expression, it doesn't show all the possible values from Dynamics. Capture.PNG

Hi @ nikelly,

 

The dynamic content from Dynamics Online maybe not shown in the possible values from Dynamics,

Howeever, you could  insert the expression of the Dynamics content manually.

For example, the expression of the "Start Date" inside the Apply to each would be:

item()?['Start_x0020_Date']

 

 

Please have a try an let me know if it help. 

 

Regards,
Alice Zhang

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Top Solution Authors
Users online (2,192)