Error message Bookings Automate
Hi all, For my current position I use MS Bookings to have customers book appointments for training dates. I then use Automate to register this information to a SP list. I used to use a workaround, but since the Bookings connector was released it seems to not contain all the necessary information it used to before. Using the new connector i get the following error message I've seen others post as well, but haven't seen a resolution yet. Staff not part of the booking mailbox. I am however the sole owner of the bookings calendar as well as the admin on the Automate flow. Can anyone help shed a light on this?'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!
Power Automate to Add Row to Excel from MS Bookings
Hi All, I'm a basic Power Automate user so looking for some help. I can see Bookings now works with Power Automate. Is there a way to create a power Automate to Update a staff training tracker (Excel Spreadsheet) once a course has been completed - or even when a booking is made. I have similar Power Automates running with MS Forms, so when a form response is entered, it updates a line on a spreadsheet. I'm using this for course feedback, NPS stats etc. I'd like to use this same approach to limit the admin work of keeping training trackers updated. Even if it updates the spreadsheet on booking, it will be less time to just delete the attendee that maybe couldn't make the booking - rather than updating it each day with attendance for multiple bookings. The TSV file you can get out seems annoying, isn't intuitive and I have to convert in order to see it in Excel. Seems odd that there isn't just an easy Excel export - Longer than 120 days! Any help would be greatly appreciated 🙂 Thanks in advance, Jess
Extracting Custom Question Answers with Power Automate
I am working on developing an N:1 bookings page where several people are able to register for the same time slot. We ask several custom questions and the end goal is to use the Power Automate connector to extract that data, put it into an Excel sheet, and import into our CRM. I am tried several different methods to extract the custom question answers without success. Has anyone been able to make this work?MS Bookings and Power Automate - Missing custom field answers in 1 on 1 bookings
Hi, I've been using the MS Bookings connectors in Power Automate. I am able to extract all relevant information in 1 to N types of bookings, but in the 1 to 1 bookings, the answers to custom fields are not being sent to the Power Automate flow. It is missing in the json input, so it is not sent from MS Bookings itself. In 1 to N bookings, there is the "Answers" section, which is missing in the 1 to 1 input: The default fields content is all being sent, so as far as I know, the problem is only occuring with custom fields.
Power Automate Group Bookings to SharePoint
Hey guys, Has anyone managed to use power automate to pull data from Microsoft Bookings into a SharePoint list, to keep a record of things like attendance? Specifically I'm interested for group bookings, as the automate trigger for a new booking seems to only work with the first person booked onto a group session. Additional people booked on would use the updated booking trigger but I don't know how to separate the new data from data that may have already been pulled over. I dunno if that made any sense but any ideas? James 🙂
Block my bookings when a colleague is busy
Hi, i have a small team and as such we cover each other’s roles despite having defined positions. I deal mainly with support and my colleague deals manky with implementation so i have set up two booking pages one for existing clients “support” and one for new clients “demonstrations” and all is well with that but ideally if my colleague gets a booking for a demo i would need to block my schedule for that time also as i would need to be free to deal with anything that came in during that time and vice verser if i had a meeting they would need to be free to support. Perhaps there’s a way do to this through outlook or power automate? i’m just looking for ideas really.
Staff and customer joining different teams rooms
Good evening Let me start by explaining our use case, we use Microsoft Bookings as an exam booking utility. This would be 1:1 bookings. It is a requirement to keep the examiners identity hidden until the exam day due to bribery and corruption purposes. We have found a workaround for this by renaming the staff to the appropriate Team for example TEAM A Examiner and TEAM B Examiner, although the workaround works it is very difficult to keep on top of the scheduling. In the "Old" version of Bookings you could see the initials on the calendar which made it easier but not perfect on the "New" the calendar it doesn't pull through the initials correctly at all. Is there anything we can do to make sure the examiners names are not visible to booking candidates? Secondly we have also notice that intermittently the Teams link places the "examiner" and "candidate" into different Teams rooms this especially seems to be a case when the exam is rescheduled to a different day. This causes extra work to make sure that both parties are in the same room. The result of this is that some candidates end up failing their exam by default (did not Attend) through no fault of their own this can cause reputational damage and further costs incurred by the candidate. We have been able to replicate this on occasion but it is intermittent. Thirdly I am very pleased that Microsoft have started to integrate Power Automate to Microsoft Bookings we have a set up currently that the once a Service (Exam) is booked we use the extracted data to populate a dataverse table for power apps, Is there any timescale as to when further power automate functionality will be implemented in particular the use of Custom Questions in Microsoft bookings we currently use them, the candidate is required to complete all questions including a field for a unique ID number. We then use this to validate an Exam and to ensure that the link has not just been forwarded from one candidate to the next. Currently in Power automate I see the options for Customer Answers but this produces no results. Kind regards Smidge1990
MS Bookings as a Trigger in Power Automate
When will we be able to use Microsoft Bookings as a Trigger in Power Automate? I have a booking automation built that is in dire need of a trigger in Power Automate from a company that my company already has an MSA, for example Microsoft. Bookings is very lovely but I need the ability to tie it into other processes utilizing Power Automate to really get the job done. Does anyone have any information on this? Can I get a webhook at least?
