Announcing Microsoft Bookings Power Automate connector - now available in Preview!
Published Jul 28 2022 10:00 AM 74K Views
Microsoft

Need for Microsoft Bookings Power Automate connector

 

Microsoft Bookings currently has a native way to send email & SMS text notifications. We can also send a Microsoft Teams invitation if the user wants to have online services. As our user base continues to grow, our customers are looking to build different workflows and complex integrations. For instance, some of our customers are looking for:

 

  1. Webex & Zoom integrations for online meetings
  2. Stripe integration for payments
  3. Dynamics 365 and Salesforce integration for integrating customer data to Customer relationship management (CRM) systems.
  4. Many custom email workflows

and many more...

 

Building all these integrations natively is difficult, so Bookings needs to develop ways to become a platform that will support all these integrations. 

 

Power Automate is a popular and reliable solution for building workflows. Bookings did not have a Power Automate connector until now and by bringing in Power Automate connectors, Bookings admins can leverage any of the available Power Platform connectors as per their use case to build custom workflows.

 

What does the Bookings Power Automate connector contain?

 

Most of our customers are looking for scenarios based on appointments. With this release, Bookings admins will be able to create webhooks-based triggers to events like creating, updating, or deleting an appointment. Through this flow, admins will be able to: 

 

  1. Create a connection (login) using their Exchange Online account. This Exchange account should be the administrator for your Bookings calendar.
  2. Create a workflow with one of the three Bookings appointments triggers.
  3. Add any of the relevant actions available using one of the other connectors (Zoom, Webex, Outlook, Teams, Salesforce, etc.).
  4. Test the flow and start using custom workflows by performing appointment actions.

 

How can you start using the Bookings Power Automate connector?

 

Head over to Power Automate and look for the Bookings connector. To learn more about this connector, check out this helpful Microsoft Docs article: Microsoft Bookings - Connectors.

124 Comments
Copper Contributor

Hello, 

 

I tried to email email address removed for privacy reasons but the mailbox keeps failing to receive. Nevertheless, I’m exploring the use of one of the three Bookings appointment triggers but am struggling getting the trigger to fire. I am most likely fumbling in the setup. Are there any example walk-throughs or other resources where this is used in action?

 

Also, is Bookings Business SMTP Address referring to the URL for the booking page …or the email server address that the emails associated with the bookings page are sent from?

 

Thank you for your time.

Copper Contributor

@Nathan_Henebury I'm having the same exact issues with this one. I can't get the trigger to fire and I don't know if I should be using the URL for the SMTP address. 

Microsoft

@mmorin7247 : You will just need the SMTP address as mentioned in the FAQ section here: https://docs.microsoft.com/en-us/connectors/microsoftbookings/

 

Vignesh_Kailas_0-1659328281512.png

 

 

@Nathan_Henebury : I guess the same will work for you.

Copper Contributor

Hi, sorry for cross posting but I seem to be having issues with using the connectors Bookings Triggers Failing I am using the correct SMTP. Has anyone else experienced this or is this user error (i.e., me). Thanks.

Microsoft

@Maeve McCooey : Have responded in your original thread. Please take a look.

 

Iron Contributor

No action? Only 3 triggers. We need action to create bookings

Microsoft

@Andrew_Woo : Can you tell me some of the scenarios where "create Bookings" is used as action. We would like to understand user flows here so that we can think of doing some user study and experimentation.

Iron Contributor

At the moment we are doing this and we hope that we can migrate to bookings.

Chatbot (PVA) --> Create Appointment (Gather all the booking information in PVA and push to P/Automate) --> Power Automate will create Task in Planner --> Create Msg in Teams Chat.

If we can replace planner with bookings.
When Appointment is initiated from PVA --> P/Automate --> Microsoft Bookings. 

I hope this can be done.


Brass Contributor

Hello, at the moment it is impossible for me to use the trigger; PowerAutomate tells me: "Bad gateway". I'm so disappointed that it doesn't work. I have been waiting for this possibility for a long time to facilitate my online booking...

Copper Contributor

I think this is great! I've been playing with it in my dev instance, and it is working really well. It opens up a lot of different paths in processes that we've been talking about in our organization.

 

The only issues is that this isn't working in our production environment. We're unable to trigger any Power Automate Flows using the Bookings Connector. We keep getting the following error: {"ErrorMessage":"Staff not part of the booking mailbox."}

 

This is happening with any of our users and we've confirmed that everyone is an admin on the Bookings Page.

I am currently in contact with Microsoft Support regarding this issue and will post updates as we work thru the issue.

Microsoft

@Mwillems40 This issue is resolved now and the fix should be mostly available worldwide now. You can raise a ticket with Microsoft support if this issue still persists.

Brass Contributor

@Vignesh_Kailas Hello, It seems to work. I tried several times this morning with different schedules and I didn't encounter any problems! Thank you !!

Copper Contributor

@Vignesh_Kailas this is great but the one failing is the lack of ability to pull through the answers to the custom questions via the Graph API.  It's a real short coming.

 

To overcome this, I'm retrieving that data via the Calendar/Event API but the problem is, I don't have a direct link back to the booking appointment object from the PowerAutomate trigger and that's my link back to the calendar event.  It doesn't seem to provide me with any GUID or anything that ties everything together.  The SelfServiceAppointmentId property might be plausible but the Graph API provides a null value for that field when I query the appointment and the Id field between the two objects is completely different.  Maybe the transactionId field could be populated with the selfServiceAppointmentId when the event in the calendar is created?!?  There are obviously options.

 

There just appears to be an element of inconsistency between the trigger and Graph.

 

Obviously, solving this ... https://github.com/microsoft/bookings-samples/issues/4 ... would alleviate the issue but still, the PA trigger doesn't even provide a link back to the appointment.  Happy to be proven wrong and shown the way but at this point, I simply don't see it.

 

Would be keen to get your thoughts on this when you have 5.  Thanks!

 

Brass Contributor

I agree with @Skin302 , it's a real problem...

 

 

Microsoft

@Skin302 @Mwillems40 : Acknowledged and thanks for the feedback and continued usage of the connector. "answers to the custom questions" as a part of Bookings triggers will soon be available as we have already picked this item up. Soon, you will not need to use any other way to get what you are looking for.

 

On your question about a common id that you want to use across graph and this trigger, yes we will look into this - selfServiceAppointmentId  or Id should be helping this out. Since that is not the case, Can you please raise a support ticket with Microsoft for that item?

Copper Contributor

@Vignesh_Kailas that's great news.  Re: the support ticket, where exactly do you want that created?  I assume on the Graph github?

Copper Contributor

How to extract custom field information in power flow?

Copper Contributor

Could we have an update on the webex meetings connector? It seems like the app has updated since the template was uploaded, caused me to get the create and authorize oauth connection failed error.

Brass Contributor

Same line of questioning with the treatment of custom fields/questions and how to process them to send them in fields of a MS List as fields / columns for each.

 

Anybody with some working setup of this? 
Seems to want to seperate by customer as soon as we select the Customers Answers output...

Brass Contributor

Does anyone know if there is a way that I could be notified when a new mailbox is created? I ask as we need to change the email from           .onmicrosoft.com to ourdomain.com  

Copper Contributor

I want to be able report summary statistics from a Bookings calendar.  Things like service appointments per user, total time off per user, etc.  Is this possible?

Copper Contributor

@Vignesh_Kailas

Regarding the new Power Automate bookings connectors, I also get the error regarding user not being linked to mailbox.
When a new Bookings service and Calander is created, does it create a whole new O365 user account linked to that calendar- thus meaning it has its own username (and password) details of which would only be accessible by overall organisation admin?
I have looked at the connector permissions which are my details only.  I wonder if that is what is generating the error message when I attempt to run the flow.
Any help would be appreciated
Copper Contributor

@wyliegr 
I am running to the same issue in my organizations environment. I have my own sandbox environment thru the Microsoft's Developers Program and it works great there. I contacted the Power Automate Support Team (more on them in a moment) and they escalated my incident to the Developers team. I've been working with them for about a month now. (Supposedly they are supposed to be releasing a fix this weekend, but the last one didn't work)

I suggest that you contact the Power Automate Support Team. That can be done via the Power Automate Admin Console. I would suggest including in your ticket to be escalated to the Developers Team. When I was in contact with the Power Automate Support Team my experience with them was very, let's say unprofessional and that they are there to collect a paycheck. So I would recommend just pushing thru them as fast as you can. Once you get to the dev team, they will request a video of you setting up a new Bookings Calendar and Power Automate Flow (I kept my flow basic: when a new Bookings Appointment was created it posted a message to my MS Teams Chat with the Flow Bot) while recording the network log for them. I've done that process twice now.

The connector looks amazing and once these bugs are fixed and it's out of preview, I think it will be a game changer when it comes to Bookings.

Copper Contributor

So not sure if there has been an update but no longer mailbox error but a new one saying ‘JSON error’

I give up…

Copper Contributor

…and now back to the original error of not part of mailbox  #RollsEyes

 

Brass Contributor

Has anyone been able to work a flow that process multiple "Custom questions" toward a MS List or excel etc .. ?

If yes, Examples? Detaisl? Screenshot?

Copper Contributor

@Jonathan Leclerc which part are you struggling with exactly?

Copper Contributor

@Jonathan Leclerc

Im no expert but could you ‘parse’ the text with code (see YouTube videos etc) from the confirmation booking email and then use the output to send to a List or excel column? 

Copper Contributor

@Jonathan Leclerc @wyliegr you do it by querying the extension fields of the associated calendar entry. That gives you back a base64 encoded string that is the JSON array representation of the custom questions with answers. From there, you can process the array and do what you need with it. I’ve done it to the point where I’m populating an Excel invoice template and then converting that to a PDF and sending it off to the customer.

 

This helps a lot … https://github.com/microsoft/bookings-samples/issues/7

Copper Contributor

wow that sounds neat. But probably way beyond what I could cope with. 

Would you share some flow images with the example expressions? 

Is this using the Bookings connectors (which doesn't seem to work for me) or can it be done from a Get Calendar Event flow?

Thank you for your time

Copper Contributor

@wyliegr nah, you'd be fine.  You need to have a little more faith in your ability.  :smile:

 

Let me try and give you the gist.

 

Determine Associated Calendar Event for Booking Entry

 

Firstly (and you'll see from the thread above) there is no hard link between the booking and the calendar event.  This is a bit of a pain given you have to find the associated calendar event rather than just getting it from the an ID attached to the booking.  I raised that in a comment above but that's as far as it got.

 

I do that by making a call to the list calendar events Graph endpoint and order the list by last modified date.  The url looks like this ...

 

https://graph.microsoft.com/v1.0/users/@{variables('Booking Business ID')}/calendar/events/?$expand=singleValueExtendedProperties($filter=id eq 'Binary {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemAnsweredCustomQuestions' or id eq 'String {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemCustomerName' or id eq 'String {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemCustomerEmail' or id eq 'String {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemCustomerPhone' or id eq 'String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationDisplayName' or id eq 'String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationStreet' or id eq 'String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationCity' or id eq 'String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationState' or id eq 'String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationCountry' or id eq 'String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationPostalCode')&$orderby=lastModifiedDateTime DESC

 

You can see the variable I have in bold which contains the name of my booking calendar, this will be the booking calendar SMTP address associated with your booking business ID.  Also, any call to that API will require auth but that's a whole other topic.

 

All of those expand clauses tells the API call to retrieve all of that additional information that was captured when the booking was made and is specific to the bookings application.

 

If I list them out, they're much easier to see ...

 

  • Binary {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemAnsweredCustomQuestions
  • String {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemCustomerName
  • String {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemCustomerEmail
  • String {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemCustomerPhone
  • String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationDisplayName
  • String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationStreet
  • String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationCity
  • String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationState
  • String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationCountry
  • String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationPostalCode

You can see they're all strings except the custom questions because it's (as previously stated) a base64 encoded string that when converted, is the JSON representation of the custom questions.

 

I then use the customer name, customer email and customer phone fields along with the booking start/end date and the customer ID to determine if the calendar event lines up with the booking.

 

This is an example of a response for the calendar event ...

 

{
  "@odata.etag": "W/\"b8EZoO6pU0KB88QMOxZVP...\"",
  "id": "AAMkADJkMjI3N2E5LWZ...",
  "createdDateTime": "2022-11-17T22:11:50.7977695Z",
  "lastModifiedDateTime": "2022-11-18T12:02:54.3001651Z",
  "changeKey": "b8EZoO6pU0KB88QMOxZVPAAAECJukA==",
  "categories": [
      "Somewhere"
  ],
  "transactionId": null,
  "originalStartTimeZone": "AUS Eastern Standard Time",
  "originalEndTimeZone": "AUS Eastern Standard Time",
  "iCalUId": "040000008200E00074C5...",
  "reminderMinutesBeforeStart": 15,
  "isReminderOn": true,
  "hasAttachments": false,
  "subject": "Half Day Booking",
  "bodyPreview": "********************************************************\r\n NOTE: This is a read-only view of the booking.\n Please use Microsoft Bookings for web, iOS or Android to edit this booking.\n Any changes made here will be lost.\r\n**********************************",
  "importance": "normal",
  "sensitivity": "normal",
  "isAllDay": false,
  "isCancelled": false,
  "isOrganizer": true,
  "responseRequested": false,
  "seriesMasterId": null,
  "showAs": "busy",
  "type": "singleInstance",
  "webLink": "https://outlook.office365.com/owa/?itemid=AAMkADJkMjI3...&exvsurl=1&path=/calendar/item",
  "onlineMeetingUrl": null,
  "isOnlineMeeting": false,
  "onlineMeetingProvider": "unknown",
  "allowNewTimeProposals": true,
  "occurrenceId": null,
  "isDraft": false,
  "hideAttendees": false,
  "responseStatus": {
      "response": "organizer",
      "time": "0001-01-01T00:00:00Z"
  },
  "body": {
      "contentType": "html",
      "content": "<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">\r\n<meta nam..."
  },
  "start": {
      "dateTime": "2022-12-04T21:45:00.0000000",
      "timeZone": "UTC"
  },
  "end": {
      "dateTime": "2022-12-05T02:15:00.0000000",
      "timeZone": "UTC"
  },
  "location": {
      "displayName": "",
      "locationType": "default",
      "uniqueIdType": "unknown",
      "address": {},
      "coordinates": {}
  },
  "locations": [],
  "recurrence": null,
  "attendees": [
      {
          "type": "required",
          "status": {
              "response": "none",
              "time": "0001-01-01T00:00:00Z"
          },
          "emailAddress": {
              "name": "Somewhere",
              "address": "email address removed for privacy reasons"
          }
      }
  ],
  "organizer": {
      "emailAddress": {
          "name": "Bookings",
          "address": "email address removed for privacy reasons"
      }
  },
  "onlineMeeting": null,
  "singleValueExtendedProperties": [
      {
          "id": "Binary {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemAnsweredCustomQuestions",
          "value": "W3siQW5zd2VyIjpudWxsLCJPcHRpb25zIjpbIk5vIiw..."
      },
      {
          "id": "String {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemCustomerName",
          "value": "John Smith"
      },
      {
          "id": "String {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemCustomerEmail",
          "value": "email address removed for privacy reasons"
      },
      {
          "id": "String {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemCustomerPhone",
          "value": "123456789"
      },
      {
          "id": "String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationDisplayName",
          "value": "123 Smith Place"
      },
      {
          "id": "String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationCity",
          "value": ""
      },
      {
          "id": "String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationState",
          "value": ""
      },
      {
          "id": "String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationCountry",
          "value": ""
      },
      {
          "id": "String {a719e259-2a9a-4fb8-bab3-3a9f02970e4b} Name CustomerLocationPostalCode",
          "value": ""
      }
  ],
  "calendar@odata.associationLink": "https://graph.microsoft.com/v1.0/users('email address removed for privacy reasons')/calendars('AAMkADJkMjI3N2E5...')/$ref",
  "calendar@odata.navigationLink": "https://graph.microsoft.com/v1.0/users('email address removed for privacy reasons')/calendars('AAMkADJkMjI3N2E5LW...')"
}

 

You can see all of the booking questions contained within the singleValueExtendedProperties property and you can clearly see the custom questions (although I cut it off) is a base64 encoded string.

 

Extract Custom Questions

 

Once I have the associated calendar event, I can then extract the custom questions.  Obviously, my solution isn't that simple and there's a fair bit going on but in relation to the custom questions, this is the basic approach.

 

Firstly, I filter the singleValueExtendedProperties array using this expression ... @endswith(item()?['id'], 'BookingItemAnsweredCustomQuestions')

... within a filter action.  That gives me the item.  Based on the above example, this is the item I get ...

 

{
  "id": "Binary {ccb88e73-951a-4b10-bb49-e6628b8d8494} Name BookingItemAnsweredCustomQuestions",
  "value": "W3siQW5zd2VyIjpudWxsLCJPcHRpb25zIjpbIk5vIiw..."
}

 

I then inject a Parse JSON step passing in the value (Content = first(body('Filter_For_BookingItemAnsweredCustomQuestions'))?['value']) from the item with the following schema ...

 

{
    "items": {
        "properties": {
            "Answer": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "Options": {
                "items": {
                    "type": "string"
                },
                "type": "array"
            },
            "Question": {
                "type": "string"
            },
            "QuestionGuid": {
                "type": "string"
            },
            "Required": {
                "type": "boolean"
            },
            "SelectedOptions": {
                "items": {
                    "type": "integer"
                },
                "type": [
                    "array",
                    "null"
                ]
            }
        },
        "required": [
            "Answer",
            "Options",
            "Question",
            "QuestionGuid",
            "Required",
            "SelectedOptions"
        ],
        "type": "object"
    },
    "type": "array"
}

 

... that then gives me the custom questions in a format that looks like this ...

 

[
  {
    "Answer": null,
    "Options": [
      "No",
      "Yes"
    ],
    "Question": "Do you have any dietry requirements?",
    "QuestionGuid": "fe27a8a5-d331-4377-af44-cb1a41453614",
    "Required": false,
    "SelectedOptions": null
  },
  {
    "Answer": "Yes",
    "Options": [
      "No",
      "Yes"
    ],
    "Question": "Are you older than 40?",
    "QuestionGuid": "7c8710a1-e1ab-46cc-bd3b-62922efc45c7",
    "Required": false,
    "SelectedOptions": [
      1
    ]
  },
  {
    "Answer": null,
    "Options": [
      "No",
      "Yes"
    ],
    "Question": "Are you a male?",
    "QuestionGuid": "acb4b20b-b394-4935-93ac-19fb0b5375eb",
    "Required": false,
    "SelectedOptions": null
  }
]

 

... and voila!  I now have my custom questions/answers and can do with them what I please.

Copper Contributor

@wyliegr also, yes … it’s all triggered by the booking event triggers (create, change, cancel) that PA/LogicApps offers. Those triggers don’t give you much though, hence why I have to find the associated calendar event each time. Apparently Microsoft are working on providing that through the bookings API’s though. Not sure on when though.

Copper Contributor

Looks like Ive a bit of reading to do!

Thanks for taking time.

Copper Contributor

Hi guys… just another little update with what ive tried. There was a bit of confusion with the admin calendar event email… i hadn't realised its not treated like an email… but… if you forward the even to yourself it becomes an email… with all the booking details (time date, custom fields etc) in free text format.  I was then able to create a flow and extract the booking text I needed and then use it   ie in a List or forward on to anyone that needs to booking data.  Maybe a bit clunky forwarding myself emails (and I had to avoid a constant loop) but has worked ok. You can either use Rules in Outlook to autoforward, or create a flow just for that aspect (or maybe it could even be combined).

While I have no apparent access to working official Booking connectors.. maybe this might help someone. 

Brass Contributor

This will stay as it is for me until Microsoft manage to get their s*** together and provide an 'easier' solution with more common sense dans all those hoops we have to go through. Won't take all  that time to make something complicated and not 'direct' from the connector work to have a working solution in Power Automate provided from MS like 3 weeks after! #despair

 

Copper Contributor

I’m having an issue using the Connector for Bookings. The ID given by the connector is NOT the Booking_ID of the record, as it is exported in the TSV file; instead of that a different ID is provided by the connector each time even if canceling or editing an existing booking, so there is not a possibility to link the transaction to the real booking.

 

Please fix this or show a workaround.

Copper Contributor

any sign of fixes, updates or refresh for Bookings connectors?  Still essentially unusable for me (and I suspect a lot others). 

Copper Contributor

Just wondering (before I spend time on this) if it is possible to Automate Repeat appointments in the booking calendar using Power Automate (would be better if that was builtin as an option to the booking calendar). 

 

Thanks in advance. 

Copper Contributor

@wyliegr, we're still have this issue. I got an email from Microsoft last week telling me that my support ticket was escalated to the Engineering Team.

@Isabel2380, I've noticed the same thing in our instance. Not sure if there is a fix or a workaround. I have a feeling that this was a side effect of them trying to get the Bookings Connector passed the 'Not a staff member' error. 

Copper Contributor

@Miles_Derksen, Good question. It does not look like the Bookings Connector has any actions associated with it. Just triggers for when a Bookings appointment is created, modified, or cancelled. I guess that you could associate the mailbox behind the Bookings Calendar to other connections like Outlook or such to try to create the appointments automatically that way, but to me that seems outside the scope of what Bookings is intended for.
But if you are looking to say have a power automate flow that addresses if the same user has created more than one appointment, then there is some potential for that, but I think that would require a bit of database work as well.
Hope this helps!

Copper Contributor

Thanks for the reply - unfortunately for my staff, not having the ability to creating REOCCURRING appointments seems to be a "deal breaker" for using the bookings calendar. They say it is far too tedius to enter them all manually and I do agree. I wish that the bookings calendar had this one feature. 

Copper Contributor

@Miles_Derksen, If the appointments are repeating appointments just in terms of blocks and not around individual users, so say I only offer a webinar on Bookings every Monday between 8am and 12pm and anyone in my organization can sign up, then you can setup a service to repeat every week. But if you are looking to have a process that can schedule the same appointment with the same users automatically, then I think that is outside the scope of Bookings.

You might want to explore Power Apps though for something like this. That might give you the functionality that you're looking for.

Copper Contributor

I just got the following update from Microsoft for this issue:

The team has discovered the root cause and are already working on fix. The cause of the issue as highlighted by the team is caused by the mismatching of the SMTP's.  This on the back end is seen to create multiple SMTP's.

Copper Contributor

sounds like we might be on track… I have a feeling that was the issue I suspected from the outset.

The sooner we get an update fix to try the better as I have a project needing this to work! 

Copper Contributor

@Isabel2380 @johnsoep 

I have found a solution for the different Booking IDs scroll down to see my 2nd comment.

 

Below is to identify why it doesn't work

 

 

 

Work around for different Booking_ID

 

I also noticed the booking ID's are different, however did notice a pattern when creating and modifying.  From my findings, the letters that change for the SAME event are in BOLD below.  But, I also noticed the string after the "+" remains the same for that event, which seems to be unique for different bookings (tested up to 7 bookings).  Maybe you can play with this more?  This connector has too many work arounds for me (extracting the string in ID, and parsing Custom Questions answers...) to activate for use... I'm currently using my own custom built Bookings > Google Calendar flow using Outlook ID.

 

Example ID:

Create:

FrtLYw65qZBAtZTBSkqrh3QAAdUGlIhGAAAAAF1YRxoQw+VFrKfB9SIHkycHALtLYw65qZBAtZTBSkqrh3QAAAAAAQ0AALtLYw65qZBAtZTBSkqrh3QAAdUQ01cAAE4=

 

Modify:

FrtLYw65qZBAtZTBSkqrh3QAAdUGlKZGAAAAAF1YRxoQw+VFrKfB9SIHkycHALtLYw65qZBAtZTBSkqrh3QAAAAAAQ0AALtLYw65qZBAtZTBSkqrh3QAAdUQ01cAAE4=

Microsoft

@Miles_Derksen : Would like to understand more about the repeated actions that you have mentioned above. We are still considering actions as a part of connector and would love this feedback.

Copper Contributor

I would prefer if we all got any access first - rather than dealing with smaller issues !  Lots of us still have the connectors unusable because of the (? smtp) mailbox issue.  If that was sorted we could give lots of feedback

Copper Contributor

***

 

 

Copper Contributor

I got this email from Microsoft Support regarding this issue:

"The team reached out to appeal with you for more time due to the programmatic procedure in fixing and release an update to all affected customers.

 

Due to this procedure, there is currently no ETA for the roll out as informed by the product team. However, the Engineering team are readily available to give updates as it arrives.

 

Updates will be sent directly to the inbox of affected users message center in office 365 admin center along side myself and team reaching out to you."

Copper Contributor

Hi,

I made a summary of bookings in the Sharepoint list, in the CustomerNotes field there is a prefix "'-----Note added by customer on..." - does anyone know how to get rid of it so that only the content of the customer's note remains?

 

Does anyone know when it will be possible to use custom questions/fields from Bookings in PA?

 

Hope this is the right place for that kind of questions.

Co-Authors
Version history
Last update:
‎Dec 08 2022 10:45 AM
Updated by: