Displaying User Friendly Timestamps when working with Power Automate and SharePoint Online

When implementing Approval Workflows using Microsoft Power Automate (aka Flow) and SharePoint Online, a typical requirement is to capture an approval comment indicating who approved an item and when using a Timestamp.

This Timestamp is great for machines and techies, but not so great for End Users to read!

In this quick video, we'll explore how you can convert UTC timestamps to human readable timestamps, and in the correct time zone!

Your can grab a copy of the Expression referenced in the video below - be careful with those ticks! :-)

formatDateTime(convertTimeZone(UtcNow(),'UTC','EasternStandard Time'),'f')

28 views0 comments