Issue Tracking with SharePoint Ticket System

Use SharePoint ticket system to quickly raise tickets from Outlook emails to SharePoint issue tracking lists. Track incoming emails automatically, apply SLAs, use KB articles to answer to recurring questions and much more.

Highlights:Toolbar options under Outlook for SharePoint ticket system

  • Raise tickets from emails in Outlook to one or more SharePoint lists.
  • Enforce service level agreements (SLA), assign technician and due date.
  • Automatically track and add email responses and replies to ticket.
  • Edit or add comment to existing ticket directly from Outlook.
  • Automatically send out notification alerts on ticket events.
  • Search and query SharePoint tickets directly from Outlook.
  • Automatically monitor due date lapse and notify technician and managers.
  • Automatically insert due date appointment into the calendar of the technician.
  • Maintain a consolidated and hierarchical view of of email conversations in the ticket.
  • Update a SharePoint Calendar list, with all the ticket due date appointments.
  • Export caller contacts, problem descriptions and attachments from emails to the SharePoint tickets.
  • Integrated Knowledge Base in Outlook and SharePoint.
  • Work on your assigned tickets directly from your Outlook, without ever opening your SharePoint site.
  • Integrated OLAP Statistics & Summary Report Generator tools.
  • Seamless Integration with Microsoft Outlook (2010, 2013, 2016, 2019).
Available in multiple languages:
English Arabic France Dutch Swedish Polish Italian Germany Turkish Spain Japanese
Works with
SharePoint ticket system for Outlook 2016/2019  SharePoint ticket system for Office 365

The inbuilt issue tracking list in SharePoint is only good for basic tracking requirement as it lacks the automation workflow.

Moreover, there is no direct and easy way to source information from emails in Outlook to the SharePoint ticket system. May be, except to resort to copy-paste trick. However, such workaround is time consuming and laborious, and not to mention, the precious human resources needed for data gathering.

Limitation of issue tracking in SharePoint

In particular, one of the important goals for a ticketing system, is staying on top on the growing amount of support requests. But without an organized and structured link between Outlook and SharePoint, caller and problem information from emails cannot be added or updated to the SharePoint ticket system, in a timely manner. This can lead to delay in response time and even support requests falling through the crack. These limitations prevent many support teams from implementing an effective SharePoint ticket system.

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.

The seamless integration of SharePoint ticket system in Microsoft Outlook

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, such as, agents responsible for solving the issue, due date, SLA etc.

Once a ticket is generated successfully in the chosen SharePoint list, information regarding the ticket (e.g., ticket ID, time and the URL) are embedded into the email item in Outlook. This not only provides an easy way to jump to the ticket directly, but also prevents other technicians from generating a duplicate ticket.

Lastly, because users are already familiar with Microsoft Outlook and SharePoint, no special training or skill sets is required. As a result, there is a high rate of user adoption of the SharePoint ticket system in the organization.

How It Works - SharePoint Ticket System

SharePoint ticket system is available as an Outlook add-in. It makes working on support requests very easy by seamlessly integrating the process of submitting, assigning, tracking and fulfilling SharePoint tickets, all inside Microsoft Outlook.

Before you can start raising tickets from Outlook emails, you would need to choose the destination SharePoint lists where the tickets can be collected and shared.

Choose the SharePoint lists that will store the tickets raised from Outlook by the ticket system.

Mapping between Outlook Email fields and SharePoint List fields

It is followed by fields mapping between the Outlook mail and SharePoint list. In the first place, a mapping is nothing but an association between an Outlook field (e.g., subject of the mail item) to a specific SharePoint list field (e.g., Title). As a matter of fact, you have complete control over which data goes to the SharePoint list from Outlook.

The mapping of email and SharePoint fields as part of the ticket system

Through the mapping tool, choose which information from the emails would be carried over to the SharePoint ticket. This is usually done by simply mapping those email fields and the SharePoint list fields. If required, you can dynamically create new field in the SharePoint list, to hold certain information from the email.

The toolbar for the SharePoint ticket system is available in every folder in Outlook, as can be seen below.

The toolbar of the SharePoint ticket system as seen in Outlook folder

To raise a new trouble ticket, select an email and click the ‘Raise Ticket in‘ drop down menu. And from among the SharePoint lists, choose one under which the ticket will be generated and stored.

The SharePoint lists that are available for selection to store tickets raised from Outlook by the ticket system

Consequently, a new ticket item is created with a unique ID in the chosen SharePoint list. Alongside, it populates information such as contact details, problem description and attachments extracted from the email, to the ticket.

Ticket form in Outlook

You can add additional details to the ticket, by using the ticket form in Outlook. For instance, assign technician, set due date or SLA, problem category, type and status and any number of custom metadata.

The ticket form in Outlook after loading a ticket ID from SharePoint

Once a trouble ticket is generated successfully in the chosen SharePoint list, information regarding the ticket, such as the ticket ID, data/time and the URL to the SharePoint ticket are tagged and embedded into the email item in Outlook. This provides an easy way to jump to the ticket item in the SharePoint site directly. Additionally, it prevents other technicians from generating a duplicate ticket, from the same email. A possible scenario on shared mailboxes and mail-enabled public folders.

The ticket ID embedded in the email after a ticket is raised from it.

Ticket item in SharePoint

In the SharePoint ticket item, most of the fields are populated with the metadata information extracted from the Outlook email. For example, contacts detail, problem description, subject, attachments, formatting, inline images and links are retained in the ticket. Additional information fed by the manager in Outlook, such as the responsible technician, due date, problem category and status and other custom fields data are also available in this ticket.

The consolidated conversation field showing all the communication that had happened so far on that ticket.

In the email from which a ticket was raised, there is an embedded phrase within brackets in the subject. Significantly, this phrase contains the SharePoint list code and the ticket ID of the raised ticket item. For example: [CMA-4]

The ticket ID embedded in the subject of the email from which a ticket was raised
Moreover, this phrase is embedded to the original email for tracking purpose, as well as, on subsequent emails conversations. As long as it is intact in the subject, the add-in will automatically track and link replies received or response sent, with the correct ticket.

The ticket ID is retained in outgoing email

Along with that, the latest information from the incoming or outgoing emails are automatically updated to the ticket item. This enhances the productivity of the ticket system as no technicians are required to monitor the mailbox manually. The SharePoint ticket system automatically does that for you.

The problem description field of the ticket showing all the email communications on the issue

Automated Email Alerts

Automated notification emails are sent out to the caller, confirming about the ticket allotment. A corresponding entry about the alert is also inserted into the ticket description. Likewise, a notification about the ticket assignment is also send to the assigned agents.

The snippet entry of the automated alert embedded into the ticket for reference

When further email responses are sent out to the caller from the ticket system, the description field of the SharePoint ticket is automatically updated, to show the response made to the caller, and by whom.

The snippet entry that is added to the problem description field when a new reply or response is processed by the SharePoint ticket system

When the caller replies back to the support team, the ticket information is automatically updated again.

The SharePoint ticket system provides an easy way to automatically raise new tickets to SharePoint lists from incoming emails. Notably, automation spares you from having to do the laborious work of monitoring emails and converting to tickets manually.

The automatic ticketing panel in SharePoint ticket system

Knowledge base Article

A resolved ticket can be a good source of information for future reference. Therefore, it is a good practice to create a new knowledge base entry out of it. The KB article is then available in the list of articles in a dedicated SharePoint list, categorized and sorted. These articles are then ready for your technicians to draw from, when similar issues arise. Manager can also make these KB articles public, so that end-users can seek first level support to their queries.

The KB articles grouped by Problem Category in SharePoint

Generate Reports in SharePoint Ticket system

It is critical to identify problem areas to increase the efficiency of the ticket system. One such way is to collect valuable intelligence and trends by generating meaningful reports on tickets.

The summary report panel of the SharePoint ticket system

Generate summary reports to get appraisal on the current happenings on the ticket system. Track recent tickets generated, worked, closed or reopened in SharePoint.

0
With over 2000+ customers across 50 countries including fortune 500 companies, government and non-profit agencies, freelance consultants, educational institutions and universities, etc.

What people are saying about our SharePoint Ticket System

** Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.