I'm looking to change the date format of a flow that takes start time and end time of an outlook calendar event and adds into a table in an excel spreadsheet.
This currently imports in this format 2020-02-07T16:00:00. I need this in just a date format like dd/mm/yyyy. I know I need a formatdatetime expression but not sure what this would be. Below is how far I am. Someone suggested "formatDateTime(triggerBody()?['DateTimeReceived'],'MM/dd/yyyy')" on a similar issue but this was for an email recieved trigger and not a event created. Can anyone help? Thanks!
Solved! Go to Solution.
Although the formula below is working it will not put the date format as dd/MM/yyyy.
Tried this and still no luck. dd/MM/yyyy is still importing into the spreadsheet as MM/dd/yyyy. I've tested this a few times and the issue seems to present when the dd has a zero in front so any dates 01-09.
I am having a similar issue with the date. I am trying to grab the outlook calendar once a month and write each event to a row in Excel, instead of when the event is created. I am getting an error message though and wondering if there is something I need to change in formatDateTime(triggerBody()?['end'],'dd/MM/yyyy' to make it match what I am trying to do?
I am getting this error
You are trying to format the trigger end body which is null hence you getting this error. Make sure you have the value for the end date.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!