Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Formatting Date And time in MS Flow

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.PNGFlow 1.PNG

Continued Contributor
Continued Contributor


Are you using Excel Online? From what I understand Excel Online will return the date column as plain numbers rather than dates. Possible to use "regular" Excel instead?

@CarlHRVA I did solve it but it was by using an expression in a Compose component and then using that output in the email. Unfortunately using regular excel is not really an option for this case. I posted it in a separate post, and I elaborated on the answer there. @kdavis91 and @ManishJain helped me get there and have some more info.

New Member

formatDateTime(utcNow(),'MM/dd/yyyy hh:mm tt')

You saved me hours of research 🙂 I can't believe after all that thinking and searching I saw this lol. 


I also needed my other output in yyyy-MM-dd format and it was not listed in the drop down values it provides so I just typed it in the format I needed under custom and voila! It worked. 


Thanks again!


time conversion.PNG

New Member

Dear All,


i am trying to build a flow where 24hr before the flow should initiate email provided in excel.




I have tried multiple options but not a success.....can you please guide me?

Continued Contributor
Continued Contributor

@Vipul2021 , where are you having an issue?


could you please provide a summary of the options you have tried?


also, it may be more appropriate to start a new thread rather than using this one if your question is more than just about formatting date/time.




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,598)