Answered

Formatting Date And time in MS Flow

(2) Share

Report

Posted on by Community Power Pla...

I am running into a problem when trying to get the date/time out of a column. I need it to display what is in the column and cant figure out how to format it in Flows. Attached is the issue and my flow. I need it to read the date/time in a mm/dd hh:mm AM/PM. any help will be greatly appreciated!

Flow 2.PNG Flow 1.PNG

Categories:

General topics

I have the same question (0)

All responses (26)

Answers (2)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (14)

Report

@Anonymous- give this a try:

I used this format ina an expression:
formatDateTime(utcNow(),'MM/dd hh:mm tt')

Which produced a date/time string that looks like this:
07/20 08:08 PM

If this works for you, please mark you Post as Solved.

Scott

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

Like (0)

Report

Worked like a charm! Thank you so much!

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

Like (0)

Report

It worked once and then quit and went back to sending the way it was 😞

Was this reply helpful? Yes No
Verified answer

jaylou 241 on at

Like (14)

Report

HI Kamel,
If you are still having an issue with formatting the date, have you tried to use "Convert Timezone"? I convert all dates before I send them in an alert. There are many formating options for you to choose.

Hope this helps,
Joe

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

Like (0)

Report

Greetings

I tried this :
formatDateTime(utcNow(), 'MM/dd hh:mm:tt')

To update dates and times for Form submited for approval , however it shows todays's date and I am trying to show the dates from the form submitted , how can I format this dates so it shows the right format when email is received for approval ?

Was this reply helpful? Yes No
RBoneck 415 on at

Like (1)

Report

formatDateTime( [your date here] , 'MM/dd hh:mm:tt')

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

Like (0)

Report

I'm building a flow that would notify certain users when dates are changed. I did the following:
1. I created 2 hidden fields: Old Start date and Old End date (Date and Time fields in Sharepoint Events List).
2. In my flow, I convert all four fields (Old and New Start dates and End Dates) from UTC to NZST with format mm/d/yyyy h:mm AM/PM.
3. I check:
A. New and Old Start dates are equal, and
B. New and Old End Dates are equal
If false, Sharepoint sends an email to users that these dates have been changed.
4. The item is updated to populate the Old Start and End dates with the values from the New Start and End dates.

My problem is whether I use the New or the converted values to update the Old value fields, the values returned to Sharepoint turn out differently from the unconverted values.
Is there any way to fix this?

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

Like (2)

Report

This is how I fixed time zone in my flow .
1. Started my flow with the action, in this case is when an item is created in sharepoint list ,
2. I added Convert time zone action after one for the start date and another for the End time
Here is how it looks

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

Like (1)

Report

Thanks, but strangely, it's working now.

I removed all the conversions and just used the fields themselves. I think there's just a delay in displaying the changes to the Old and New Start dates in Sharepoint. And I think the only mistake I had in the first place was having "Date and Time" format for the New dates, and the "Date only" format for the Old Dates. After aligning those formats, I started adding the conversions and other stuff in it and the delay didn't help either.

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

Like (0)

Report

I'm using the Convert Time Zone action but it does translate the days names from my language to english automatically.........

Was this reply helpful? Yes No