Configure custom email header mapping in New harmon.ie

When users save emails to Microsoft 365, New harmon.ie can automatically create an Email view and map email headers to SharePoint columns.

This article explains how you can customize the mapping of email headers to SharePoint columns, in case your Microsoft 365 environment already has pre-built email views and columns.

Configuring custom email header mapping

Steps:

  1. Prerequisite: Set up the configuration for New harmon.ie.
  2. Download new-harmonie-config.zip and extract it to a local folder.
  3. Edit the extracted .json file:
    The EmailHeaderMapping section includes key-value pairs that set custom email header mapping in harmon.ie:

    • Each key is an email header or column displayed in harmon.ie.
    • The value is an array of mapped static column names as defined in your organization. If different libraries have different columns for saving email headers, define all of them in a comma-separated list.

    Example: "To": ["EmailTo1", "To1"]

harmon.ie’s initial mapping includes a list of static column names as described in the table below. Update the .json file only if your configuration includes other column names.

SharePoint columns used for email header mapping:

EMAIL HEADER MAPPED COLUMNS DESCRIPTION
Attachments [“hrmV2HasAttachments”, “hrmHasAttachments”, “hrmAttachments”, “HasAttachments”, “Attachments”, “Attachment”, “MailAttachments”, “WithAttachments”] Indicates if the email message contains attachments.
Categories [“hrmV2Categories”, “hrmCategories”, “Categories”] Message categories.
Cc [“hrmV2CC”, “hrmV2Cc”, “hrmCc”, “hrmCcOWSMTXT”, “EmailCc”, “Cc”, “MailCc”] The identity of the secondary recipients of the message.
ConversationIndex [“hrmV2ConversationIndex”, “hrmConversationIndex”, “Conversation-Index”, “ConversationIndex”] A unique identifier for the conversation.
ConversationTopic [“hrmV2ConversationTopic”, “hrmConversationTopic”, “Conversation-Topic”, “ConversationTopic”] The common subject of the email thread (without “FW:”, “RE:”). This column facilitates creating a SharePoint view to show related emails.
Date [“hrmV2Date”, “hrmDate”, “EmailDate”, “Date”, “MailDate”] The date and time when the message was sent.
From [“hrmV2From”, “hrmFrom”, “EmailFrom”, “EMailSender”, “From”, “From1”, “MailFrom”, “Sender”] The address of the message sender.
MessageID [“hrmV2MessageID”, “hrmMessageID”, “MessageID”] A unique identifier for the message.
Received [“hrmV2Received”, “hrmV2Recieved”, “hrmReceived”, “EmailReceived”, “Received”] The date and time when a message is received.
Subject [“hrmV2Subject”, “hrmSubject”, “EmailSubject”, “Subject”, “MailSubject”] The subject of the message.
To [“hrmV2To”, “hrmTo”, “EmailTo”, “To”, “MailTo”] The identity of the primary recipients of the message.

Additional key in the .json file

Besides the email header columns, you may also need to define the following key if you’ve used a different name to the email content type:

KEY VALUE DESCRIPTION
ContentTypes [“EMail”, “E-Mail”] Email content types that should be used when uploading an email.