Forum Discussion
'When an appointment is updated' Automate trigger ID different than 'When an appointment is created'
Have tested this a few times now for sanity sake.
I am writing entries to a SharePoint list using the MS Booking 'ID' field as primary key via Power Automate. When using the 'when an appointment is updated' trigger to update items in the list per changes to the appointment in Bookings, it is impossible to match the item being updated to the entry in SharePoint because the IDs do not match - 'when an appointment is updated' generates a new ID with every call. SelfServiceAppointmentId does not have this problem but we do not use the self service booking option and cannot due to our workflow requirements. Is this by design? Shouldn't there be a persistent ID associated with the bookings made in calendar/backend?
Please help!
10 Replies
Vignesh_KailasMicrosoft
Jpownall17 SelfServiceAppointmentId can be used as unique id across flows for an appointment (whether or not yours is an appointment created via self service page). This is a naming/documentation miss from your side and will be rectified soon.
Can you please use the same and let us know if that works for you well?
Ueberschussladen Isabel2380 as well FYI.
Vignesh_Kailas
When I create an appointment in the backoffice of Bookings I get a selfserviceappointmentid like00000000-0000-0000-0000-000000000000
When using the frontoffice (reservation page) the selfserviceappointmentid is unique and can be used.For now I can not find a unique ID to make sure the correct appointment is updated or cancelled if the original appointment was made in the back office of Bookings.Any ideas would be appreciated.Thanks in advance.- Vignesh_KailasKenneth_De_Vos: This is something that was fixed very recently and is being rolled out now. We expect this to take effect in the next 4-5 weeks - The all 0s will be the case when you make a booking for a service w/o teams meeting from the C1 page/Calendar surface.
- Thanks, it works great for 1:1 bookings. I have big problems with 1:n bookings. The 2nd new booking of a "1:n" appointment is updated via the connector "When appointment is updated". This also applies to corrections and cancellations. Since I want to view the information in PowerApps through SharePoint, the process becomes very complicated. It would be helpful if additional information could be sent via the connector "If an appointment is updated" when booking a 1:n appointment. For example: [Appointment: "New", "Update" or "Cancel"]. Thanks very much!
- Vignesh_KailasIf I understand this correct (please correct otherwise), you are expecting the new slot booking (2nd one onwards) in a 1:N appointment to come as a part of "When an appointment is updated" with a flag/field mentioning that it is a new slot added and not any update (like reschedule or staff change etc).
I'm having the same issue. I trying to automate a list in sharepoint, and I need the Booking ID, no the unique ID of this transaction showing now with the current conector.
I have the same problem. it's missing a unique mapping to allow me to update or delete the sharepoint item.
