set the richt time

[frixel]

I created a Flow to count emails that received in the inbox and that works well.
Only the time received from the email does not correspond to the actual time that the email was received.

How can I get that in the flow like as 06-05-2019 08:18:12?

[v-bacao-msft]

Hi @frixel ,

You could use formatDateTime() function to change Received Time into the expected format.

If Received Time you inserted in the Excel table is from Get emails, use the following Expression:

formatDateTime(items('Apply_to_each')['DateTimeReceived'],'dd-MM-yyyy HH:mm:ss')

If Received Time you inserted in the Excel table is from the trigger-When a new email arrives, use this Expression:

formatDateTime(triggerBody()?['DateTimeReceived'],'dd-MM-yyyy HH:mm:ss')

Please take a try.

Best Regards,

[frixel]

Hi @v-bacao-msft 

Thanks for your reply.

When i do what you sugested then the time is 2 hours after the realy mail was received.

[v-bacao-msft]

Hi @frixel ,

It is recommended to set this field to the text type.

Excel will automatically change the field type according to the data, so it is best to set the type of the field in advance.

Please take a try.

Best Regards,

[frixel]

Then i have this.

[v-bacao-msft]

Hi @frixel ,

Yes, this is normal because Excel file stores Date with number.

You can delete this line and retest your Flow.

Regards,

[frixel]

Hi @v-bacao-msft 

See i have set as Text and empty al the rows and set the power og flow off and on.

The new row is again a time of 2 hours earlyer then the mail received.

[v-bacao-msft · Accepted solution]

Hi @frixel ,

Please try this Expression:

addHours(triggerBody()?['DateTimeReceived'],2,'dd-MM-yyyy HH:mm:ss')

Regards,

[frixel]

Thanks, this is resolved.

[v-bacao-msft]

Hi @frixel ,

If your problem has been resolved, please click "Accept as Solution" and mark the post as solved.

Best Regards,