Oct 31 2022 12:14 AM
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!
Nov 22 2022 01:05 AM
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.
Nov 23 2022 09:31 AM
I have the same problem. it's missing a unique mapping to allow me to update or delete the sharepoint item.
Dec 07 2022 12:33 AM - edited Dec 07 2022 12:34 AM
@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.
Jan 29 2023 07:46 AM
Jan 29 2023 08:59 PM
Jan 29 2023 11:34 PM
Thank you for quick response!
Example: There is a 1:N date (fixed date) for a seminar. The first customer to log in is displayed via Connector "When an appointment was created".
The second customer, as well as all subsequent customers who register for exactly this appointment, are displayed via the connector "When was an appointment updated". If a customer has canceled their appointment, this is also displayed via the "When an appointment was updated" connector. This customer is missing from the detailed list of the JSON object. If an already registered customer has his phone number about a correction (rebooking), the information also comes via the connector "When an application was updated". An additional label with the name "customer of 1:N is:" : "new", "updated" or "cancelled" is helpful. I can then use the SelfserviceAppointmentID to search, change or add the item in the SharePoint list.
Jan 30 2023 12:42 AM
Feb 08 2023 07:28 AM
@Vignesh_Kailas
When I create an appointment in the backoffice of Bookings I get a selfserviceappointmentid like
Feb 08 2023 08:47 AM
Feb 08 2023 11:36 PM