Forum Discussion
How do I formatDateTime a Select value from SharePoint List?
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 -> C...
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')