I'm getting items from a Sharepoint List and emailing those items in an HTML table. The problem is that one of those items is a date which is formatted in a different time zone. I need to take the date and re-format it into Central Time Zone so that it makes sense to the email recipient. I put in a convert time zone action but it's not allowing me to grab that converted time zone in the next action to update the html table. I've managed to convert the time zone for the subject of the email but not the contents therein. I've read a few blog posts but cannot get it to work. Please HELP!
Hi @ersula82,
Please try to use the ConvertTimeZone function in the action Create HTML table to format the date time instead of using the action ConvertTimeZone.
I have made the following flow for testing, the code I used is:
convertTimeZone(item()?['Date'],'China Standard Time','Central Standard Time')
Screenshot for your reference:
More details on Convert Time Zone, please check it at here:
Best regards,
Mabel
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
12 | |
9 | |
7 | |
7 | |
7 |
User | Count |
---|---|
20 | |
18 | |
17 | |
12 | |
7 |