Jun 26 2017 10:23 AM
I have a SharePoint list which I'm retrieving daily at 4pm. I'm filtering out the items I need and then adding them to an HTML table to send out via email:
Recurrence -> Get Items -> Select -> Create HTML Table -> Send EMail
The problem I have is that one of the fields is a datetime field and is showing UTC time when it should be showing daylight savings time (or local time).
How can I format this field so that it shows the correct value in the HTML table? I tried adding the formatDateTime (which might do it?) to the Select, but it appears that is just expecting a JSON object, and not recognising functions.
Any thoughts on how I can parse that JSON and replace the datetime values with formatted date time values greatly appreciated.
Many thanks.
Jun 27 2017 03:38 AM
OK, so I've managed to get the formatdatetime function to work, but it is still showing the UTC date time and not the local date time. Any thoughts? I just want to show the actual date time in the email I send!
This is the function I'm currently using:
@formatdatetime(item()?['MeetingStart'],'r')