Whilst Bookings is a nice off the shelf platform for managing appointments, it has a lot of limitations, especially when trying to automate some of the processes. Unfortunately, my organisation is still trying to figure out how Power Apps should be implemented so I cannot use that to overcome the shortcomings of Bookings.
One of our Bookings pages is for external applicants that have already completed some stages of the recruitment process to book a face to face traditional style interview with designated staff. Unfortunately we get a number of candidates that duplicate bookings for an interview rather than updating their existing booking with a new appointment time.
All of our Bookings update a SharePoint List for use with various automations. I have created a simple flow that checks if the 'customer' has a previous booking with us (by checking email and/or Candidate ID provided by a custom question) and it will identify it as a duplicate Booking on the SharePoint List. However, this still requires a member of staff to look at the List, note that it is a duplicate Booking and then take appropriate action such as cancelling one of the appointment, emailing the 'customer' etc.
I note that when a Booking is made, the 'customer' is redirected to a URL as structured below:
I was hoping to be able to leverage the 'ID' to use in the automation and send an email out to the original email address redirecting them to this link. I cannot seem to find any method of identifying this 'ID' without the use of a Premium Connector. Can anyone offer any solutions?
Secondly, ideally I would like an automation to cancel the duplicated appointment. Is this possible?
