Adding Sharepoint List To Outlook

-->

Introduced in SharePoint Framework v1.10, you can implement an Outlook Web App add-in with the SharePoint Framework and use SharePoint as a host for your solution.

Using the SharePoint Framework as the platform for your Outlook Web App Add-ins includes the following benefits:

  • The development model is similar to SharePoint Framework web parts
  • The same code can work across SharePoint, Microsoft Teams, and Microsoft Office
  • Your add-in is automatically hosted for the tenant without requiring you to provision any additional services
  • Simplified authentication to access different services in Microsoft 365
  • You can benefit from the same permission and access management model as within SharePoint, with easy access to Microsoft Graph APIs and other services

Introduced in SharePoint Framework v1.10, you can implement an Outlook Web App add-in with the SharePoint Framework and use SharePoint as a host for your solution. Using the SharePoint Framework as the platform for your Outlook Web App Add-ins includes the following benefits: The development model is similar to SharePoint Framework web parts. To do this, you'd normally need to get out of Microsoft Outlook and into SharePoint. Then, you need to navigate to the relevant List, click on that List, and create a new item. You would need to either type in or copy and paste the details from the email to create your new List item. Manually adding List items is time-consuming and error-prone.

To update the SharePoint task list from within Outlook 2007, click New in the upper-left corner of the SharePoint list to add a new task (Figure D). Click Save & Close. Click Save & Close. SharePoint Ticket System is designed to run as an Outlook add-in. Extends your Outlook as an ideal platform to raise trouble tickets from emails to SharePoint lists. In a click, the system analyzes your emails to extract contact details, problem description and attachments to create a ticket. Manager can input further information to the ticket.

Note

This feature is currently in developer preview feature. In order to use features in developer preview, ensure you use the --plusbeta version of the package. For more information, see: Try SharePoint Framework preview capabilities.

Note

During developer preview, this feature is only supported in Outlook Web Access. Once this feature reaches general availability, it will be supported across all Office desktop and web clients.

Development process

You can start developing Outlook add-ins simply by using the SharePoint Framework v1.10 or later versions. To use this feature in developer preview, you'll need to include the --plusbeta argument when executing the Yeoman generator:

This will create an Office Add-in manifest file for the solution in a new folder called officeAddin. This file is automatically generated with default settings, which enable your web part to be used in the Outlook Web App as a Task Pane extension.

You'll need to deploy the solution to a tenant using the tenant scoped deployment option to ensure that the component can be found in the context of the add-in URL as defined in the manifest XML file. This setting can be adjusted in the package-solution.json file by updating the skipFeatureDeployment as true.

Note

Adding sharepoint list to outlook 365

For more information on the manifest file, see: Office Add-ins: Office Add-ins XML manifest.

Use the Office JavaScript SDK (Office.js) in the web part code

Before you can use the Office JavaScript SDK in your code, you'll need to include the correct types for the solution. You can install the latest types by adding the @types/office-js package to your solution with the following command:

You can detect if the web part is executing within the Office context by using page context as shown on the following property, which refers to the Office JavaScript SDK. This property value is dependent on the context where the code is being executed.

For example, you can access the mail inbox using following property:

Note

For more information on the Office JavaScript API capabilities, see: Office Add-ins: API Reference documentation.

Configuration support with Office Add-ins

Office Add-ins built with the SharePoint Framework support a one-time configuration option when the add-in is initially viewed. This is an optional capability, which can be controlled from the add-in manifest file. The configuration option is controlled in the URL of the solution in the manifest file. By default the configuration option is enabled and the URL is as follows:

If your add-in doesn't have any initial configuration options, you can remove the isConfigureMode query parameter and update the URL. In the example case, that would mean adjusting the URL as follows:

Notice that the componentId query parameter is a solution-specific GUID, which should be replaced with the value for your own component.

Important

The configuration option is only available during initial view of the add-in. It is not supported to re-configure the add-in after the initial configuration. This is currently by design, as there's no similar configuration capability for the normal Office Add-ins. If there's a demand for this capability, please do let us know using UserVoice.

Deployment of your Add-in

Deployment is a two-step process for the Outlook Web App Add-ins:

  1. Deploy solution to SharePoint App Catalog
  2. Use side loading to activate the add-in in Outlook Web App

You can deploy your solution to the Outlook Web App by using the so-called 'side-loading' technique by following these steps:

  1. Move to the Outlook web client using your browser.

  2. Activate one of the existing mails in your inbox.

  3. Select [...] and choose Get Add-ins:

  4. Select My add-ins from the left menu:

  5. Select Add from file... under the Custom add-ins:

  6. Upload the manifest XML file from your project solution under the officeAddin folder.

  7. Select Install on the warning message to get your add-in available on the tenant

  8. Close the add-in window by selecting X in the top-right corner

  9. Activate again the context menu from [...] and select SPFx template to activate the add-in in your inbox (name can be adjusted in the manifest file as needed)

Important

This deployment process is for the preview. The process will change once support is extended to other Office web and desktop applications in the future.

Why do users want to sync SharePoint calendar with Outlook? The ability of viewing a SharePoint calendar in Outlook prevents users from excessive navigation between calendars located at different sites. Apart from the usability purposes, you will gain tangible benefits if you will add SharePoint Calendar to Outlook, like:

  • You can merge events from both calendars into a single view;
  • The Outlook calendar will automatically sync with SharePoint, so you can make changes here and have them reflected there.

One of the super handy features of Microsoft SharePoint is the ability to quickly and easily create a calendar that can be integrated with your Microsoft Outlook. To make this integration, we need to create and authorize a connection between Microsoft SharePoint and Outlook. Once authorized connection is created, SharePoint calendar can then be updated two ways from Outlook to SharePoint and vice versa. That means that you will be able to interact with SharePoint calendar right within Outlook, rather than having to access it from SharePoint website all the time. It also prevents users from excessive navigation between calendars located at different sites.

Adding Sharepoint List To Outlook

In this post, I will explain how you can sync SharePoint Calendar with Outlook.

Connecting a SharePoint Calendar to Outlook

  1. The first step in adding Sharepoint calendar in Outlook is to open the calendar you would like to import. On the ribbon, click Calendar and next select Connect to Outlook.
  1. Find the Connect to Outlook feature from the group “Connect & Export” on the ribbon and click on it to sync SharePoint calendar with outlook.
  1. Depending on which browser you are using a message box may popup asking, do you want to allow this website to open a program on your computer? If prompted, Click Allow.
  1. Next outlook will pop up a message box asking you to confirm that you want to add Sharepoint calendar to Outlook? Click on “Yes” when asked.
  1. If SharePoint site is publicly hosted, it may ask you to log in. Enter your credentials if login box prompted.
  1. Go to Outlook and navigate to your calendar view.
  1. You will be able to see the newly integrated Outlook Sharepoint calendar.

And there is you go! Now you can see the SharePoint calendar in Outlook and adjust its visibility – arrange the calendars stacked upon one another, overlay the calendars in one view, drag-and-drop events across the calendars. You can turn off the SharePoint calendar from the view just by unchecking the corresponding box.

There are a lot many other useful ways to be more productive using connected SharePoint Calendar Outlook. Below are couple of them.

Add Sharepoint List To Outlook 365

  1. Add new event to a SharePoint Calendar Using Outlook
  • Open your Outlook and go to calendar tab.
  • Find the left panel and tick the checkbox left to the SharePoint calendar to which you want to add new event.
  • Select the day and time for the event you want to add and double click on it to open a new appointment window and enter the event details.
  • Select the Save & Close button from the top ribbon Actions group on the Appointment tab.
  • This event now should appear on the calendar as well in SharePoint Calendar in site.
  1. Copy an existing event from an Outlook Calendar to a connected SharePoint Calendar Outlook.

Adding Sharepoint List To Outlook

  • Open your Outlook and go to calendar tab.
  • Click on the event you want to copy in SharePoint Calendar. Please make sure not to double click otherwise it will open the event window.
  • Find the Edit menu, click on Copy to Folder action.
  • In the Copy Items window, go down to the SharePoint Lists option and select the SharePoint calendar in which you want to copy selected event.
  • Click on OK and say ‘Yes’ when asked to continue.
  • That’s it. You should be able to see an event selected in step two on the calendar in your SharePoint site.

Add Sharepoint List To Outlook

How to remove SharePoint Calendar from Outlook?

  1. Open your Outlook and select the SharePoint calendar you want to remove.
  2. Do right click, find Delete Calendar option and click on it.
  3. Click ‘Yes’ to confirm. It will remove the calendar from Outlook, this action does not remove any events. However, you will be able to access the calendar from the SharePoint site.

Add Sharepoint List To Outlook Calendar

✓ USEFUL LINKS ON HOW TO ADD SHAREPOINT CALENDAR IN OUTLOOK