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.
Hi @ nikelly,
Please take a try to add a "Select" action before the "Create HTML table" inside your flow as screenshot below:
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.
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.
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:
Please have a try an let me know if it help.
Check out the announcement of Power Platform content at Microsoft Ignite!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021