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!
Solved! Go to Solution.
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.
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.
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?
@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.
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.