Hello,
I am currently working on a reservation system, once reserved an email will be sent with their reservation details and an event will be posted on their Outlook calendar, however, they can reschedule it but I am having issues on how to edit the event posted on their calendars. New schedule will be coming from a date picker and a time picker using a dropdown.
Here is the sample of my code:
With({idCalendarEntry:
First(
Office365Outlook.GetEventsCalendarViewV3(
EventID,
Text(DateTimeValue(ThisItem.'Start Date' & " " & ThisItem.'Start Time'), DateTimeFormat.UTC),
Text(DateTimeValue(ThisItem.'Start Date' & " " & ThisItem.'End Time'),DateTimeFormat.UTC),
{search:"Welcome to the GreenPod, "& txtClientName.Text &"!"}
).value
)
},
Office365Outlook.V3CalendarPatchItem(
EventID,
idCalendarEntry.id,
"Your reservation has a new schedule!",
Text(DateTimeValue(dpEditStartDate.SelectedDate & " " & drpEditStartTime.Selected.Value), DateTimeFormat.UTC),
Text(DateTimeValue(dpEditStartDate.SelectedDate & " " & drpEditEndTime.Selected.Value), DateTimeFormat.UTC),
{Body:"Please be reminded of your new schedule"}
);
Hi @VinChua ,
Please refer to the official doc and get more details about this connector:
Office 365 Outlook - Connectors | Microsoft Learn
One more thing I need to know is where is the update event button? It seems the button is inside a Gallery because there are ThisItem in your formula. But if you only want to update a specific event, the button would be independent on that screen and use below formula:
Office365Outlook.V3CalendarPatchItem(
CalendarID,
idCalendarEntry.id,
"Your reservation has a new schedule!",
Text(DateTimeValue(dpEditStartDate.SelectedDate & " " & drpEditStartTime.Selected.Value & " " & Radio.Selected.Value), DateTimeFormat.UTC),
Text(DateTimeValue(dpEditStartDate.SelectedDate & " " & drpEditEndTime.Selected.Value & " " & Radio.Selected.Value), DateTimeFormat.UTC),
{Body:"Please be reminded of your new schedule"}
)
Best regards,