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’. In the string below you have to add ‘_x0020_’ for the blanks in the column name. Make sure that ‘MM’ is in capital letters too and you have double quotes.

“@formatdatetime(triggerBody()?[‘Submitted_x0020_Date’],’dd/MM/yyyy’)”

  1. Go to Flow. In my version I have it set so that an email is sent on a new list item in SharePoint.
  2. Add an action (using the + symbol) before the email part.
  3. Type in ‘compose’ for the search and choose ‘Data Operations – Compose’.
    Microsoft-Flow-UK-date-formats-compose
  4. Add your date string from above. You can rename the action if you want. The default is ‘Compose’.
  5. In the body of the email, add the Output from the Dynamic content area to the relevant place.
    Microsoft-Flow-UK-date-formats
  6. Save and update the Flow. Test it and your date in the email should be in the UK/Euro format.

Microsoft-Flow-UK-date-formats-final

Hope you found it useful.