14.1.7. Microsoft Bookings Integration

When Bookings are made through a Microsoft Bookings link, capture the information in Dynamics 365
and update the status field on the Candidate and associated Application record.

Go to https://outlook.office.com/bookings and create a new booking page

Create a new automated cloud power flow using the below connector.

Select the Booking page.

Create a custom table “Microsoft Bookings” in Dynamics 365 and create a record of this table
using the Dataverse connector.

Retrieve the candidate record linked with an email address using the below Fetch XML.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
 <entity name="contact">
 <attribute name="contactid" />
 <order attribute="modifiedon" descending="true" />
 <filter type="and">
 <filter type="or">
 <condition attribute="emailaddress1" operator="eq"
value="@{triggerOutputs()?['body/CustomerEmail']}" />
 <condition attribute="emailaddress2" operator="eq"
value="@{triggerOutputs()?['body/CustomerEmail']}" />
 </filter>
 </filter>
 </entity>
</fetch>

Update the appropriate status on the candidate record using the Dataverse update connector

Retrieve associated applications for the candidate using the below Fetch Xml

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
 <entity name="dcrs_jobapplicationform">
 <attribute name="dcrs_jobapplicationformid" />
 <order attribute="createdon" descending="true" />
 <filter type="and">
 <condition attribute="dcrs_candidate" operator="eq" uitype="contact"
value="@{items('For_Each_Candidate')?['contactid']}" />
 </filter>
 </entity>
</fetch>

Update appropriate application status using Apply to each connector.