Microsoft flow Send an email showing wrong time for SharePoint list column

In this Microsoft Flow Tutorial, We will discuss an issue of incorrect time displaying at the time of sending an email alert notification. We will see why Microsoft flow Send an email showing wrong time for the SharePoint list column.

Send email shows wrong time in Microsoft Flow

I have a SharePoint List named “Access Registers“. This list has some columns with different data types. Within that, It has a Date Picker column including the Time.

As per my requirement, in the SharePoint List, When the item will create and the temperature (one of the column names) will above a certain value, then the flow will trigger and HR will get an email alert notification.

In the below screenshot, you can see the submitted item (Preeti) is having a Date (7/3/2020) with Time value as (4:23 AM).

Incorrect time showing at the time of sending mail in microsoft flow

But at the same time, an alert flow is triggering and HR is getting an email notification as shown below.

Here you can see, the time is showing as incorrect value that does not match with the created list item Date Time (In the above screen).

flow email shows wrong time for datetime SharePoint list
Microsoft flow Send an email showing wrong time for SharePoint list column

Microsoft flow send an email showing wrong time

To resolve this type of wrong time issue in Microsoft Flow Send an email, follow these below steps:

Step-1:

In the Microsoft flow, Add an action named “Convert time zone“. This action has some below fields as:

  • Base time: Click on the Expression tab -> Enter utcNow() function -> Click on Ok
  • Format string: It specifies which type of DateTime format you want to display in your email notification. Select the Date/Time pattern from the drop-down selection.
  • Source time zone: Select the time zone of your Source place.
  • Destination time zone: Select the time zone for your Destination place.

You can refer the below screenshot.

email from flow shows incorrect time format

Step-2:

Go to the Send an email action. Choose the Date value as “Converted time” under the Dynamic content section and Save the flow.

Now again create an item in the SharePoint List and run the flow. Then in the Email notification, you can see the Date Time format will appear with the exact Destination value (including a perfect string format).

send email shows wrong time in microsoft flow

Also, you may like these below Microsoft Flow Tutorials:

In this Microsoft Flow Tutorial, We discussed how to resolve Microsoft flow Send an email showing wrong time for the SharePoint list column.

>