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:
Not useful for us Europeans and the time doesn’t help either for users.
Here’s how to fix it.
- 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.
- Go to Flow. In my version I have it set so that an email is sent on a new list item in SharePoint.
- Add an action (using the + symbol) before the email part.
- Type in ‘compose’ for the search and choose ‘Data Operations – Compose’.
- Add your date string from above. You can rename the action if you want. The default is ‘Compose’.
- In the body of the email, add the Output from the Dynamic content area to the relevant place.
- Save and update the Flow. Test it and your date in the email should be in the UK/Euro format.
Hope you found it useful.