Answered

Formardatetime sending email with different data from form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Greetings

I tried to format date and time from the email received from approval, however, the dates and times are different from the form submitted for approval

I am happy with the format however I want to know what am I missing as the information displayed is not the same

formatDateTime(triggerBody()?['Start_x0020_Date_x0020__x0026__x'],'MM/dd hh:mm:tt')

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

AlanPs1 2,471 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Here is a nice way to test these things and the results from what I have done below:

Results:

If you recreate this and bring in a non UTC format it looks to give diferent results. This may shed some light on the results you are getting. What I normally do with non standar date formats is convert them to the long format before formatting them.

More information on Date and time functions here - https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#date-and-time-functions

If you have found my post helpful, please mark thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi

I tried different formats and like MM/dd/yyy hh:mm:tt how ever the data placed in form does not resemble what is shown in the approval email. How can I transfer that information to the email ? see example below of what its happening

I am getting :

From;
03/07/2019 07:00:PM
To :
03/07/2019 08:00:PM

when the information entered in form is : ( so when this information is entered the times are inaccurate)
Start Date and time : 3/7/2019 11:00 AM
End Date and time : 3/7/2019 12:00 PM

USING THIS :
formatDateTime(triggerBody()?['Start_x0020_Date_x0020__x0026__x'],'MM/dd/yyyy hh:mm:tt ')
formatDateTime(triggerBody()?['End_x0020_Date_x0020__x0026__x00'],'MM/dd hh:mm:tt')

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I was able to find the solution

Under expresion :

convertFromUtc(triggerBody()?['End_x0020_Date_x0020__x0026__x00'],'Pacific Standard Time','MM/dd/yyyy hh:mm:tt')

Was this reply helpful? Yes No