Formatting Date And time in MS Flow

[Anonymous]

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!

[CarlHRVA]

@Anonymous

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?

[Anonymous]

@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. @Anonymous and @ManishJain helped me get there and have some more info.

[Mrmus]

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

[RickB]

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!

[Anonymous]

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?

[Anonymous]

@Anonymous , 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.

thanks,

Kyle

[ayushch]

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

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

formatDateTime( [your date here] , 'hh:mm tt') hour minute am/pm