Change date format in Microsoft Flow emails

Microsoft Flow the workflow engine in Office 365 is constantly evolving and changing. And it also throws up a few curveballs every now and then.

One of them is date formats and how they appear in emails. The default is US format and so if you have a Flow with a created date from a SharePoint list, it would appear in a generated email like this:

Date: 2017-06-02T11:29:03Z

Not useful for us Europeans and the time doesn’t help either for users.

Here’s how to fix it.

  1. In your SharePoint list find the name of the date column you are using. In this case mine is called ‘Submitted date’.
     »» Continue reading