Forum Discussion
Power Automate and Bookings - update an appointment duplication
Hi there
I am fairly new to PowerAutomate, but have a couple up to work with MS Bookings; one to add a row when an [group] appointment is created, and one to add a row when an [group] appointment is updated (in Excel).
However, the "update an appointment" adds all the people in to the list again who are in already in the appointment, not just adding the extra person on the end who has added themselves to the group booking. For example, how do I stop the [DUPLICATE] entries in the example below:
Time | Name | For example: |
13/10/23 - 10:10 | Joe Bloggs | Created the appointment - first person to book [NEW] |
16/10/23 - 11:00 | Jenny Bloggs | Created the appointment - first person to book [NEW] |
13/10/23 - 10:10 | Joe Bloggs | Created the appointment - first person to book [DUPLICATE] |
13/10/23 - 10:10 | Joseph Bloggs | Updated the appointment - second person to book [NEW] |
13/10/23 - 10:10 | Joe Bloggs | Created the appointment - first person to book [DUPLICATE] |
13/10/23 - 10:10 | Joseph Bloggs | Updated the appointment - second person to book [DUPLICATE] |
13/10/23 - 10:10 | Josephine Bloggs | Updated the appointment - third person to book [NEW] |
16/10/23 - 11:00 | Jenny Bloggs | Created the appointment - first person to book [DUPLICATE] |
16/10/23 - 11:00 | Joanna Bloggs | Updated the appointment - second person to book [NEW] |
I have these Flows (similar for when an Appointment is Created):
If I take the "Apply to each" out, it creates errors. I just want the [NEW] entries in my example, and not the [DUPLICATE]s added again! Many thanks in advance.
1 Reply
- Vignesh_Kailas
Microsoft
jupjam9: This is not possible today as a direct approach as the entire payload is sent as a part of bookings notification to power automate. But if you are updating this to excel, you can use a unique field like phone number or email of the customer to check if the entry was added already.
As of now, there is no delta support for the connector notification.