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!
@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
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?
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!
@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.
@Anonymous
I would suggest creating a new topic with your specific issue, including everything you wrote here, and adding what output you are getting after each of your attempts:
Are you getting errors in the flow or is it that the output is not what you want?
Also, include screenshots of your flow (your addDays action block, for example).
At first glance, I think I can say with certainty that formatDateTime() will not work here, as it requires the date being formatted be in a string format, so passing in the integer format from excel will not work with that expression.
It might be your reference to your data. If you're pulling from an excel table, then you're probably inside of an "Apply to each" loop, in which case you should use the items() expression passing in the name of the loop rather than body() passing in the name of the "Get Rows" action block.
Starting a new topic will give you a greater chance of receiving a response from someone who can help you in the forums, rather than responding to a topic that already has a solution.
thanks,
Kyle
This does not work for me. I have two dates in excel that I am trying to pull into an email using Power Automate. I have tried using the formatDateTime expression and the addDays expression and neither are working for me.
Currently if I try to just pull the date from the excel document and put it in the email it just returns a number like 44003 or something close to that.
Here's some of the things I have tried:
formatDateTime(int(body('Get_a_row_after_updates')?['When will the student licenses be installed?']), "d MMM yyyy") - I've also tried this without the int.
Why will none of these work?! It's the last thing I need to do for this flow. It should not be this hard!
@ScottShearer, thank you!
I have been looking everywhere trying to figure out how to add AM/PM to the timestamp...
Those two little t's at the end did the trick! thank you!
#1
WarrenBelz
146,662
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (