I seem to be having trouble with adding events to outlook from a sharepoint calendar/list.
My SP list is in a gallery. I have a button on each gallery item to add that event to outlook. initially I tried;
Office365Outlook.V4CalendarPostItem(LookUp(Office365Outlook.CalendarGetTablesV2().value,name="Calendar").id,
ThisItem.Title,
ThisItem.'Start Time',
ThisItem.'End Time',
"(UTC) Coordinated Universal Time")
but get the error 400: string was not recognised as a valid date time.
I found another post suggesting the start and end dates should be formatted different, so tried this;
Select(Parent);
Office365Outlook.V4CalendarPostItem(LookUp(Office365Outlook.CalendarGetTablesV2().value,name="Calendar").id,
ThisItem.Title,
DateValue(Text(ThisItem.'Start Time'))+Time(Value(Left(ThisItem.'Start Time',2)),Value(Right(ThisItem.'Start Time',2)),0),
DateValue(Text(ThisItem.'End Time'))+Time(Value(Left(ThisItem.'End Time',2)),Value(Right(ThisItem.'End Time',2)),0),
"(UTC) Coordinated Universal Time")
unfortunately I get the same error.
Below I have added two text boxes showing the date format from the second attempt.

can anyone help?