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.
Thanks again!
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?
@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.
thanks,
Kyle
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.
User | Count |
---|---|
44 | |
18 | |
15 | |
14 | |
13 |
User | Count |
---|---|
74 | |
36 | |
29 | |
20 | |
19 |