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.