How to: Book Exchange Online resources in a SharePoint on-premise Calendar

It’s possible to book Exchange rooms when scheduling meetings directly in SharePoint if you use our Calendar Email Extension, Employee Training Management and Event Management. If you use one of the solutions above for SharePoint on-premise and your Exchange is already on Office 365, please follow the instructions below.

Prerequisites

  • You have to enable SSL for your SharePoint server. You have to be able to access the SharePoint site using https://.
  • You have to install the latest version of the solution.
    Download: sapiens.at.setup.addons.rs.zip
  • You have to be a global administrator in your Office 365 tenancy

Configure the ‘Exchange Room and Equipment Selector’ column

If you want to connect the column to Office 365, select Exchange Online/Office 365 and click on Authorize.

Exchange room and resource selector

Now you have to enter your Tenant ID, a Client ID and Client Secret.

Client ID, secret and tenannt id

To get your Tenant ID, Client ID and Secret, you first have to register an application in your Azure Active Directly.

To call Microsoft Exchange online, the app must acquire an access token from the Microsoft identity platform. The access token contains information about the app and the permissions it has for the resources and APIs available through Microsoft Exchange online. To get an access token, your app must be registered with the Microsoft identity platform and be authorized by either a user or an administrator for access to the Microsoft Exchange online resources it needs.

  1. Sign in to the Azure Active Directory using either a work or school account or a personal Microsoft account.
  2. In the left-hand navigation pane, select the Azure Active Directory service. Copy the Tenant ID in the overview and paste it in the Your Tenant ID field in the form.
  3. Now select App registrations > New registration.
  4. When the Register an application page appears, enter your application’s registration information:
    • Name – Enter a meaningful application name like ‘SharePointSapiens Resource Selector’
    • Supported account types – Select which accounts you would like your application to support. In this case select Accounts in this organizational directory only
    • Redirect URI (important) – Select Web as the type of the app you’re building and then enter the following redirect URI.
      https://yourdomain.com/sites/yoursite/_layouts/15/Sapiens.at.SharePoint.CEE.ResourceSelector/Consent.16.0.aspx
      https://yourdomain.com/sites/yoursite/_layouts/15/Sapiens.at.SharePoint.CEE.ResourceSelector/Consent.16.0.aspx
    • Now click on Register.
    Azure AD assigns a unique application (client) ID to your app, and you’re taken to your application’s Overview page. Now copy the Application (client) ID and paste it in the Client ID field in the form.
  5. Click on Certificates & secrets and click on + New client secrets in the Client secrets section. Choose the expiration and click on Add. If you choose 1 or 2 years, make sure you create a new client secret and update it in the column configuration before the current secret expires. Copy the created client secret and paste it in the Client Secret field in the form.
  6. Click on API permissions, click on Add a permission and select Exchange and then Delegate Permissions, EWS and select EWS.AccessAsUser.All and click on Add permissions.
  7. Click on API permissions again, click on Add a permission and select Microsoft Graph and then on Delegate Permissions, User and select User.ReadBasic.All.

Now click on Next in the form and sign in with the user account you want to use to book resources, either directly in the resource calendars (configure Application Impersonation in Exchange) or by inviting the resources from the user account’s calendar. Accept the configured permissions for the app you configured previously in the Azure Active Directory. Now click on Close and continue with the configuration of the Exchange room and equipment selector column.