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.